asked on May 17, 2024
I have a date fact table that is keyed byh a date.
When I add the Date Display to a row FlexMonster hangs and loads 10000's of records from the date fact table.
However if I move this date display to the columns it works like its supposed to.
https://www.loom.com/share/a801cd2450e84536a8535657114655fd?sid=c6cc38b6-7c42-4e81-8932-fc18abd4a7e3
I do notice that it seems to load all the date facts to the filter. Could that have something to do with it? Can I disable this? It seems very inefficent to be loading 100,000's of records from the database, especially when there is only 1 date associated to the data.
⋅ May 17, 2024
Hello,
Thank you for the question.
Kindly note that when you move the field from the rows section to the columns section, the members and the data are already loaded into Flexmonster. That is why it does not load like it did when you placed the field in the rows. The component's logic requires loading all the records from the database, and there is no way to change such behavior.
We also noticed in the video you provided that the date appears in the columns but not the rows. We could not reproduce this issue on our end. Could you please provide us with access to the page where it can be reproduced? It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ May 18, 2024
Nadia,
Found the issue to be it happens with the last item in the column.
I copied the query Flexmonster is creating and this is the error returned from Analyis Server.
Executing the query ...
Query (1, 405) The syntax for '<ccon>_ROWS_TOKEN_END_</ccon>' is incorrect. (<ccon>Select NON EMPTY Crossjoin(Crossjoin({[Date].[YearEnglishName].&[CY2024]}, {[Date].[MonthEnglishName].&[May CY2024]}, {Hierarchize({DrilldownLevel({[Date].[DateEnglishName].[All]})})}), {[Measures].[ProcFee_Completed_Count]}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY _ROWS_TOKEN_START_Hierarchize({DrilldownLevel({[Clinic].[Description].[All]})})_ROWS_TOKEN_END_ DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Model] CELL PROPERTIES VALUE</ccon>).
Technical Details:
RootActivityId: b7de293a-cf75-45fe-a8f0-dd42d4a0998c
Date (UTC): 5/18/2024 4:17:46 PM
Run complete
Here is the Query
Select NON EMPTY Crossjoin(Crossjoin({[Date].[YearEnglishName].&[CY2024]}, {[Date].[MonthEnglishName].&[May CY2024]}, {Hierarchize({DrilldownLevel({[Date].[DateEnglishName].[All]})})}), {[Measures].[ProcFee_Completed_Count]}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON COLUMNS , NON EMPTY _ROWS_TOKEN_START_Hierarchize({DrilldownLevel({[Clinic].[Description].[All]})})_ROWS_TOKEN_END_ DIMENSION PROPERTIES PARENT_UNIQUE_NAME, HIERARCHY_UNIQUE_NAME, MEMBER_TYPE ON ROWS FROM [Model] CELL PROPERTIES VALUE
⋅ May 20, 2024
Hello,
Thank you for the details.
Our team has provided the answer via email. Please check your inbox.
Kind regards,
Nadia
