How to create a Column for net Due date, Due date for cash discount 1

[Former Member]

Hi everyone,

my Finance Department want to have Customer Line Item Cube,

In the Cube, there are already Columns: Due date, Due date for cash discount 1, and now they want to have a column in the cube like this:

On line Item level:

- If the due date for cash discount 1 is not passed, then only due date for cash discount 1 will be shown

- If the due date for cash discount 1 is passed, then only net due date will be shown

- If the net due date is passed, then the current date will be shown.

Can you please help me how to create this Column?

Because im not familiar with Bex, and its not Standard report form BW.

Thank you very much!

[Former Member]

Thanks,

i want to have it as a Characteristic

[former_member200967]

Then you would need to create this Date value in the cube and use it in the report. However, that solution will not work for records that dont come in Delta load of the cube as the logic will be present in the transformation.

[Former Member]

Hi Can we calculate it as a dimension in Bex?

[former_member200967]

You can try using the Virtual Characteristics for acheiveing this in background and not in the report. Just check once how Virtual Characteristics work and try the option.

[former_member200967]

Here is the link to a document explaining how you can use the virtual characteristics for acheiving your requirement.

[former_member200967]

Hi,

You want to create this column in the Bex report? Do you want to have this new field as a characteristic or it can also be a Key figure?