Skip to Content

Calculated Fields Disappear in report SAP BO

Hello Experts,

we have a scenario where we have to change existing tables(used in Universe (IDT) taken from Oracle) to view's. We have already created 200 plus reports in our organisation.

The tables are successfully replaced with views in the universe..The reports are working fine But we have few calculated fields created in the data foundation. These fields are throwing error when the reports are opened.. When we create a new variable with same calculated formula and different name it is working fine.

We want a solution where we need the existing variables to work so that we don't have to change calculated fields in all the reports.

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 13, 2017 at 07:43 PM

    if additional objects are created in the DF table then have you created the same in new View?if yes after that have you mapped these to in the busies layer objects?

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for the reply. Here we are talking about the database views not DF views.

      The Views which we are importing from Oracle does not have any calculated fields. We already had calculation fields in the datafoundation, we tried to replace the table name with views in the already existing calculated coloumns , then use these fields in the Business layer.. when we parse it in the business layer, it is validating successfully but if we use these calculated objects in the report we are getting errors .Other normal fields of Views are replaced automatically in each report. But for these calculated fields we have to go and change in each report. I believe the object ID is changing..thats the reason we are getting error in the report. We need a solution where we don't need to re drag and drop the object and manually change this object in the formulas of the respective report..