Dilemma with Synthetic Key and Data Modeling

[#1]

I've been dilemma with Synthetic Keys and Data Modeling for my 10 reports and 3 dashboard for my current project.

Let say if i have 5 fact tables and 10 dimensions.

What are the fastest ways to solve the Synthetic keys and produce my reports & data correctly?

I really having time constraint as i'm just beginner but i've given a short time line to produce the reports and dashboard.[:'(]

Thank you.

[#2]

I think the problem is related with the point of view for the task. You need to think about QV table structure more carefully and from stamp point of business needs .

[#3]

Hi Ivan,

Can we concatenate 3 fact table into one, but at the same time, 2 of the 3fact table having few field that are same name? How to solve this?

Do we rename the field?

Thank you

[Miguel_Angel_Baeyens]

Hello,

If you are concatenating, you shouldn't worry about that, because you will have one table instead of three. In case some of the tables have the same field name will not create a synth key, you are already avoiding that concatenating. The issue may be somewhere else.

Regards.

[#5]

Hi Ivan,

Can we concatenate 3 fact table into one, but at the same time, 2 of the 3fact table having few field that are same name? How to solve this?

Do we rename the field?

Thank you

[#6]

Hi Miguel,

Thanks for the reply.

Maybe i use a example to express my doubt on concatenate.

let say i have 3 fact table name as factA, factB, factC.

factA and factB having the same name field as REV_IN_GC. but both REV_IN_GC having different values.

After i concatenate the table, there'll be only one field REV_IN_GC in the concatenate table, am i right?

if i want to pull the data from REV_IN_GC from factB instead of factA, how qlikview identify?

Thank you so much.

Best Regards

[carlos13]

where I can find this tool? as this link does not work