nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Oracle BI Different Subject Area integration

3247122

Hi all!

I recently start working with Oracle BI so i'm just a beginner about that. I've the following problem. I've to integrate two different subject area that have different business model and physical layer too. Unfortunatly I cannot combinated them with the union or intersect operation. So I think about create a new Dimensione, confomed for the two subject area that can create a link between them!

This is my situation

Then i've a Fact2 and many other dimension linked in the same way.All the links represent an inner join.

My purpose is creating an analisys where i can combine values from dimension by two different sub area, so i model the schema in this wayCD, represent Integrated Sub_Area.png

CD represent a conformed dimension. I create this simension in the physical layer of the first Sub Area and then i create a unique BMM and a unique Sub Area, but when i try to cross the data I have an ODB error and I cannot understand why.

If u have many ideas about the problems or in general about linking different sub area i'll be so grace for your helping!

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

Fact Stars have the fact table at the center ... a conformed dimension is one in which it's primary key is found in more than one fact ...

time and products below are conformed ... I can directly relate sales and purchases for the same date and/or product. I can get sales for any product purchased from a supplier (indirectly: I must traverse through the other fact via the conformed dimension)

img src: Microsoft

Invest in going to BI modeling training.

[Deleted User]

Thomas Dodds wrote:

Invest in going to BI modeling training.

^--- that

3247122

Thanks for your helping. Unfortunely i've not design this model but i inherited the two original sub area and i've to link them in a single model. I used the same one approach that u have described but it returns me this error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail. Furthermore I also need to relate two dimension of different area( and fact table too), for example D3 and D5..is this possible with the using of another dimension made in the same ways of the example? Thanks a lot

rmoff

I recently start working with Oracle BI so i'm just a beginner about that.


i've not design this model but i inherited the two original sub area and i've to link them in a single model.

Seriously, and I mean this in a friendly way - get yourself on some OBIEE training.

You're not going to learn OBIEE modelling from yes/no answers on a forum. It's not like writing a SQL statement or a bash script or whatever where if it works, it works. RPDs have to be right, from the ground up - otherwise it might work in a very narrow test case and then fail spectacularly in every other.

[Deleted User]

I can only "Like" this once but let me reinforce the sentiment: Doing/reproducing this because you read them somewhere in an out-of-larger-context thread and properly understanding something is the difference between treating a patient and putting a bullet in his head to stop a leg pain. It works but no...not really.

3247122

Seriously i'm doing that. I'm following all the online courses that i found about OBIEE and i'm trying to making many projects to understand what i learn. But at the same time I'm trying to understand a bigger and a complex project that i inherited and it's not so easy as you think facing so many problems when you don't know perfectly how does it works. I'm not talking about on "how can i fix it" but i just want an opinion on what the problem should be, so i can make more studies about. Anyway thank you the same for your help.

[Deleted User]

Understandable. Your problem - the exact case - needs to be deconstructed and re-modelled according to your needs.

Then you need to get your setup right since your error (14025) means that there's something fishy in your hierarchies and LTS content levels.

Thomas Dodds

This is where you ask leadership for support in training you to do the job correctly -- or they pay an expert to come in and fix it while you shadow them. Currently, it looks like you have little or no management/leadership support OR you haven't pulled the help-chain enough for them to know you need this support.

You've inherited something that is broke at the core -- it needs a fresh start or it won't EVER work.

[Deleted User]

Thomas Dodds wrote:


You've inherited something that is broke at the core -- it needs a fresh start or it won't EVER work.

Is that a challenge?

Manoj Dixit

Hi,

If the business actually functions like that and the sources can support the second model, using ETL and changes to the fact table definitions (or may be new versions), do you think that it is possible to link Fact1 to CD and Fact2 to CD, directly? You may be able to retain the existing relationships in the newer versions of the fact table, as well. Just a thought.

Regards.