Skip to Content
0

SAP IDT SELECT DISTINCT MEASURE

Jul 05, 2017 at 09:59 AM

64

avatar image
Former Member

Hi all,

i'm working on SAP IDT 4.x with a relational connection to an Oracle DataBase, and we are facing a problem with something we don`t know if its BO, but we have a model with aggregate awares in measures and when we execute an specific query in webi, a distinct query starts to excecute with the sintax "SELECT DISTINCT <MEASURE>" from every fact or aggregate table that we have in the model, even measures not used in the query but exists in the universe.

Can someone help us?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mats Andreasson May 03 at 06:32 AM
0

Hi Manuela. I know that this question is old, but I'll write a response, maybe it'll help someone.

We had the same issue after a migration from BO 4.1 to BO 4.2. I compared the settings from the old server and the new and found some discrepancies.

Go in to the CMC - Servers - Web Intelligence Servers. Open the WebIntelligenceProcessingServer.

By default, under the section Information Engine Service, the tickbox "Enable List of Values Cache" is checked. Uncheck this and restart the server.

Found this blog mentioning it as well: https://mysapbi.wordpress.com/2012/12/11/webi-processing-server-launches-a-lot-of-sql-on-database/

Hope it helps!

Share
10 |10000 characters needed characters left characters exceeded