Hello everyone,
we are using TM1ELLIST in our excel Reports. Unfortunately the do not update if the underlying data changes:
We are using the following MDX (The last or condition sets the 0 to 1 if a toggle is set. This then ignores all other condition thereby returning all dimension elements).
This MDX works perfectly fine, however if some data changes such that an element should be included in the result set, the last element is instead repeated.
e.g. with active filters:
Make some changes such that now also GEN-0058 and GEN-0059 should be returned what happens instead is:
- GEN-0057
- GEN-0057
- GEN-0057
If an element should be removed from the list, because the underlying data changes, the element is instead kept in the list, which should not be the case.
I hope there is some way to fix this.
{Union({[PlanningMeasure_Costcenter].[GEN-0057]},
{
Filter({
TM1DRILLDOWNMEMBER(
{[PlanningMeasure_Costcenter].[GEN-0057]}, ALL, Recursive
)},
[Costcenter].(
[Costcenter].[2030200100 - UMLAGE BEREICHSREGIE],
[Planningcycle].[Prg. 03+/21],
[Variant].[Hauptvariante],
[Currency].[Local currency],
[Datatype].[Actual],
[Year].[Total Year],
[Month].[Total Month]
) <> 0
OR
[Costcenter].(
[Costcenter].[2030200100 - UMLAGE BEREICHSREGIE],
[Planningcycle].[Prg. 03+/21],
[Variant].[Hauptvariante],
[Currency].[Local currency],
[Datatype].[Plan],
[Year].[Total Year],
[Month].[Total Month]
) <> 0
OR
[Costcenter].(
[Costcenter].[2030200100 - UMLAGE BEREICHSREGIE],
[Planningcycle].[Current Planningcycle],
[Variant].[Hauptvariante],
[Currency].[Local currency],
[Datatype].[Total Datatype],
[Year].[2020],
[Month].[Total Month]
) <> 0
OR
[ReportingFullView].(
[Costcenter_All].[2030200100 - UMLAGE BEREICHSREGIE],
[Planningcycle].[Current Budget 2],
[Variant].[Hauptvariante],
[CurrencyExchange].[EUR],
[Datatype].[Total Datatype],
[Year].[2021],
[Month].[Total Month],
[Country].[Total Country],
[Company_Reporting].[Total Company],
[MatrixOrganization].[Total MatrixOrganization],
[isBAB].[Total (BAB & NOBAB)],
[CM_Structure].[Total]
) <> 0
OR 1 = 0
)})}
------------------------------
Constantin Budin
------------------------------
#PlanningAnalyticswithWatson