Data is not pulling into cube

[vinothkumar62]

Hi all,
i am working in transformer cube in version 10.2.1. in modelling part i done all the things and when i generate the category i can view the records but after creating the cube the generated data is not getting into the cube. can any one share some ideas on this issue. please help me ASAP.

Hi All - i Finished this issue by importing as single source. I am having one more scenario. I will explain this in detail below.

I am facing very very challenging & more interesting too. Below are the things guys. you can try it too.

In our requirement we have two different scenario. In FM model i achieved this. let me explain the scenario.

Scenario -1:
The direct relationship in data source between all the tables as we did normally.
Scenario - 2:
consider the list of table A,B,C,D,E.
Apart from the relationship what ever have in the data source we need some relation ship to find the error records. When ever the data item involved in this combination ie) A,B,C that error scenario takes place. In this situation number of records will be minimal.
consider Table B as Fact table. But A,B,C combination is not involved it should not activated.

Since transformer takes all the joins simultaneously while importing the source into it. In this situation we could achieve only error records which is a minimal one. we could not achieve the normal relation.
Since we need both the scenario into the single cube. I tried and i completed in two cubes. Is there any possibility to accumulate all the two possibility in one single cube.

[cognostechie]

Hi all,
i am working in transformer cube in version 10.2.1. in modelling part i done all the things and when i generate the category i can view the records but after creating the cube the generated data is not getting into the cube. can any one share some ideas on this issue. please help me ASAP.

I don't have the time right now. I will come back and help you later.

[bdbits]

Please read the forum etiquette, in particular item 2.
http://www.cognoise.com/index.php/topic,24030.0.html

Take note that Transformer will (by default) only include categories that have a related fact. You can change this behavior in the properties for the level. So the first thing is to see if there are facts included that have the categories you are looking for. Also, I have found things work better if your query sources include the primary and foreign key columns (assuming you are using a package), and you should include them in the hierarchies. You can suppress them if you don't want them visible to users, which is what I usually do.

[vinothkumar62]

Hi All - i Finished this issue by importing as single source. I am having one more scenario. I will explain this in detail below.

I am facing very very challenging & more interesting too. Below are the things guys. you can try it too.

In our requirement we have two different scenario. In FM model i achieved this. let me explain the scenario.

Scenario -1:
The direct relationship in data source between all the tables as we did normally.
Scenario - 2:
consider the list of table A,B,C,D,E.
Apart from the relationship what ever have in the data source we need some relation ship to find the error records. When ever the data item involved in this combination ie) A,B,C that error scenario takes place. In this situation number of records will be minimal.
consider Table B as Fact table. But A,B,C combination is not involved it should not activated.

Since transformer takes all the joins simultaneously while importing the source into it. In this situation we could achieve only error records which is a minimal one. we could not achieve the normal relation.
Since we need both the scenario into the single cube. I tried and i completed in two cubes. Is there any possibility to accumulate all the two possibility in one single cube.