We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

When i change the columns name the value is not displaying.

Answered
Nis asked on November 5, 2020

I have a mdx query and when i change the columns name the rows are shown but the columns are still the old ones .
I change the query to have the null values converted to 0
The first query is this and the data is showing normally but without the null values :

Select 
    NON EMPTY {[Measures].[col_], [Measures].[col2_], [Measures].[col3_]} 
    DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , 
    NON EMPTY Hierarchize({DrilldownLevel({[Region].[Region].[All]})}) 
    DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM (
    SELECT ({[Category].[Category].&[Oil]}, {[Year].[Year].&[2019]}) 
ON COLUMNS FROM [SIIBPAGESATDIREKTEF]) CELL PROPERTIES VALUE

and the second query that shows the null values is working in sql server but not in flex monster is like this :

WITH 
    MEMBER [Measures].[col_] AS COALESCEEMPTY([Measures].[col],0)
    MEMBER [Measures].[col2_] AS COALESCEEMPTY([Measures].[col2],0) 
    MEMBER [Measures].[col3_] AS COALESCEEMPTY([Measures].[col3],0) 
Select 
    NON EMPTY {[Measures].[col_], [Measures].[col2_], [Measures].[col3_]} 
    DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , 
    NON EMPTY Hierarchize({DrilldownLevel({[Region].[Region].[All]})}) 
    DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM (
    SELECT ({[Category].[Category].&[Oil]}, {[Year].[Year].&[2019]}) 
ON COLUMNS FROM [SIIBPAGESATDIREKTEF]) CELL PROPERTIES VALUE

maybe the flexmonster is not recognizing the changed columns name and is showing the old ones without data.

3 answers

Public
Milena Pechura Milena Pechura Flexmonster November 9, 2020

Hi, Nis,
 
Thank you for writing to us and for providing the code of the queries.
 
Our team would like to inform you that the issue may occur because of caching.
Could you please let us know which approach of connecting to SSAS you use? Via XMLA or via Flexmonster Accelerator?
This would greatly help us in our further investigation.
 
Waiting for your reply.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster November 16, 2020

Hello, Nis,
 
How are you?
 
We were wondering if you still have the issue with the MDX queries. 
Could you please let us know whether it is resolved? 
 
Looking forward to your response.
 
Kind regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster November 25, 2020

Hi, Nis,
 
Hope you are doing well.
 
Our team would like to kindly take an interest in whether you resolved the issue with the MDX queries. 
 
Looking forward to hearing from you.

Best regards,
Milena

Please login or Register to Submit Answer