OBIEE is forming two queries

Deepak_R-Oracle

Exactly my question why two sources when my logical table is only one and my physical table is also only one

Deepak_R-Oracle

Both the columns are from same logical table and physical table why obiee is forming two queries

Gianni Ceresa

What is the database type of the database object in the physical layer of the RPD?

You have attributes and measures in the same table, and you say they are from the same LTS, which is, by design, wrong as a fact logical table must have only measures (aggregates) and anything else must be in a dimension.

Deepak_R-Oracle

Database Type is Oracle 12c and both the columns are from same table, Seems you didn't understand my fact table structure, I have measures and some factors in my fact table and those factors are needed for calculation.

Joel

If the "factors" aren't facts, then they should be derived from a dimension as dimension attributes.

Deepak_R-Oracle

My Fact has columns as follows Prod_skey,Date_skey, location_skey, tweleve_month_pd, n_exposure_at_default_at_rcy, Why would i have a dimension for just a multiplication factor i i cant understand, That factor is at the Prod, date, location granularity.

Deepak_R-Oracle

Finally found the solution, It was not the table issue, It was more of a repository modelling issue which i have corrected.

Christian Berg-0racle

What kind of modeling issue? It would be good etiquette to share the solution with others.

Deepak_R-Oracle

I wanted to review my complete rpd just to make sure i have done everything properly before raising SR with oracle. When i was investigating my BMM layer i have found out that the measure column i have set the aggregation to be sum and then i have created my calculation column like measure*multiplication_factor which was looking like 'sum(sales)*pd_percent' it was evident that first part was summation and the second part was just a factor multiplication, So obiee was framing two queries then i have duplicated the measure column and kept aggregation as none then used this new column in creating a multiplication which was looking like sales*pd_percent then i have added sum explicitly in the column formula which solved my issue.