5 Replies Latest reply on Jun 2, 2016 2:20 PM by Gianni Ceresa

    creating new logical column in BMM layer

    3174977

      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 !

        • 1. Re: creating new logical column in BMM layer
          Gianni Ceresa

          Hi,

          were does your 2 columns (actual and plan hours) come from? Are they in the same logical table? Do you have a value for both columns in the same row?

          You probably see where I want to end up with my questions but it really depends on your model and where does these 2 columns come from to manage to set the value for your new columns as it will not be able to have both values in the same time, so the rule depends on the source of your 2 existing columns and how they are modelled together.

           

          PS: if the 2 columns come from 2 LTS just set the different values in both LTS.

          • 2. Re: creating new logical column in BMM layer
            3174977

            HI Gianni,

             

            those two columns from two different physical tables and those two columns are being used in the report. let's say they are called actual hours coming from actual table and plan hours coming from plan table.they are two different physical tables in physical layer. In BMM layer those two tables are modeled into one fact table in BMM layer. My question is when we use these two columns in the report can another column be created in such a way it says the type of those hours whether they are actual or plan. Sorry if I am confusing.. Please see the below..I am trying to see if something like the below can be achieved.

            bmm.JPG

            Thanks !

            • 3. Re: creating new logical column in BMM layer
              Gianni Ceresa

              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.

              Capture.PNG

              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

              • 4. Re: creating new logical column in BMM layer
                3174977

                Everything will be in one new logical column right ?

                Thanks !

                • 5. Re: creating new logical column in BMM layer
                  Gianni Ceresa

                  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...