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

Read data from another cube's fact table

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2007 at 06:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

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.