Skip to Content
avatar image
Sreekanth Surampally

Unique Dimension value count in a Cross tab - Design Studio

Jan 05, 2017 at 04:59 AM | 532 Views

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.

SAP BusinessObjects Design Studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Chandra Sekhar K
    Jan 09, 2017 at 01:56 PM

    Hi Sreekanth,

    Please check once the following scn link

    https://archive.sap.com/discussions/thread/3792065

    thanks

    sekhar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Tammy Powlas
    Jan 05, 2017 at 10:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Sreekanth Surampally
    Jan 05, 2017 at 05:35 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Sreekanth Surampally
    Feb 09, 2017 at 08:03 PM

    Hi Chandra, It worked.

    Add comment
    10|10000 characters needed characters exceeded