- changed status to open
Combined column filters in grid widget resulting in MDX error
Describe the bug
Applying several filters on a table results in a MDX error.
To Reproduce
Steps to reproduce the behavior:
- Grid Widget with column filters and search field
- Use search field
- Selection > Keep + Leaves
- Filter by Top X on any column
- See error
Expected behavior
Filtered list is shown
Screenshots
If applicable, add screenshots to help explain your problem.
Additional context
MDX-Statement:
SELECT NON EMPTY TOPCOUNT({{{[FIN BSEG 2 Detail].[Customer by Country].[CN], TM1FILTERBYlevel({TM1DRILLDOWNMEMBER({[FIN BSEG 2 Detail].[Customer by Country].[CN]}, ALL, RECURSIVE)}, 0)}}}, 10, ([T Date].[FY QTD Rollups].[2024-04-17 QTD^2024-04-17 MTD])) ON ROWS, {{
[T Date].[FY QTD Rollups].[2024-04-17],
[T Date].[FY QTD Rollups].[2024-04-17 MTD],
[T Date].[FY QTD Rollups].[2024-04-17 QTD],
[T Date].[FY QTD Rollups].[2024-04-17 YTD]
}} ON COLUMNS FROM [OP Daily Book Bill Detail] WHERE ( [Time Analysis].[Time Analysis].[BASE],[OP IC Indicator].[OP IC Indicator].[ThP],[OP Daily Book Bill Detail Measure].[OP Daily Book Bill Detail Measure].[Sales],[FIN BSEG 4].[FIN BSEG 4].[Total FIN BSEG 4],[FIN BSEG 3 Detail].[FIN BSEG 3 Detail].[Total FIN BSEG 3 Detail],[FIN BSEG 2 Detail].[FIN BSEG 2 Detail].[Total FIN BSEG 2 Detail],[FIN Company].[FIN Company].[Total FIN Company],[Scale].[Scale].[BASE],[FIN Currency].[FIN Currency].[N-EUR],[FIN Version].[FIN Version].[ACT])
Just applying a Top X filter is working. It is the combination of filters which results in an error.
Comments (2)
-
-
Dear Alexander, Can you please confirm if the issue presists on the lastest version 2024.02 FP1?
- Log in to comment
Dear Alexander, Thank you for bringing this to our attention, we will reproduce the issue and get back to you.