Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    User Entered Measure Rollup Error
Go
New
Search
Notify
Tools
Reply
  
User Entered Measure Rollup Error
 Login/Join
 
Gold member
posted
I have set up a user-entered measure and have three dimensions defined (time, segment, product). After inputting the data and viewing the results on my today page, I am seeing some odd behavior that I am not sure is a setup error or an issue.

My today page is the Measures-Compare to Previous view. The data that I have input is only for October and November. When I click on the Actual column and select Measure Details, on the drill down I see a row for 2009/10 and one for 2009/11. When I click on 2009/11 and select view by product it correctly explodes the data into the proper product categories as defined in the dimension, but the values are displayed as the sum of October + November, instead of just November only.

I have many other measures on other scorecards that behave properly, but they only have the time dimension attached.

I am not sure if this problem is beling caused by the addition of other dimensions, or if I'm missing something in the setup.

When I click on a single month and ask to drill down, I expect to only see that particular month exploded.

If I create a single month ad-hoc report in Analysis Designer, I get what I want, so I can verify the data entry was correct.

Any assistance greatly appreciated

Jeff


PMF 5.1.1
 
Posts: 60 | Registered: December 30, 2008Reply With QuoteReport This Post
Master
posted Hide Post
Sorry nobody's answered this one yet. We'll look into this.

In general you should consider upgrading to 5.1.3; we fixed some aspects of the "tree reports" and use of the Time Dimension in 5.1.3 and that could fix your issue.

5.2.1 will have additional work done in this area, including the ability to control default Dimensional access on these reports.

The best thing about 5.2.1. will be that you can actually dump this report and use a Dashboard to run it, since the DImension Tree is a gadget in 5.2.1, and the report another gadget, so you can not only have the tree automating the report but also other gadgets including Flex gadgets, charts, etc., at the same time.

And the new gadget Dimension tree is also "sticky..." another capability customers have been wanting. That means it remembers and shows you all the nodes you have clicked, for each dimension in the tree, and it's easy to swap and remove the nodes by clicking.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 919 | Registered: March 26, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    User Entered Measure Rollup Error

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.