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

When we drilldown at document level it displays one record for each cube

Dear Experts .

The users want to see the report by status for the order detail report at document level it displays one record for each cube .

They want to see the single line for the order quantity , Amount, Billing quantity delivery and amount along with the Sales order number , billing document number billing date , delvert date ..et in signgle line. ( Sale order DeliveryBilling)

When we are doing on Multiprovider recording displaying from each cube.

We have tried with Constant selections and it is not giving the required results m since these want to see by status. Due to huge data performance reasons we re unable to use it .

Please provide your valuable inputs.

Thanks,

Mahesh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2012 at 03:16 PM

    i am not sure i understand properly they want to see a report which has data from different cubes in 1 line when drill in?

    k how are you creating your drill down, are you using RRI to jump from 1 qury to another?

    can you eloborate a little more thanks..

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 31, 2012 at 09:07 AM

    Mahesh,

    If you want to get detail data with respect to Sales order - delivery - Billing, on top of Multiprovider you can come up with Constant selection.

    But I am not clear that why constant selection is not working properly, can I have some light on that.

    Probably, you are struggling with multiple records .

    I suggest you to go with end routine and map all fields to one IC and do reporting on that single IC, then your requirement will fulfill.

    But here we need to take care of performance issues and process chain scheduling wile loading deltas.

    If Multiprovider is not working properly , then try with Infoset(If you have more than 2 ICs it not possible).

    Regards,

    rvc

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2012 at 01:39 AM

    Model your scenario. Take dumps from all the 3 cubes/dso. Check for common elements, understand the functionality like which of these form a key. This key is going to be your base for the query. Now, model an Infoset instead of a Multiprovider on all of these 3 cubes/dsos, as the granularity will definitely increase in a MP. This must solve your issue.

    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.