cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Table - (No Value) or (Null) Values - Dimension

12-29-2023 8:07 PM
SarathSunny1 Participant
2661 views 0 comments
SAP Managed Tags
Subscribe

My table has a column called 'ETA Date'. It is a 'Date' dimension. Additional to different dates, it also has (No Value) and (Null), as in the screenshot below.

I want to replace (No Value) and (Null) with 'blank'. So, I tried to create a 'Calculated Dimension'.

But in the IF statement, I am not able to select the 'ETA Date' dimension. But all other NVARCHAR dimensions are available. So, is it correct to say that we cannot use an IF statement for a 'Date' dimension? or is there any other way to achieve the result?

The report is an optimized story.

Thank you,

Sarath Sunny

Accepted Solutions (0)

Answers (0)