How to Rename row values of result set coming from MDX query
Hello,
I have the following challange.
I'd like to rename dim attribute members in mdx.
as-is
row measure
cf 10
fm 20
how i would love to rename cf and fm to cf1 and cf1 for instance...
row measure
cf1 10
fm1 20
how do i do that?
I have the following challange.
I'd like to rename dim attribute members in mdx.
as-is
row measure
cf 10
fm 20
how i would love to rename cf and fm to cf1 and cf1 for instance...
row measure
cf1 10
fm1 20
how do i do that?
TempDBA
dataitem!value + "1"
I think what TempDBA means is:
=Fields!Row.Value & "1"
This assumes that Row is the name of your dataset field and that all values in that column would need to get the suffix. If it only applies to certain fields, you may want to look into creating a calculated field in your dataset. Then use the IIF() or Switch() to take out the special cases to have the suffix added. Let us know if you'd require more info on that.
=Fields!Row.Value & "1"
This assumes that Row is the name of your dataset field and that all values in that column would need to get the suffix. If it only applies to certain fields, you may want to look into creating a calculated field in your dataset. Then use the IIF() or Switch() to take out the special cases to have the suffix added. Let us know if you'd require more info on that.
ASKER
Hey thanks for your answers...
But sry i am not getting it...
I have ssrs report which is using this MDX statement.
SELECT NON EMPTY { [Measures].[Amount] } ON COLUMNS,
NON EMPTY { ([DIM].[Somemember].ALLMEM
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Cube]
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
now i would like to rename a member of the somemember attribute
from XXX to YYY. How is =Fields!Row.Value & "1" helping me there?
But sry i am not getting it...
I have ssrs report which is using this MDX statement.
SELECT NON EMPTY { [Measures].[Amount] } ON COLUMNS,
NON EMPTY { ([DIM].[Somemember].ALLMEM
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Cube]
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
now i would like to rename a member of the somemember attribute
from XXX to YYY. How is =Fields!Row.Value & "1" helping me there?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.