Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED] Custom Time Dimension: Possible to do daily?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Custom Time Dimension: Possible to do daily?
 Login/Join
 
Guru
posted
Hi Team,

I see in the PMF manual(page 285, version 522) that Weekly is the lowest level possible for a custom time dimension. I implemented a weekly time dimension for a client in the past, so I'm familiar with how this works. My question today is: Can I do a daily custom time dimension?

I believe I could map a four level time dimension that includes Day as the lowest value. I wonder why that won't work, but week will work?

Please let me know.

Cheers,

Joey

This message has been edited. Last edited by: Moogle,


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Master
posted Hide Post
The reason we say it goes down to week is that nobody plans targets at the daily level. It's just not done out there in the real world. If your situation seems to call for day-level metrics, I'd recommend you re-inspect the assumptions you're making about what your client needs. If they are simply looking for day level drill detail, that means the day level data would most probably be in the drill out, not in the PMF data mart. If you compare the volumes over weekly for example you'll have 7 times as much data - almost an order of magnitude. If you're comparing it to monthly you'd have 30 times as much data.

That being said, with custom time, any frequency is possible and Time goes up to five levels.

Note that the data volumes with daily metrics would be quite large - if you had a normal amount of dimensional cardinality, you'd in most cases be dealing with hundreds of millions of rows of metric data. To ensure reasonably good real-time performance you'd need to implement the performance recommendations in the PMF Installation and Configuration Guide, right away.

thanks


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, 2003Report This Post
Guru
posted Hide Post
Hi Bob,

Thank you for the quick reply.

I understand well what you are saying, from a technical and a strategic perspective.

I know that the vast majority of measures would be aggregated at a monthly level, and one or two operational ones might be brought in at a daily level. It seems to me that there would be no need to keep too much history for these daily Measures, perhaps a few months rolling.

We've implemented materialized views and they have made a huge difference for speed. This concept is in my toolbox now, right near the top.

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [CLOSED] Custom Time Dimension: Possible to do daily?

Copyright © 1996-2020 Information Builders