Distinct Count in Explorer

[Former Member]

This is from BOB post, which was posted in 2008. Now it's 2013 and there is no solution by SAP? We are doing a POC on Explorer, this is probably time to scrap it. Very frustrating! Is there any

Hi,

We have 2 tables used in universe "orders" and
"order_line_product_item" from where we are pulling data in explorer indexes.

We have issues getting distinct count of
customers in explorer when we bring data from order line product item level
facets/dimension.
Just wondering if anyone else had solution of how to
handle this on explorer side?
At universe level we using count (distinct cust key), which is working at
webintelligence.
Looks like BO XI R3 further enhanced on handling this kind
of situation by implementing delegated measures, but don't find anything similar
to it in BO explorer.
Occurrences is always getting us count at the lowest grain level(basically row level
counts, but we are looking for distinct counts though !) .

Is getting
distinct counts limitation in explorer?

Any help will be greatly
appreciated.

Thanks,
~SK

Courtesy of Sachin

[Former Member]

you know if this is possible?

[Former Member]

Hello,

So if you have a calculation(Webi) function(Excel) built into the two tables you are using from the data source you might try 'configuring' the data as 'Occurance' from the workspace you created or after the file in index if you're using excel.  If you are using a universe as a data source for the exploration view set you can attempt to drag the 'measure' needed (count) into the workspace option "measure" when creating the workspace.

I do hope this helps

[Former Member]

Hi

Did you get to solve this issue any way?

Thanks

Teresa