If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dimension without bussines key

Started by b737, 15 Sep 2014 12:06:47 PM

Previous topic - Next topic

b737

I am using DMR and I want to create dimension Costumer (Name, Address, E-mail). But, in the data base Costumer name is free field, does not have Costumer_ID, just name, address.. which operator type in form, and I can not create dimension in DMR, because I don not have business key. Since it is free filed I can not create fake ID, because I do not know in advance all costumers.

Is there any idea how to do this.

Thanks 

Francis aka khayman

you can create a new column to use as businesskey. you can set it to primary key and/or unique autogenerate unique code depending on the database backend you are using.