Cleaning up QVW

[#1]

Hi,

I have a a big QVW which loads data from several different QVDs. I got help here in the community and it does what it supposed to.

But I was wondering if it would be possible to create a more neater version of this. I provide a word document with the setup as it is.

I have made this tablenaming so that it wount make unnecessary synthetic keys only Accountid and tradedate as they appear in every table.

Do you have any suggestions in what I can improve here?

[#2]

Hi,

The script looks pretty clean. I would look at the possibilities of Concatenating tables where possible.

Regards,

Pravesh

[Anonymous]

Hi,

I agree with Pravesh. Perhaps try creating a fact table with different dimensions. The RBA tables can be one table if concatenated