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

RRI Missing Records

I have a Multiprovider on Sales & COPA cube.

I use master data from Sales and transaction data from COPA. My main report shows correct key figures. But when I do a RRI to COPA cube, the rows having no sales order are missed. In my queries I don't have any such condition to exclude such records.

All suggestions are welcome.

Thanks.

JD

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 20, 2007 at 03:30 AM

    See to it that all the characteristics available in the main query are also in the RRI query. In the RRI query. If you don't want to display them then you can put them in free char.

    Also try including the unique key in the query.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Rakesh Pattani

      Rakesh. My receiving query is at sales order level and is based on a COPA cube.

      My sending query is based on a Multiprovider ( COPA & Sales) . It is not at sales order granularity. But this query returns the correct data, including the sales order records without sale order number. The receiving query filters out the records without sales order number. I am passing all the correct parameters.

      Thanks.

      JD

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.