[solved] Framework Manager Modelling

[sys2674]

Hi
I have imported a datadabse View,
I have 20 QuerySubject.In each query subject i have a fact_id,and one Fact Query subject. which has a fact_id.
All 20 query subject and relation shiped with this FAct-table with fact_id.

exanple
table AÃ,  Ã, table bÃ,  table cÃ,  Ã,  Fact_table
fact_idÃ,  Ã,  factidÃ,  Ã,  Ã, fact-idÃ,  Ã,  Ã,  fact_id
1Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 4Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 7Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, m2
2Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 5Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 8Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, m3
3Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 6Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 9Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, m4
using a star schema i have created realtionship

Now,I craeted another Namespace
Pulled 1,5,9 from each table and placed in New QuerySubject NumberÃ,  under New name space.(N1)
when i validtaed this Query subject it gives orphan error message
In similar fashion i have created 4 new Query subject.under same namespace (N1)
all this queysubjects when verifed gives as orphan message.

How should i proceed so that i donot get error in report studio while creating reports.

thanks

[sir_jeroen]

Plz give more details on the error

[sys2674]

Hi

Reportnet was unable to pull the data.
I needed to built the model again.
When i spoke to My supervisor,He said he imported the data with Primary and Foreign Key.

But in actual data There were no primary or foreign key.Only the Columns were matching.
exanple
table A   table b  table c    Fact_table
fact_id    factid     fact-id      fact_id
1             4             7             m2
2             5             8             m3
3             6             9             m4

As above e.g fact_id are just matching Column.

I imported metadata Using Matching indexex coulmns name...Its 2nd option while importing.Deselected 1st option.
After importing.Frame work manager builds relation ship depending on the selection.
Then i manually build the relationship for all tables.

Later i created a bussiness view,by pulling qury items from different query subject.
and i was able to build reports.

Thanks

[sir_jeroen]

Could you please close this topic then... See board rules on how to do this