Duplicate Fact Table and Rename all fields

[2908nmadao]

Dear community members,

I have a quiet complex data model with no synth keys at all. I have a LinkTable where I store all KeyFields and connect all other fact tables.

I came up to an issue now that I don't seem to be able to resolve.

I need to associate 3 different tables to a single calendar in order to calculate 3 different SLAs and measurements.

Could you please tell me if there is a way of duplicating a fact table/rename all fields/drop the duplicated table?

Thank you very much for your help!

Kind regards,

/NA.

[Gysbert_Wassenaar]

Duplicating fact tables sounds like a rather bad idea to me. I'm pretty sure there's another possible solution. Can you explain your data model in more detail and what you're trying to achieve as end result. What's the problem that you think duplicating your fact table is the answer for?

If you're not interested then look at the QUALIFY and UNQUALIFY keywords:

QUALIFY *;

MyDuplicateFactTable:

LOAD * RESIDENT MyFactTable;

UNQUALIFY *;

[#3]

Please post qvw with some test data.

[MarcoWedel]

"3 different tables to a single calendar" sounds like a use case of

Canonical Date

hope this helps

regards

Marco