on 11-26-2014 3:14 AM
Hi. I am new to using Business Objects with Microsoft Analysis Services. Is there any way to change/rename the Measure's column name in the report?
This is not possible (yet?)
The only option you have is to change the description in the Bex query.
Good luck!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Becky
With SSAS when you add any hierarchy to the crosstab the Calcuations menu will become active (with every data provider it will become active when you add Measures/Accounts/Key Figures to the crosstab.
Click on the Analyze tab then click on the Calculations pull down menu. You will see Custom Calculation... is active. See image below.
If you need to rename a Measure, the best way is to ask the admin to update the cube with the correct name. However Ramu explained that a workaround is to create a Custom Calculation called whatever you want, but that custom calc is defined to simply be the measure you want to rename.
Regards
Hello Becky
It depends on your datasource. This is not a limitation of AOLAP. For example with SSAS and Essbase you can add custom calculations to non-measure hierarchies. But other providers such as SAP BW only allow custom calculations to be added to Key Figures (measures).
In this scenario if you need to rename a member you need to change the underlying BW query.
Regards
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.