Hi, I have got a requirement to do the unique count on a dimension data in a cross tab, Which is similar to =count(dimension) function in BO Webi, not sure how do I get it in design studio? please let me know.
Hi Sreekanth,
Please check once the following scn link
https://archive.sap.com/discussions/thread/3792065
thanks
sekhar
What is your data source? If it is BEx, then have you considered doing this calculation in the Query Designer? See https://archive.sap.com/discussions/thread/3306654
Hi Tammy, Thank you. I am accessing the HANA view directly in Design Studio. In this case, should I look an option to model the unique count in HANA view?
I wonder if you could do something SQL-side in HANA to capture this? This blog made me think of it - https://blogs.sap.com/2014/03/10/how-tocalculate-ytd-mtd-anytd-using-date-dimensions/ - I don't have a HANA box right now to try this.