January 28, 2015 at 4:26 am
Hi all ,
DimProject with the Project Name, Project Activation Date attribute Hierarchy.
measures.production fact
For some of the projects i have NULL activation date.
and other's projects i have '2011-01-01 00:00.000'
'2011-01-01 00:00.000'
'2012-01-01 00:00.000'
'2013-01-01 00:00.000'
'2014-01-01 00:00.000'
NULL
NULL
How can i apply below filter
1) exclude the NULL or empty cells
2) where project activation date <= '2013-01-01 00:00.000'
should filter the rows give me
'2011-01-01 00:00.000'
'2012-01-01 00:00.000'
'2013-01-01 00:00.000'
how can i achieve this ..in MDX
vineet
January 29, 2015 at 7:15 am
In SSAS, if Analysis Services encounters a null value during processing, by default, it converts this null to a zero for numeric columns or to an empty string for string columns. You can modify the default settings or convert null values in your extract, transform, and load process (if any) of the underlying relational data warehouse.
If you need to exclude the NULL value, you can set the null value to unknowmember and set it's visibility to false, then the null vlaue will not exist on the result.
January 30, 2015 at 4:00 am
I am looking for the solution in the MDX Construct.
I don't want to restrict null at the time of cube processing.
thanks and regards
VD
January 30, 2015 at 8:42 am
vineet_dubey1975 (1/30/2015)
I am looking for the solution in the MDX Construct.I don't want to restrict null at the time of cube processing.
thanks and regards
VD
Well if you could provide what you have so far then maybe it would be a bit easier for others to help you. Why not try learning about the following four functions in MDX: NON EMPTY, NONEMPTY, EXISTING, EXISTS. Also take a look at the following: http://social.technet.microsoft.com/wiki/contents/articles/20698.exists-v-s-existing-and-auto-exist-in-mdx.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply