creating new logical column in BMM layer

Question

Hi All,

I am trying to create a new logical column in BMM layer with the below logic.. But I am not sure how to put the same in expression. I have two columns actual hours and plan hours. Now I wanted to create new column called Type which should for actual hours the type should be 'Actual' & for plan hours the type should be 'Plan'. How to create a new column with this logic..will it possible to create..Any suggestions.

Thanks !

Gianni Ceresa · Answer

Yes, you will have a single column in the logical layer and presentation layer (in the picture above it's the "Source" column, "Column A" is just there as random column returning some other data...

3174977 · Answer

Everything will be in one new logical column right ?

Thanks !

Gianni Ceresa · Answer

Hi,

You seems to have the good model to solve this easily ...

So you have 2 physical tables, going into 2 logical table source into the same logical table.

Look at this picture, it's what you can try to do it.

The idea is to add a new column in your logical table (in my picture it's the one named "Source").

This new column is derived from a physical mapping and you enter the value you want (so "Actual" or "Plan") as the physical mapping.

You write the value (the text) by hand: for the logical table source pointing on your actual data you write 'Actual', for the logical table source pointing to your plan data you write 'Plan'.

Done