Link table for multiple fact tables without IDs

[cristian_av]

Hi

I have two fact tables wich share some dimensions / dimensions groups.

This fact tables DON'T have ID for the fields, they store the complete text value instead of the id (The text value is below the 20 chars).

What I need is to uso a dimension that could mix the dimensions groups of the two fact tables, but all the documents that I've read explain how to solve this trouble using the ID instead the text value (Generic Keys - Link Tables).

I think that maybe I could use Autonumber function to solve this, but I have no idea how...

Does anybody knows how to deal with it?

Multiple fact tables, same dimensions

Generic keys

[whiteline]

Yes.

You can use the AutonumberHash function. But keep in mind, that the id's are unique only inside the one reload process. So you can't use it to generate id's by two different qvw fieles or incremental relaods.

For that cases you can build more complex unique id's with Hash or something. Then if needed you can replace them using Autonumber id's during final reload to optimize the qvw index size.

[cristian_av]

Actually I'm using incremental reload and multiple qvw files...

Which function can I use to generate hash or something like that? Do you know where I can find more information?

Thank you!

[whiteline]

Hi.

You can build the key using simply the concatenation of your 'key' text fields.