on 07-05-2017 10:59 AM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.