very slow query in OBIEE ( maybe a conception problem ) — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

very slow query in OBIEE ( maybe a conception problem )

Received Response
11
Views
1
Comments
John305
John305 Rank 5 - Community Champion

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    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.