Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can you advise with it?
Hi all I have 3 datamart tables:
Client(every month i gather all data about client)
Account (every month i gather all data about account)
Payments (every day i gather data about payment)
Calendar(Montly) -cause business have to analyze monthly
I have this schema
Client , Account - are ok . All formula work and attribute good. But formula from Payment(F) - is empty.
In logs [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references:
I cannot understand how OBIEE generate SQL. Can you help me
Answers
-
Do you have logical dimensions with hierarchies defined? Your Client & Account dimensions are non conformed dimensions with the Payment fact and you need to set the logical level of these 2 dimensions accordingly in the Payment fact.
0 -
Just what Joel said
I see you are playing with the multi facts model as you asked some weeks ago. It generally take a bit longer the first time to get the content levels idea for the dimensions which aren't conformed (as pointed out by Joel your Client and Account not being linked to Payment F) but once done it will work nicely.
0 -
So one Client have one or more Account from one Account client may do one or many Payments. I look about bridge table - but there is no need to do bridge table. Seems..
0 -
That's blow up my mind
I will try understand it. 0 -
What Gianni is telling you is that for the dimensions NOT joined to the facts in the table you need to use their content level to set to TOTAL level against the fact table that they are not joined to.
Hope that helps with the cerebral explosion rather than making it worse.
0 -
What you're looking for is modelling non-conformed dimensions.
https://greatobi.wordpress.com/2013/09/10/the-single-most-important-thing-to-know-about-the-obi-rpd/
0 -
Nice article!
Amazing how many production systems, typically implemented by major consultancies, where when you come to look in the rpd and the content levels and number of elements on dimension hierarchies have not been set.
10 minutes work later and there is a massive performance improvement and things stop erroring.
0 -
It's so typical and symptomatic. The usual attitude and reply is "It works, so f* off and don't you dare voice any criticism, this project was a success for YudgeIntegratorXYZ".
Yeah...right...
0 -
Ok Thank a lot Joel, Gianni, Christian, Robert for your advise!
Now i make calendar with level-based hierarchy.
H-Calendar(month,year)
I set content on LTS:
Client H-Calendar to TOTAL
Account H-Calendar to TOTAL
when i save RPD i get:
[14031] The content filter of a source for logical table: Client (D) references multiple dimensions.
[15001] Could not load navigation space for subject area MY-Subj-Area .
0 -
Did you mean i have to do make hierarchies based on Client and Account too?
0
