Question:
I am building a query on a MultiCube. I have a characteristic which is present only in one cube and not the other cube. Can I use this characteristic as a filter in my query??
If not how do I use it as I need to filter the query according to this value.
Thanks
Answer:
Simply just use it. The other characteristics will handle the union of your different providers into the multiprovider.
I will work without any problem as a filter.
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
lthibert, i don't think this will work :
let's say the MultiProvider (MP) is built up of Cube1 (C1) and Cube 2 (C2).
According to my, if you filter on a characterisitc that is only in C1, he will only show line (and thus also key figures( that are only in C1, and he won't be able to read anything from C2...
Answer:
depends which filter he/she uses... if he/she filters on "space" then the result will be those records from C1 with no value for the characteristic whilst fulfilling the selection criteria and all records from C2 that fulfill the selection criteria
cheers,
El Belgio
Answer:
Sorry TFR, but I do it on my actual project.
In the Multiprovider, if a characteristic comes from only one cube, then the content of the second is displayed based on the union and identification from the others.
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
lthibert,
sorry to elaborate on this topic, could you then confirm that this is what you mean:
SET-UP
* Cube 1
... char 1
... char 2
... kf 1
* Cube 2
... char 1
... char 3
... kf 2
MultiProvider MP over C1 and C2, with the following entries on the identification tab ;
Char1 --> C1 - Char 1
......... --> C2 - Char 1
Char 2 --> C1 - Char 2
Char 3 --> C2 - Char 3
(So Char 1 is common in C1 and C2, Char 2 is only known in C1 and Char 3 is only known in C2)
and you use both KF's in the MP (one from each cube)
REPORT
So in my report i want to show both kf1 and kf2 by selecting on Char2 (only known in C1), he wil
* get KF1 from C1 just by reading it with the selected values for Char2 (normal)
* AND that he will get KF2 from C2 by reading it with the derived Char1-values from the selected lines in C1 (the lines that thus were selected with Char2)
Answer:
Sorry TFR, but I do it on my actual project.
In the Multiprovider, if a characteristic comes from only one cube, then the content of the second is displayed based on the union and identification from the others.
BUT you don't FILTER on it, do you ?
Ch
Answer:
Hi to all,
Sorry, I made a mistake ... In fact, that's true that it will not work as a filter or free characteristic, CHC and I talked a while about that ... But as I succeed in having it work, I had just forgot the way I did it ...
In fact, I succeed in doing it, not when data were extracted ... but when they were displayed. I used 'restrictions' of the key figures. ... and it works, it shows you the data from both cubes, even if many of them are restricted with characteristic values from only one... Double click on your figures, and drag&drop your characteristics into them. Then, you can filter at that place.
Am I clear enough ?
_________________
Laurent THIBERT
Business Connection Amerique