Skip to Content
author's profile photo Former Member
Former Member

Calculate difference Time dimension in MultiProvider, or use Lookup?

Hi All

In regards to analyzing procurement cycle in terms of calculating duration for each procurement stage, I designed different InfoCubes for each stage as was discussed in [this|Experts views to take approach for Purchasing analysis; forum. In each of IC, Date is used as Time dimension. Purchase Requisition and Item No. are available in each IC. The objective is to take difference of dates of each activity performed for particular Purchase Requisition.

Now the issue is, Multiprovider doesn't show PR information (From PR to Payment) as a single record. Because of this, no formula can be applied (difference of dates to calculate no. of days).

Am I doing something wrong? Is't this the application of MultiProvider? Should I go with the LookUp concepts to make another InfoCube and populate dates of each stage for each corresponding Purchase Requisition?

Thanks

Warm Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 27, 2011 at 05:01 AM

    You should be able to do the calucation at PR and Item no combination. It seems that identification is not correct for dates characteristics in your multiprovider. You would not able to see all the dates in single row for a PR and Item but you can use those for calculation.

    As far as you dont display dates in your query, calculation will be fine (no of days between two dates).

    Multiprovider works as a join but it will display different KFs from different Cubes for same key but not all the characteristics will be displayed as 1 row.

    For example, in a cube you have PR, Item no, Doc Date and Qty 1; in another cube you have PR, Item, Payment Date and Value 1

    Now in query, you can display

    PR, Item, Qty 1 and Value 1 as one row but you bring in Doc Date or Payment Date, it will be two different rows.

    I hope it helps.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2011 at 04:00 PM

    Hi All

    In my four infoCubes, each having Purchase Requisition Number and Item Number as identity keys, I've created MultiProvider.

    The date key-figure for 'Document Create Dates' defined in each of the infoCubes.

    However, when I execute Query of MultiProvider, not all dates are shown, rather only PO date is visible, while the rest are blank.

    My concept is MultiProvider works on joining all infoProviders on the basis of mutual identity keys. If it is OK, the above should show the dates. Am I doing something wrong?

    Thanks

    Regards

    Nayab

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.