Re: Problem with measures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I agree with Vladimir.

I (belatedly) arrived at the same conclusion today. This is a
granularity issue more than an aggregation issue. Based on the sample
given, hours does not belong in the fact table with the invoice data.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eZyov$OIGHA.1288@xxxxxxxxxxxxxxxxxxxx>, vc.nospam@diacom-
systemhaus.nospam.de says...
>
> Hi
>
> number of hours it took to process a order is attribute of the Order not of
> the Fact, therefor it belongs Order dimension as Attribute.
> Than you can build a calculated measure, based on dimesion property
>
> iif (IsLeaf(Order.CurrentMember), Order.Properties("Hours"), null ... or
> smth. else)
>
> Vladimir Chtepa
>
> "J" <A@xxx> schrieb im Newsbeitrag
> news:u2ydz7gHGHA.2896@xxxxxxxxxxxxxxxxxxxxxxx
> >I have the following data in my olap cube
> >
> > OrderID Hours DateInvoiceSent BillAmt
> > 1 200 1/1/04 $10
> > 1 200 2/1/04 $20
> > 1 200 3/1/04 $30
> > 1 200 4/1/04 $40
> > 2 100 1/1/04 $10
> > 2 100 2/1/04 $20
> > 2 100 3/1/04 $30
> >
> > OrderID: the ID of the order
> > Hours: the number of hours it took to process a order
> > DateInvoiceSent: the date that an invoice was sent to a client. We send
> > multiple invoices on several different dates for a single order.
> >
> > The problem is when I use a Excel PivotTable to look at this data, asking
> > for the orderID and the number of hours spent processing the order. I get
> > the following
> > OrderID Hours
> > 1 800 (4*200)
> > 2 300 (3*100)
> >
> > This is incorrect since there were only 200 hours spent processing order
> > #1.
> >
> > What I wish I could get is
> > OrderID Hours
> > 1 200
> > 2 100
> >
> > Does anyone know of a way to write a calculated measure that would return
> > the correct value for hours? Perhaps by correcting by the number of bills
> > sent?
> >
> > P.S. I think this problem is basically caused by having measures resides
.

Relevant Pages

  • Re: Problem with measures
    ... I understand how to retrieve the member property for a leaf ... >> OrderID Hours DateInvoiceSent BillAmt ... >> DateInvoiceSent: the date that an invoice was sent to a client. ... >> for the orderID and the number of hours spent processing the order. ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with measures
    ... > OrderID Hours DateInvoiceSent BillAmt ... > DateInvoiceSent: the date that an invoice was sent to a client. ... > for the orderID and the number of hours spent processing the order. ...
    (microsoft.public.sqlserver.olap)
  • Problem with measures
    ... OrderID Hours DateInvoiceSent BillAmt ... DateInvoiceSent: the date that an invoice was sent to a client. ... This is incorrect since there were only 200 hours spent processing order #1. ...
    (microsoft.public.sqlserver.olap)
  • Re: My invoice report generates pages on number of items
    ... open the Invoice report in design view. ... Select the OrderId field in this dialog. ... you see the Group Header and Group Footer are Yes. ... you can open the Invoice query directly. ...
    (microsoft.public.access.reports)
  • RE: how to have a form that generate invoice no.
    ... OrderID autonumber PK ... CustID long integer FK -- points to an entry in tblCustomer ... To get the next invoice number, ... CustId: PK ...
    (microsoft.public.access.forms)