How to use the infoobject in multicube?

[Former Member]

I want to use the attribute of a infoobject in the query, but this infoobject is not in any of the base cube of my multicube, this infoobject is the combination of 0material and 0country which all in my base cube, how can I do this? I know I can add this into my base cube and reload data, but I do not want to reload. Experts, please advise.

[Former Member]

I answered.

[Former Member]

Yu,

You need to craete an infoset on your basic cubes and your infoobjects. Join your basic cube Material/Country to the infoobject. In case you want any other attribute of your infoobject, you need to select them while creating the infoset.

Thanks...

Shambhu

[Former Member]

after evaluation, I found the APD is the best solution, I created a APD to join these field wtih ODS and cubes. then load into another cube and bulid the query.

[Former Member]

you can add infoobject in ur MP but as u know it will not be common to other cubes. so no use.

try doing a infoset on MP and infoobject.

if it does not work, u have no choice but to reload.

[yogesh8984]

Hi,

Make that attribute as a navigational attribute.

Regards,

Yogesh

[Former Member]

Thanks for your information, can you please give me more help on how to create such as infoset? Multicube can not be conponent of infoset, so I want to create a infoset links the infoobject and base cubes first and then add it back to the origina multicube, but how shall I join this infoobject with these basic cube? only link the 0material/0country from basis cube and infoobject? Anything need to link in terms of the KY?