remodeling a cube with a keyfiure(quantity) and a unit(0unit)

[Former Member]

Hi,

while remodelling i am able to add a key figure(quantity) to the cube with a constant value. but i wuld like to add a key figure (quantity) with a unit(0unit) so that i can send values directly from a flat file..

kindly help me on this.

[former_member182226]

Hi Soumya,

If you will add Key figure Quantity lets say 0QUANTITY into Cube then 0UNIT will be automatically entered into UNIT dimension of Cube, because 0UNIT is a reference characteristic(unit) for 0QUANTITY and it is present in Unit / currency.

You want to load 0QUANTITY AND 0UNIT data into cube directly from flat file DataSource , for this make some modification in your flat file DataSource . e.g.

1) Create flat file DataSource

2) In proposal tab load "Load example data" in this you will find Quantity field data type as char/int and Unit field data type as char.

3) change data type for Quantity filed as QUAN and data type for Unit field as UNIT (Unit key for QUAN fields)

4) Now Unit for quantity field will be enable, enter name of unit filed here.

5) also check for any conversion routine present, save and activate it. Now create infopackage to load DataSource .

6) load it to cube (map 0QUANTITY to Quantity field) , now 0QUANTITY and 0UNIT will directly load.

let me know if any other explanation required

Regards,

Avinash