on 08-02-2012 10:36 PM
Hi everyone,
I work with BO 4.0, using universes based on BW queries (7.3).
I made a few reports in WebI and one has the option of drill (which was customized in the Universe).
The question is: When I present the lowest level of the hierarchy (Employee), I need to show "ID + Description", together.
In BW, this object (0Employee) can be presented as a key, key + Text or Text. But the BO only understands key or text .... BO can't "get" this object concatenated.
It tried to create a custom object in the universe, to concatenate the two information. But the MDX doesn't allow me to manipulate strings.
Everything I read tells me to generate this information directly into BW, saying it is not possible in the "BO Universe" and "the querie Bex" .....
Any ideas / suggestions?
You might check out the document below. However, I don't think you'll have a success on your issue. You should do this in BW instead of on the universe level.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Everything you read tells you the truth. Sad but true.
Unfortunately MDX doesnt return string datatype as result. Concatenating this two area in BW layer would be healtier for your requirement
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.