Skip to Content
author's profile photo
Former Member

Query on a Multiprovider

Hi Friends,

I have a BEx query on a Multiprovider(MP) that uses two InfoCubes. The MP is based on a basic InfoCube and a transactional basic Infocube. When i run the query, i cannot any data from either of the cubes. What could be the possible reasons.

Thanks

Raj

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 02, 2005 at 11:42 PM

    Hi Raj,

    You can check the infocubes to see if there are any requests available for reporting. If your transactional cube contains just one request and it is yellow, then you need to include the 0REQID variable (not sure about the technical name but it is something like this). You need this variable in your filter area to get data fromthe yellow request.

    Also check your query for any filters that may result in no applicable data.

    You may also want to see the multiprovider definition to see if you have done the required identification and selection settings for key figures and chars.

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 02:21 PM

    Hallo

    I would also suggest to check you do not have any filter based on one IO which belongs only to one underlying cube. In this case you will not get any data.

    Make a query on single cube and see if you get data.

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 03, 2005 at 12:35 AM

    Raj,

    As Bhanu has suggested see if there is data in your multiprovider and it is available for reporting.

    And once that is taken care of.

    Run the query from RSRT in your BW environment to see if there are any issues with BEX.

    If this is giving you results and your BEX still doesn't give you results..

    try to play a rnd the filter a rea.

    Best Luck.

    -Led

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 04, 2005 at 06:26 PM

    Thanks a ton to Bhanu and others who were prompt in their responses. The problem is resolved!!!

    Raj

    Add comment
    10|10000 characters needed characters exceeded