convert measure to dimension

[Mel90]

Hi all,
I loaded data from csv file. I have a bunch of id numbers that need to be concatonated together, eg app id = id + type + seq. But, since BO loaded it as measures, bo treats it as an actual addition. To illustrate..

What I want
-----------
id = 12
type = 09
seq = 5

app id = 12095

A clever trick would be id * 1000 + type * 10 + seq but my boss wants nothing like that.

So the question, how do I convert measures to dimensions to I can do a concatonation??

 

[blom0344]

Hello Mel90,

Run report, go to : data --> view data which brings up the data manager. choose tab "Definition" and click on the measure you want to set to a dimension. In datamanager you can now change the objecttype from measure to dimension T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com