cancel
Showing results for 
Search instead for 
Did you mean: 

Measures are null when filtered with condition in projection

Former Member
0 Kudos

Hello,

Same Analytic View taken in 3 different projection.

Projection that are filtered by date range in the expression works fine.

But Third projection which is filtered by year fetches null values for measures.

Anybody experienced such issue with projection expression ?

Your valuable suggestions are highly appreciated.

Thanks and Regards

Utpal

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Its observed that if data filtered in later stage of projection post union or join instead of filtering at the stage of projection from analytic view it populates value !!!

patrickbachmann
Active Contributor
0 Kudos

Interesting, I'm glad you got it working!

-Patrick

Former Member
0 Kudos

But it does not work for the scenario i described.

Since I need different Time horizon data before I Join or Union them to calculate the KPIs, hence it does not help me for the third projection.

As a work around i'm using procedure.

Thanks and Regards

Utpal

patrickbachmann
Active Contributor
0 Kudos

1) What is the datatype of the YEAR field in the original analytic view

2) Can you paste a screenshot of the FILTER/VARIABLE dialog box

Former Member
0 Kudos

Hello Patrick,

Datatype of the year field in the original analytic view:

FILTER/VARIABLE dialog box:



Input Parameter data type:


Working expressions for different projection from same analytic view:


Thanks and Regards

Utpal

0 Kudos

Hi Utpal,

After seeing your screenshot it seems that you have not selected the "MANDT" field in the projection node and you are trying to filter that in expression. Can you just check if this is the issue ?

-

Subhash