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] Classifying columns into Measures and Dimensions

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Classifying columns into Measures and Dimensions
 Login/Join
 
Silver Member
posted
Hi,

I need some help in modeling data.

Once I create the synonym i want to classify the columns into dimensions/measures.

By default webfocus treats
all numeric columns as Measures
&
all character columns as dimensions.

But i dont want this, i want to define which column is a measure/dimension.

Ex: If there are columns like account number, SSN i dont want these columns to be classified as measures.

Any help on this is appreciated.

Thanks,
Amarnath

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


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Virtuoso
posted Hide Post
Is this concerning PMF? If so, you will receive better responses by posting in the forum for Performance Management Framework issues.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Silver Member
posted Hide Post
No, it is not related to PMF.

This issue is when i open the model in Infoassist the columns are wrongly classified as measures/dimensions.


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Master
posted Hide Post
Are you looking for Business View then here it is

"Creating Business Views" under Chapter -3

http://documentation.informati...61ddgt/wf761ddgt.pdf
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Silver Member
posted Hide Post
Hi Ram,

Thanks for the advice.

My issue does not solve by creating a business view.

Even though you create a business view, there is no way you can classify the columns as measures/dimensions.

Suppose i create a business view with columns

merchant number (it is numeric)
account number (it is numeric)
merchant name (it is character)
merchant fees (it is numberic)

According to the business only merchant fees is a measure.
But webfocus is treating merchant number, account number, merchant fees as measures.

This is creating inconvienience for the business users while dragging and dropping the columns in infoassist.

Thanks,
Amarnath


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Expert
posted Hide Post
My general and long-standing feeling is that if you are not going to do arithmetic with a field even if it has numbers in it, then they should be defined as alphanumeric.

What kind of file is this? Would this be a simple matter of changing the usage format in the master? Also there are tricks you can use in the master definition like using defines to get the fields in the formats most useful to you.

Just some thoughts...


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Master
posted Hide Post
In Business view you can create folder like structure and group all measures under one and dimensions into different folders like account_details, time_dimension and so on.

Hope this helps.
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Silver Member
posted Hide Post
Thank you Ginny for your thoughts.

I will work with your solution of defining them as alphanumeric.

My last question is if we are using a business view, cant we define dimensions hierarchies?

Why we cant define any dimension hierarchy in business view?

Thanks,
Amarnath


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Member
posted Hide Post
You can define dimensions and measures in the Synonym Editor in Developer Studio. Click on the Modeling View Tab. Then from the Modeling View select Synonym -- Dimension Builder.

Do a search in Developer Studio help on Dimensions.


WF 7.7.01
Reporting Server on zLinux or Windows
Client on linux
Output formats - EXL2K, HTML, PDF
 
Posts: 14 | Registered: October 06, 2006Report This Post
Silver Member
posted Hide Post
If you open a synonym you have an option of using the dimension builder,

but..
when you open a business view there is no option of dimension builder...

Can you check it once?


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Member
posted Hide Post
quote:
Originally posted by GinnyJakes:
My general and long-standing feeling is that if you are not going to do arithmetic with a field even if it has numbers in it, then they should be defined as alphanumeric.

What kind of file is this? Would this be a simple matter of changing the usage format in the master? Also there are tricks you can use in the master definition like using defines to get the fields in the formats most useful to you.

Just some thoughts...


This works generally, but think of a column like week number in year (i.e. values 1 - 52). It is a perfect example of a dimension rather than a measure, since you will never do any arithmetic with the field. But when you make it an alpha, it sorts incorrectly:

1
10
11
12
13
..
2
20
21
..
etc.

I really wish the tool would allow you to specify if a field is a dimension or a measure. In the meantime, do you know a good workaround?


WF Server: 7.6.10 on Linux, ReportCaster, MRE, Flex
Data: Oracle
Output: HTML,PDF,EXL2K, AHTML, Flex
WF Client: 7.6.10 on Windows XP
 
Posts: 6 | Registered: August 12, 2009Report This Post
Silver Member
posted Hide Post
NO, As of now didnt find any good workaround.

I think there needs to be lot of improvement on modeling the dataset from webfocus.


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Virtuoso
posted Hide Post
I'm not familiar with InfoAssist, so I don't know how much latitude you have in modifying the work flow. So this is a wild guess kind of idea. Is it possible to create a dummy master (with accompanying access file, if necessary) that has the desired columns defined in such a way (numeric versus alpha) so InfoAssist will correctly display them as dimensions and measures? After the user selects columns for the report, can you insert a procedure or some code (or use a LET) to point the query to the real master/data source?


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Member
posted Hide Post
Reply to gkoerk

Define your week number as A2 and use a function to insert leading zeroes i.e. 01,02,03,...,09,10,11 etc, then it sorts correctly!

Of course, for week numbers, sometimes you do want to perform arithmetic (number of weeks elapsed etc), so have both versions in your table and use whichever is relevant.


WebFocus 7.6.11
IBM iSeries
 
Posts: 14 | Location: Leeds, England | Registered: May 16, 2005Report This Post
Silver Member
posted Hide Post
Is there any possibility on this or we good with all the possibilities?


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Virtuoso
posted Hide Post
This may be long winded, but it does work. If there is a field in your master like:

    FIELDNAME= WORKNR, ALIAS=worknr, USAGE=I11, ACTUAL=I4,
     TITLE='employee,no.', DESCRIPTION='employee no.', $
This will come up as a MEASURE.

Create a DEFINE:
DEFINE WORKNUM/A11 = FTOA(worknr,'(F11)','A11');
      TITLE='employee,no.', DESCRIPTION='employee no.',$
This will come up as a DIMENSION, but as a DEFINEd dimension, which looks ugly.

So create a Business View:
    FIELDNAME=WORKNUM, ALIAS=WORKNUM, $

This will show up as a true DIMENSION. Much neater.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report 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] Classifying columns into Measures and Dimensions

Copyright © 1996-2020 Information Builders