This content has been marked as final. Show 6 replies
You can do that but make sure you add this saved filter for metric columns.
Pls mark correct/helpful if helps
can i know how to do it ?
can you pls say steps to do
You have a better choice on the performance side.
Replace your case when by:
In the Presentation Layer of the repository make the following alias in the led table:
- JAN for the column YTD1
- FEB for the column YTD2
- MAR for the column YTD3
With this solution, you will not fire the "case when" and you will then read the data of only one column.
Furthermore, if you implement aggregate navigation, your related query will use it.
but i get below error
nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "Led"."0". (HY000)
After ignoring i get result fine
I forgot the default values.1 person found this helpful
For instance, you have to write for a default rapport on JAN
in place of:
Thanks Nico .