replace - Replacing a Null field in mdx -


i have situation have null value coming in column , value needs replaced value.

current mdx

select non empty { [measures.[color count]} on columns ,non empty { [colorcolor].[color].[color].allmembers} dimention properties member caption ,member_unique_name on rows [colors] 

current results

color     color count null      1 red       1 blue      1 purple    1 black     1 

intended results

color     color count silver    1 red       1 blue      1 purple    1 black     1 

basically need replace null color "silver". null needs replaced in mdx , not in ssrs.

using with member can create new item, giving name want, , tell values null item. can hide items don't want using second argument of except function.

with member [colorcolor].[color].[color].[mynewname]  [colorcolor].[color].[color].[null] select non empty { [measures.[color count]} on columns ,non empty {  [colorcolor].[color].[color].[mynewname], except({[colorcolor].[color].[color].allmembers},{[colorcolor].[color].[color].[null]}) } dimention properties member caption ,member_unique_name on rows [colors] 

Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -