Skip to Content
avatar image
Former Member

SAP IDT SELECT DISTINCT MEASURE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 03 at 06:32 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded