Synthetic Keys

[NavinReddy]

Dear Experts,

I have synthetic keys in application its giving unwanted results

Budget value is different with the excel data

could some one help me to avoid synthetic keys

Please find the attachment

Thanks In Advance

Niranjan

[Marcio_Campestrini]

Hi Niru

You can replace the fields in tables Budget, Actuals and Forecast that is is synthetic table (Business Unit, Oscar Account Line, Year and Month) by an Key Number e.g., using AutoNumberHash128. After this, link the MasterCalendar with others tables using he same technique.

Hope I helped.

Márcio.

[NavinReddy]

Hi Rodrigo,

Please tell me how can i use

i don't know exactly how to use AutoNumberHash128

if you don't Mind Show me how can i do that, I can follow

Best Regards,

Niranjan

[Anonymous · Accepted solution]

you can use your mastercalendar field for join Budget, Actual, Forecast tables with MasterCalendar

Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear

Make a composite key, like Month & '-' & Year as CalendarMonthAndYear for each Budget, Actual, Forecast tables

And concatenate FC, AC, BU data to the one table:

[Marcio_Campestrini]

Nirajan

The AutoNumberHash128 function works like this (extracted from Qlikview help):

AutoNumberHash128 (expression {, expression})

Computes a 128-bit hash values ​​of the combined input  expression and returns a unique value for each integer value

distinct hash encountered during script execution. this function can be used, for example, to create a representation of compact memory of a composite key.

Example:

AutoNumberHash128 (Region, Year, Month)

Use it with the fields that are common in the tables, creating one for each table.

[NavinReddy]

Hi Konstantins,

There are two more fields Busines Unit and Account line also

again synthetic will happen,

please find the application guide me i can do that

i am little bit confused

Best Regards,

Niranjan

[NavinReddy]

Thank you So much Konstantins,Grete Technique 

you made my day,Thanks Again