topic Re: Ambiguous while data modeling. in QlikView

Ambiguous while data modeling.

Tue, 05 Jan 2016 05:38:13 GMT

Hi All,

I have loaded data from Oracle DB of (BI data)

Loaded data is SALES, PRODUCTS, CUSTOMER, COUNTRY, PROMOTIONS,TIMES,COSTS.

Applied Inner Join for (Product and cost) & (Country and Time).

I have done this to avoid Synthetic keys but now all table are directly or indirectly attached to Product table.

Re: Ambiguous while data modeling.

engishfaque — Tue, 05 Jan 2016 09:54:57 GMT

Dear Narsing,

Remove circular loop from your data model.

Remove or Rename your CHANNEL_ID as the circular loop can be removed.

Kind regards,

Ishfaque Ahmed

Re: Ambiguous while data modeling.

ramasaisaksoft — Tue, 05 Jan 2016 10:25:26 GMT

Hi Narsing,

What you want exactly? output

As per my understanding ,try to resolve circular loop for that

1) u can alias the field names individually with in table

2) Remove unnecessary columns from script

3) try to use Qualify & Un-qualify fields depends on ur requirement

else please create a temp excel file with your data then we will send example qvw file with your output

Re: Ambiguous while data modeling.

Peter_Cammaert — Tue, 05 Jan 2016 10:37:01 GMT

IMHO you should connect dimension tables as much as possible to your facts table (SALES). A quick way to do this is to detach PROD from COUNTRY (?) and attach PROD to SALES by way of PROD ID. If you have time- & channel-based records in your products table, create a composite key from PROD ID, CHANNEL ID and TIME to connect PROD to SALES.

But to be able to create a correct data model, we need to know what these tables and fields really contain. I hope you do know what's in them. Can you shed some light on these tables?

Peter