Smart View Spread From yearTotal/Qtr to Months Is not Working

We will talk a little about what we need to ensure for data spread to work. For the sake of this discussion, we are assuming our application is set for 445 Distribution. We have many time balance properties, Flow, First, Balance, Average, Weighted Average (Actual and 365), you can read about them in Planning guide. The account we have taken for this example is set to Flow.

You need to select either Idecendants of YearTotal or any of the quarters for period selection. Ex:  @IDESC("YearTotal") or @IDESC(<Qtr Member>) .

Here is one sample data form:

Entered 300 at Q4, values are distributed in 445:

However, if you just select yearTotal and months, spread will not work.

YearTotal is readonly!

Even if you take descendants of any Quarter your spread will work fine.

Now, One of the issues we faced:

Issue: Data spread was working for every user in planning web, however, when they were trying to spread data through smart view it wasn’t working for 40% of the users and not working for 60% of them.

We compared all smart view settings, all active-x controls, everything in trust center, etc. everyone has same settings.

We reached out to Oracle and one of my old friends Dan helped us resolving the issue. Issue was the registration of hsspread.dll, when you install Smart view using regular account this .dll is registered. We have two solutions to overcome this issue:
1.      Manually Register hsspread.dll using regsvr32 command or
2.     Reinstall Smart view using Admin Account. ( right click on SmartView.exe and use Run As Administrator Option)

Also, as per one of the existing bugs, Spread Doesn’t work when you are performing Adhoc Analysis, to ensure above solution works, you have to open form by navigating to the form, right clicking and selecting  “Open Form” option not “Adhoc Analysis”.

Cheers..!!

Rahul S.