multiprovider issue

[Former Member]

Hi Gurus

A client has a planning system, sitting over a multiprovider. One of the sub-cubes has actuals. In BW we can query the mutiprovider and see the actuals so I presume the bes are attached and the multiprovider is correct.

In BPC we see other sources but are not able to see the actuals. We have tested this with a new report to ensure it is not some code in the existing report. I assume it’s not a security issue because otherwise the user could not see the actual member of the version dimension before even running a report.

Can you advise whether there are other settings in BPC that would prevent us from seeing data from a single source cube.

Thanks

Cliff

[Former Member · Accepted solution]

It turned out the client had modified the code in the query engine and neglected to inform us.

Case closed

[Former Member]

Hi Clifford!

Here´s a link that might be useful for you.

[Former Member]

Hi Patrick

Yes that describes several design options. One of these  under the heading Creating designated separate cubes within BPC multiprovider  is what we have. The issue is that it has stopped working.

Cheers

Cliff

[Former Member]

I have now discovered the MDX generated from BPC reads the planning cube rather than the multi-provider. This explains why we fail to get actuals in BPC.

We still lack an explanation as to why it is targeting the wrong source.

Cliff

[Former Member]

Is it possible the BPC query is using a user that does not have BW permisions to read the cube? What BW user is used by BPC to run the query? Here do I find this setting?

Thanks

Cliff

[former_member190501]

Hi,

Even though BPC query runs on BW cube there will not be any relation between your BW authorization access profiles and BPC access profiles. BPC data will be accessed based on access profiles assigned to the user. This user is not same as your BPC user.

First check from back end system whether your BPC cube is having data or not from RSA1--> Infoproviders-->Business Planning and Consolidation-->Appset -->Application from context menu (right click) select Display data.

Thanks,

Raju

[Former Member]

Hi Raju

We have tested the data in BW by running queries and getting data. This is for the same selections that fail in BPC.

A year ago BPC was able to read the data. We have old BPC reports that agree with data we can read in BW.

I am currently testing using an admin user in BPC. This user has access to all dimension members. However what I am wondering is this; BPC generates queries in BW. For these queries to run, BPC must be passing a user (probably a service user) to BW. If someone has changed the back end BW cube perhaps the service user no longer has authorisation on the BW cube.

Is there a way to see what service user is involved?

Thanks

Cliff

[former_member190501]

Hi,

Can you check data in BPC cube as I mentioned in my previous reply instead of running BW query?

Thanks,

Raju

[Former Member]

Hi Clifford!

Could a solution to your problem be that you actualy load the actuals data to the BPC cube , since if I have gotten you right you can access the bpc cube and see the planning data in there?

BR
Patrick

[Former Member]

Thanks Patrick

In this instance the system was working with the current design but then stopped. I have been asked to fix the problem. Changing the design would be a fairly major undertaking and the client would ask why I don't just fix what was broken rather than redesign it.

Cheers

Cliff

[Former Member]

Hi Raju,

I have done that (the RSA1 display data) and all cubes show data. However only the planning cube (the one auto-generated when we created the application) shows data in BPC.

Thanks

Cliff

[Former Member]

Hi Clifford

Can you please explain your issue again ? which SP in BPC 7.5 NW ?

JAck

[Former Member]

Hi Jack

It is SP8

By Default a new BPC application createsa multiprovider with one cube (Planning). Our client has added other cubes for reference actuals. The BPC application can read the planning cube but cannot read data from the actuals cube.

I am now wondering whether the user that BPC connects to BW might not have BW permissions on the actuals cube. Is there a way to find what this user is and to test these permisions?

Thanks

Cliff

[former_member190501]

Hi,

Are you using Local connection to run report on multiprovider? I couldn't under where are you running report and on what infoprovider did you create a Query ?

Thanks,

Raju

[Former Member]

Thanks Raju,

I don't understand what you mean by local connection. IS is a Version 10 concept? We are running 7.5

All reports fails to retrieve data from that one cube. Today I tested with a fresh report using the template wizard.

Cheers

Cliff

[former_member190501]

Hi,

Does it mean none of your reports are working ?

Thanks,

Raju

[Former Member]

That is correct. Existing reports do not work. Today I created a fresh report and carefully matched it to known data from a BW query. It also was not able to return any data.

Under the MS version you can see the generated select statement. Is there a way to do this in NW?