Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
very slow query in OBIEE ( maybe a conception problem )

Hello everyone , i am working with OBIEE 12c.
i am struggling with this problem for a couple of days
To simplify , i have 2 fact tables :
First fact table
- Number of the licence ( the key i wanna use )
- id dimension 1
- id dimension 2
- id dimension 3
- Payment 1
- Payment 2
- total payment
For now everything is good , when in OBIEE the queries are fast i can have the total by licence
my second fact table :
- Number of the licence ( the same key of the first fact table )
- id dimension 1
- id dimension 2
- id dimension 4
- id dimension 5
- id dimension 6
- Another KPi 1
- another KPi 2
When i want to retrieve KPIS from both table using the Number of licence ( the common key )
the query is still loading ... and never stops
I didn't put all the KPIS in the same fact table because there are lot of rules that complicate the task.
Do you have any idea about how can i solve this problem ?
Answers
-
John305 wrote:Do you have any idea about how can i solve this problem ?
You start by looking at the log files and look at the real SQL queries. Then you look at the DB and the explain plans. The query normally isn't "slow in OBI" but "slow in the DB". If it's really OBI that's throttling the query then you have completely different issue like needlessly forcing millions of rows into the BI servers instead of having the DB do its job.
Without any specific information which you need to find and provide (in the logs), nobody can help you there.
0