Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Documentation for type conversion from database to metadata
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Documentation for type conversion from database to metadata
 Login/Join
 
Member
posted
I'm trying to determine what data type in MS SQL server converts to a type D in WebFOCUS metadata. Has anyone seen documentation that describes this?
(Example database type X, column type Y converts to Z type in metadata)
What I'm seeing is columns formatted as DECIMAL or DOUBLE both create column type P in the metadata.

I am trying to format a percentage with the p option which multiplies by 100 and adds the % sign, but it is not supported on types I and P.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 29 | Registered: July 17, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Hi Tim

Sorry I missed this post... In 8.2.06 if you DEFINE a field D20.2p it will calculate the percentage of the field you put in the expression and add a % sign to it.

this is a sample from the wf_retail master
DEFINE COG_PERCENT/D20.2p MISSING ON=COGS_LOCAL; $


Hope you are doing well, I miss the old days!


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2055 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Documentation for type conversion from database to metadata

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.