BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Count distinct in Lumira Designer


 
Search this topic... | Search Lumira / Visual Intelligence... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual Intelligence  Previous TopicPrint TopicNext Topic
Author Message
soufiane669
Forum Member
Forum Member



Joined: 10 May 2019

Posts: 1



PostPosted: Fri May 10, 2019 8:55 am 
Post subject: Count distinct in Lumira Designer

Hello all,

I'm facing an issue trying to calculate a count distinct on a dimension, Lumira Designer seems to do a simple count without the distinct.

For information my application is based on a universe where i'm calculating a count distinct.

When i create a datasource with only this counter it's OK but when i'm adding other dimensions the distinct is not applied anymore.

Is there any way to keep working this counter as a count distinct and not a simple counter ?

Example :

Dimension A Dimension B Counter Dim A

A B 1

A C 1

As a global counter i'm expecting 1 not 2.

thank you.
Back to top
katullus
Forum Associate
Forum Associate



Joined: 21 Aug 2009
ASUG Icon
Posts: 793
Location: NYC always in my heart


flag
PostPosted: Wed Jul 24, 2019 4:41 pm 
Post subject: Re: Count distinct in Lumira Designer

Hi soufiane669,

AND WELCOME TO B icon_mrgreen.gif B,

I dont think your issue is necessarily a lumira designer issue, if you have a universe as a data source, why wouldnt you an analytic running count function (of whichever DB) to give you a distinct count for that Dimension?
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Lumira / Visual Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0257 seconds using 17 queries. (SQL 0.0020 Parse 0.0008 Other 0.0229)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo