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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Best Practice in WebFOCUS with Hierarchy-Tables?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Best Practice in WebFOCUS with Hierarchy-Tables?
 Login/Join
 
Member
posted
1.1 problem description
The target is to provide a dimension and a fact table through the capabilities of IBI to the end user. The end user should be able to make a drilldown through the complete hierarchy down to the leaf nodes.

The starting point is a dimension with the following characteristics:
- unbalanced dynamic hierarchy
- the lower levels consist of not summable kpi’s
- redundant sections in the tree

The following picture shows an example tree. Right beside a node an operator is drawned. The operator describes the rule how to build the node in scope out of the related child nodes.

The dotted line shows a special relation. The referenced child node is assigned to two parent nodes.
The kpi representing the root node of the section is reused.





The following sections describe the characteristic and the issues in more detail.
1.2 dynamic tree structure and unbalanced hierarchies
The structure of the tree is dynamic. It is possible to add new levels and assign new relations through a configuration task.
The tree represents a business formula. That’s the reason why the tree isn’t balanced and the operators are not determined through a specific level. Every path down the tree has its own structure and operators.

It is also not possible to name the different levels in an unique manner like in a time dimension (year, month, day).

The following issues have to be detected:
- how can IBI handle a dynamic number of levels in the hierarchy?
- how can IBI handle the different operators in a level?
- how to model and handle the unbalanced hierarchies?

1.3 redundant tree sections
There is a requirement to reuse calculated kpi’s.
In the tree these kpi’s are represented as tree sections.
The root node of such a section can have more than one parent. So it is not a pure tree anymore.

The following issues have to be detected:
- is IBI capable to handle such a data structure?
- are there requirements how to present such a data structure to IBI?

1.4 non summable kpi‘s
For every node there is an operator defined. These operator defines the calculation method of the node of interest out of the child nodes.
Not all of these operators are summable.
But we want these nodes to be elements of a dimension, to get the information how this node is composed and to make a drill down to get the constructing numbers.

The following issues have to be detected:
- is it possible to combine summable and not summable kpi’s in one dimension?
- is it possible to make a drill down down to the leaf nodes?
- can this drill down show the constructing numbers of the child nodes also when there is a e.g. division-operator?

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Linux, All Outputs
 
Posts: 7 | Registered: January 28, 2016Report This Post
Platinum Member
posted Hide Post
You want us to work on your RFI proposal?


WebFOCUS 8105m
Windows 7, All Outputs

Member of the Benelux Usergroup
 
Posts: 198 | Location: Amsterdam | Registered: August 24, 2011Report This Post
Member
posted Hide Post
Yes, why not, if You can help.
You could be payed by IB-Switzerland, ask Giuseppe Scattarreggia, the local Consulting Leader.


WebFOCUS 8
Linux, All Outputs
 
Posts: 7 | Registered: January 28, 2016Report This Post
Virtuoso
posted Hide Post
If you want help with this, perhaps you should edit your post so that it's a bit less unreadable?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Member
posted Hide Post
More readable (sorry for that):

1.1 problem description
The target is to provide a dimension and a fact table through the capabilities of IBI to the end user. The end user should be able to make a drilldown through the complete hierarchy down to the leaf nodes.

The starting point is a dimension with the following characteristics:
- unbalanced dynamic hierarchy
- the lower levels consist of not summable kpi’s
- redundant sections in the tree

The following picture shows an example tree. Right beside a node an operator is drawned. The operator describes the rule how to build the node in scope out of the related child nodes.

The dotted line shows a special relation. The referenced child node is assigned to two parent nodes.
The kpi representing the root node of the section is reused.




The tree represents a business formula.

The following sections describe the characteristic and the issues in more detail.
1.2 dynamic tree structure and unbalanced hierarchies
The structure of the tree is dynamic. It is possible to add new levels and assign new relations through a configuration task.
The tree represents a business formula. That’s the reason why the tree isn’t balanced and the operators are not determined through a specific level. Every path down the tree has its own structure and operators.

It is also not possible to name the different levels in an unique manner like in a time dimension (year, month, day).

The following issues have to be detected:
- how can IBI handle a dynamic number of levels in the hierarchy?
- how can IBI handle the different operators in a level?
- how to model and handle the unbalanced hierarchies?

1.3 redundant tree sections
There is a requirement to reuse calculated kpi’s.
In the tree these kpi’s are represented as tree sections.
The root node of such a section can have more than one parent. So it is not a pure tree anymore.

The following issues have to be detected:
- is IBI capable to handle such a data structure?
- are there requirements how to present such a data structure to IBI?

1.4 non summable kpi‘s
For every node there is an operator defined. These operator defines the calculation method of the node of interest out of the child nodes.
Not all of these operators are summable.
But we want these nodes to be elements of a dimension, to get the information how this node is composed and to make a drill down to get the constructing numbers.

The following issues have to be detected:
- is it possible to combine summable and not summable kpi’s in one dimension?
- is it possible to make a drill down down to the leaf nodes?
- can this drill down show the constructing numbers of the child nodes also when there is a e.g. division-operator?


WebFOCUS 8
Linux, All Outputs
 
Posts: 7 | Registered: January 28, 2016Report This Post
Virtuoso
posted Hide Post
TL;DNR

From a glance, it seems to me that your best option is to put that stuff in a database and let WebFOCUS (I assume that's what you mean when you say "IBI") just query that.

If that doesn't answer your question, perhaps you should put it rather more concise. At this point it's not clear to me at least what your question boils down to. Perhaps it would already help if you'd add the picture (use an outside public source to store it) that you're referencing.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Best Practice in WebFOCUS with Hierarchy-Tables?

Copyright © 1996-2020 Information Builders