TM1 Forum

I am trying to display a simple Profit/Loss in Cognos Express ...The view has been created with the income lines and 12 months display of numbers.

When i create an ActiveForm out of that view...the numbers are ALL incorrect !! The DBRW() fomula points to the correct dimension parameters but all the months are displayed as "zero" when there correct values in the original cube views. The last month (June) is displaying the values for "All Periods" which that column (like others) are showing "zeros" when there should be values.

Has anyone encountered such a problem....

Thx

Hi!

Can you tell a little bit more about your issue? Did you create your view from CubeViewer and didn't modify anything?

If you modify few things, then it may be for multiple reasons.

When you edit your formula in Excel (F2) and then validate your formula, do you get your number?
If yes, check your TM1RptView formula for that.

Cheers,

First, I would check if your formulas are picking up the correct dimension element references, by changing the DBRW to DBR. If values are showing with DBRs then read on...

A tricky thing about activeforms is that generally requires you to include all relevant elements in your cubeview.

For example, if you have created a cube view that has limited your version/scenario element to Budget only. The TM1RPTTITLE part in the TM1RPTVIEW formula cuts down on the cube slice, to get better performance.

But after bringing this cubeview to an activeforms (with only budget scenario), you have decided to look up for values from the forecast scenario, then dbrw fomulas will return 0.

If that's the case, there are a couple of options:
1. Remove the TM1RptTitle component from the TM1RptView formula that has restricted the data to be retrieved. Beware though, this will have an impact on the performance.
2. Instead of using DBRW, change to DBR for those columns that are getting data from outside of the restricted cube slice.

Thanks ..will have a go with your suggestion.