on 12-12-2013 7:09 PM
We're on Business Objects 4.0 SP7 Patch 2 using BW, Bex Queries and BICS connections. Until we installed SP7, reports showed only cost center and not controlling area/cost center. Our controlling area is one number that will never change. Our users would like to see just cost center in their Analysis and Webi reports.
I've looked at this article, but since we don't have universes, it would need to be implemented in all of our webi reports as well as any the users have modified in their favorites.
Is there a way to default the value in BW so that we'd only see Cost Center in Business Objects?
This is posted in the wrong area (Analysis for Office specific instead of general BW), can someone suggest where I should post it? Thank you. Susan
On the Analysis side you can simply set a constant filter on the BEx query for your controlling area, then the key of the cost center will not be compounded anymore.
Best regards,
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Susan,
if you set a filter, then you will also only see obvioulsy the filtered data set.
In Analysis a compounded characteristic should also behave "dynamically" - means that when both of the compounded objects are shown you should only see the keys (non-compounded) and if you show the inner object from the compounded objects standalone, then you will see the compounded key as otherwise the keys are not unique
ingo
Victor, Thank you for the screen print.
Ingo, I understand what you are saying about the compounded objects. In our case, the decision was made to only have one controlling area for our company. So our cost center numbers are unique. If that were not the case, we would need both objects in order for the information to be meaningful.
My last question is since Webi uses the Bex query, after the filter on controlling area is added, will I still see the cost center non-compounded as an object? My Bex person is out today so I am unable to test it.
Thank you. Susan
Hi Susan,
As Ingo said, you have the non compounding option when you bring the cost center, it should be the last attribute on the cost center Attributes.
if you are in a older support package, and that option (non compounding) is not available you can use a formula in Webi using the "replace" function.
example your our controlling area is 0001 and your cost center is 50000, you see 0001/50000 on the report, you use the formula =replace([costcenter];"0001/";"")
regards
Rodrigo Silva
Hello Susan,
in Web Intelligence you have a compounded and a non-compounded object, so it is simply a question of which object you put into the report
regards
Ingo Hilgefort, SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
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.