cancel
Showing results for 
Search instead for 
Did you mean: 

Multicube Scenario

Former Member
0 Kudos

Hi, I have a situation here. We have a multicube made on top of 4 cubes including Purchasing Orders. but when i run a query, I dont get any data from the purchasing cube, e.g. purchase order number and so on...all i see is #'s. I want to see data that is common to all the basic cubes involved. Can anyone help me in this??

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Farhan,

In the MultiProvider maintenance, please go to the Identifcation and Selection tabs and see if the objects from your purchasing cube have been checked.

Hope this helps...

Former Member
0 Kudos

Where exactly are the identification and selection tabs. I right clicked on the multi, clicked CHANGE but dont see any "identification and selection" tabs.

former_member188975
Active Contributor
0 Kudos

Let me rephrase that to say Identification and Selection buttons. Identification on Characteristics tab and Selection button is on the Key Figure tab. These allow you to choode which data do you want to include from which base cube.

Hope this helps...

Former Member
0 Kudos

Bhanu, i appreciate your help...but i still cant figure out which data is common. could you guide me step by step please ?

former_member188975
Active Contributor
0 Kudos

Ok...so if you clicked the Identification button, it must have opened up a screen with characteristics, their name, and the InfoProvider the data wouldbe flowing from. First of all please see that the Chars from your purchasing cube (like purchase order number) have a checkmark against them).

There might be a couple of things with this situation actually (but look at this after you ahve seen the identification)

1. Check the base purchasing cube to see if has any data correspodning to the query definition that you are running.

2. You can also check to see if the query is not excluding this InfoProvider.

Former Member
0 Kudos

Bhanu, if you dont mind, could u guide me step by step...using the exact terminology used on the screen? as in which tabs to press and stuff cuz i'm getting confused. the path i'm following is Right click Multi Provider -- Click Change and then click InfoObjects. but it only shows the ones that have NOT been selected in the definition of the Multicube... Please help

former_member188975
Active Contributor
0 Kudos

no no..do this:

MultiProvider > Right CLick >Change > On the screen that comes up ( MultiProvider: Relevant MultiProviders), just click the green check mark. You do not need to visit any tabs here. Just FYI...as you mentioned that your MP is made up of 4 InfoCubes, on the first tab which is InfoCubes you would see a check mark against these 4 cubes.

Once you Okay this screen, the next is where you can actually see the MP definition, and further the buttons that I was talking about.

Hope this helps...

Former Member
0 Kudos

thanks alot man...now i got it.

former_member188975
Active Contributor
0 Kudos

Good...hope you are able to resolve your problem now.

Answers (0)