loading from data targets

[Former Member]

Dears,

I have calculated KFs whose calculation components are found in cube A.

I have another report that is based on cube B.

But it also requires these calculated KFs (dynamic results depending on selection) values as selection is made in this report of cube B.

How can this kind of data be supplied to a report (query) of cube B? Or how can a filter selection in this report be smart enough to know that it needs to call the calculated KF of cube A?

regards,

Suzie

[Former Member · Accepted solution]

Hi,

CKF have a scope of InfoProvider. CKF created on Cube A cannot be available on Cube B.

If you have just some calculations - could create Formula Variables which will be available for both Cubes A and B.

Please correct me if am wrong.

[Former Member · Accepted solution]

hello

You can not use components of CKF which are present in Cube A for report on Cube B .

I think the issue is with your data model/architecture.

what you can do is-

Change your architecture and create Cube C which is updated from both cubes - cube A and Cube B .

Regards

Pradip

[Former Member]

Hi

I think it is an architecture issue.

If you want to run such a complex report that depending on selection is bringing data from other providers, it means your data is not layed out to support this complex report.

I would suggest to rearchitect the data to support this.

You could link the 2 Cubes Via a Multi provider but I am not sure if it is good enough.

Reg's

Edan