I have a cube, with dimensions:
Years (Year_Total - consolidation; Year_17, Year_18... - numeric)
Period (Select level-0 subset)
Rates (R1, R2, R3, R4 - string elements)
Look at the screenshots below.
The user can set the Rates values for specific elements of the Year dimension (for example, Year_17).
Also, user can set the Rates values for Total_Year element
Next, if I select the Total_Years consolidation (with enabled suppression of zero rows), I see one row with empty cells. Obviously, IBM is trying to display rows that have values on the Year = child element of the Years_Total consolidation (Year_17), but for some reason the cells are empty.
Is there a way to fully supress such "pseudo-empty" rows?
I know that consolidating string elements is a bad way...
UPD:
I know it's bad to ask 2 different questions in the same topic, but I have a problem writing an MDX filter. I want to find all elements of Period dim for R1 element of Rate dim in the cube is set to Value12. Here is the code, but it doesn't find the element (I'm expecting an element Фев)
Code: Select all
FILTER([Period].MEMBERS , [CubeFrom].([Rate].[R1]) = "Value12")UPD 2
I tried filter by this way, its work. But it's really the only one way to filter string measures?
Code: Select all
GENERATE(TM1FILTERBYLEVEL(TM1SUBSETALL([Year]) , 0) , FILTER([Period].MEMBERS , INSTR([CubeFrom].([Year].CURRENTMEMBER,[Rate].[R1]) , "Value12") > 0))