Read data from another cube's fact table

[charla_robertson]

Hi All,

We are joining two cubes via a multiprovider. Cube 1 contains Suggested Retail $, Promotion Flag, Store, Article, UPC. Cube 2 contains Sales $, Store, Article, UPC, and we are adding Promotion Flag.

The problem is that the Promotion Flag in Cube 2, needs to be populated by looking up the Store/Article/UPC combination.

Cube 1 is loaded weekly, for the upcoming week. Cube 2 is loaded daily.

I was going to create some code in the update rules for the Promotion Flag field in Cube 2. This code would read the fact table for Cube 1 (where Promotion Flag is already populated) and then populate Promotion Flag (in cube 2). Problem is that the fact table is all based on dimension keys, not the characteristic values.

Any suggestions on how I might read data from another cube's fact table?

Thanks

Charla

[Former Member · Accepted solution]

Hi Charla,

You can use the FM RSDRI_INFOPROV_READ to read an infocube. You can see the demo program RSDRI_INFOPROV_READ_DEMO to see how this FM can be called. I think that should solve your problem.

Thanks and Regards

Subray Hegde

[charla_robertson · Accepted solution]

Thanks very much. We are now looking into using this FM and so far it looks very promising. I will post back once we investigate further.

[Former Member · Accepted solution]

I was wondering how we can use this in a routine in the transfer rules?

[Former Member · Accepted solution]

Hi John,

Wrap this FM in a custom FM and play around with the custom FM however you want. I have done it this way before.

Thanks and Regards

Subray Hegde

[charla_robertson · Accepted solution]

We were able to use the FM successfully to populate the promotion field. Thanks for all your help.