 |
|||||
|
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
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] FML - Show all Children | Login/Join |
| <Scott Mc> |
I am trying to build a financial report using FML. I have played with the CENTGL sample and understand how it works (configuring .mas appropriately). We are able to pull into the report the dimension attributes, specify the "For' column, and go into the MAtrix to build out the desired view. We do however get an error message that states "Top element is missing. Would you like to display data anyway?". I don't get this error when working with the IBI sample. My problem lies when I bring in a hierarchy and specify the row property to "Show w/ all children" or Show only children". When I run the report it only shows me the top level and not the children. Has anyone expereinced this issue in the past and be able to provide me with some guidance on this?This message has been edited. Last edited by: Kerry, | ||
|
| Platinum Member |
The top level must have a parent of blank. This is an indication that the specific node is at the highest level of the hierarchy. There is an FML hierarchy validation tool that you could acquire from your branch. I think this is free. | |||
|
| Master |
This is quire confusing. DS is the only thing that requires a starting point for a hierarchy IT IS NOT NECESSARY FOR ORDINARY OPERATION OF WEBFOCUS. In reporting the hierarchy is not preloaded but built on the fly according to the top point. Roughly the algorithm is Build answer set Repeat by level until maximum child level or no more additions (A) scan parent items in answer set for matches at previous level (B) include child item in new level Endrepeat The action of ds is misleading in that it leads you to believe that wf has to build the entire hierarchy and then the subtrees are copied to the various values chosen. The effect of SET FORMULTIPLE=OFF|ON has no effect on the hierarchy created. It only affects the issue when the verb objects are inserted into the matrix. I would advise against children all if you dont have well validated data as a cyclic reference can produce infinite hierarchies.This message has been edited. Last edited by: hammo1j, Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only Topic | View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |