Issue when doing custom calculation based on two fact columns in report level

Question

Hi,

I am facing issue when we perform calculation on top of two fact columns in report.

In obiee Report, i already have two columns which is form two different fact. E.g column 1 took from fact1.col_qty1 where i did sum on report not in rpd. column 2 from fact2.col_qty2 where sum done it in rpd level.

Now i want to perform fact.col_qty1 - fact2.col_qty2 in the new third column. but the problem here is there two facts are having different level if data. one fact will display data in warehouse level and other will be in store level. so both have some contradiction. because of that i ma not able to do this calculation soon report level. RPD level also i cant able to do.

individually these columns are working fine in a single report. But when try to do any operation by using these two together facing issue. Is there a way where i can place the value in some variable and using the variable directly do the calculation. Because i don't want those calculation to hit rpd and return data. that will not give proper result to me. Like BIP template calcualtion kind of.

Vanathi-Oracle · Answer

Its because, the report design is like that. we are showing the report in store level. but only one column have to act in different level and needs to show in the same report. When i show seperately that column, theer is no issue. but issue when do the calculation. it either take only warehouse or store.

thats why is there a way that i can do a report level calculation instead of bringing the column form subject area.

jackohug · Answer

because of that i ma not able to do this calculation soon report level. RPD level also i cant able to do.

Why not? What happens when you try?

The levels of the facts shouldn't matter – if you have them both displaying in an Analysis I can't think why you wouldn't be able to do a calculation between them.