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.
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
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
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