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] Ad-Hoc: Separate Dimension and Metrics Fields

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Ad-Hoc: Separate Dimension and Metrics Fields
 Login/Join
 
jsn22
Member
posted
As an InfoAssist user I like to see Dimensions and Metrics in the correct section so that it is clear what's a metric and what's a dimension.

Can you please give me a example how to make separate fields showing in InfoAssist (Dimension and Metric Fields)

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS version 8.1.05
Windows 10
 
Posts: 15 | Registered: November 28, 2007Report This Post
Alex
Platinum Member
posted Hide Post
IA breaks you fields into sections assuming that any numeric field is a metric. If you have numeric dimensions then they will show up in metrics. You could convert numeric dimension fields to Alpha type in the MFD and hide the original fields.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
 
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003Report This Post
jsn22
Member
posted Hide Post
Thanks for your inputs also if you provide an example it will be great.....


WebFOCUS version 8.1.05
Windows 10
 
Posts: 15 | Registered: November 28, 2007Report This Post
George Patton
Master
posted Hide Post
I've had very limited experience with IA and actually find it quite irritating to have the dimensions and measures separated and not displayed in the traditional segmented view. I was trying to teach some users how to create a report and trying to explain to them what the data structure actually looks like is very difficult when fields in parent and child segments are all jumbled up together.


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Report This Post
<Emily Duensing>
posted
By default, dates and alphanumerics will be displayed as dimensions in the Data pane in IA, and numerics will display as measures.

If you don't like that view, select the View tab, and select a different view from the Data Panel group... Logical shows fields in dimensions and measures; List shows fields in a straight list (which you can alphabetize by clicking the fieldname heading); Structured show fields in a segmented view directly from the Master.
 
Report This Post
jsn22
Member
posted Hide Post
Thanks for the inputs.

Can I have an example how to make separate fields showing in InfoAssist (Dimension and Measure Fields)


WebFOCUS version 8.1.05
Windows 10
 
Posts: 15 | Registered: November 28, 2007Report This Post
<Emily Duensing>
posted
jsn22,

Look in the documentation for metadata (DN4501042.1013 page 168 - 173). There is a section on WITHIN on how to create dimensions in the master file. I believe it is only since release 8 (I could be wrong as I haven't done a lot of work with IA prior to 8) that InfoAssist has smart context to know that alphanumerics and date fields are dimensions and numerics are measures. I am thinking prior to 8 you had to declare them in the metadata. Check out the doc... there is an example of there of what a master looks like using WITHIN.
 
Report 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] Ad-Hoc: Separate Dimension and Metrics Fields

Copyright © 1996-2020 Information Builders