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     FOC errors when using a Bex Query as data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
FOC errors when using a Bex Query as data
 Login/Join
 
Gold member
posted
(FOC11256) ERROR OPENING SCHEMA ROWSET:
(FOC11202) OLE/DB FOR OLAP INTERFACE ERROR:

Getting those errors when doing a simple TABLE FILE on a Bex Query (SAP-BW) metadata when using a particular field in the WHERE clause. When I remove that field, I don't get the error, but I REALLY need it, oterwise my selection isn't good... Any idea what problem it can be?

Thanks! Confused
 
Posts: 87 | Location: Montreal, QC, Canada | Registered: September 03, 2004Report This Post
Gold member
posted Hide Post
Bump
 
Posts: 87 | Location: Montreal, QC, Canada | Registered: September 03, 2004Report This Post
<Pietro De Santis>
posted
Is there something special about the column?

From the error, it looks like there's OLAP stuff in the metadata ("WITHIN". Did you create a Master using DevStudio?

Have you tried accessing the table and column using a Master without the OLAP stuff in it?
 
Report This Post
Member
posted Hide Post
could I see the failing focexec, including the master file for the Bex query ?
 
Posts: 2 | Registered: November 10, 2004Report This Post
Gold member
posted Hide Post
To make it simple:

The fex -->
TABLE FILE z_wf_ma_sales_payments_etap2
SUM
MA_PAYMENT__TOTAL_
BY
PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_03
WHERE MA_CUSTOMER_GROUP__O_S__N EQ '0003000248';
WHERE SERV__RENDERED_DATE__O_S__N EQ '20040601';
WHERE INVOICE_NUMBER__O_SINGLE__N EQ '0090311903';
WHERE PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_03 NE 'MA';
END

***The WHERE on INVOICE_NUMBER__O_SINGLE__N gives the error

The master file definition -->
FILENAME=Z_WF_MA_, SUFFIX=BWBAPI,$

SEGNAME=Z_WF_MA_, SEGTYPE=S0,$

$ -VARIABLES-

FIELD= PRODUCT_HIERARCHY_NODES,
TITLE= 'Product Hierarchy Nodes',
ALIAS= '[PRDHA]',
USAGE= A124,ACTUAL= A124,MISSING= ON,$

DEFINE PRODUCT_HIERARCHY_NODES_C/A60 =
SUBSTR(124,PRODUCT_HIERARCHY_NODES,
1,60,60,PRODUCT_HIERARCHY_NODES_C);$

DEFINE PRODUCT_HIERARCHY_NODES_N/A64 =
SUBSTR(124,PRODUCT_HIERARCHY_NODES,
61,124,64,PRODUCT_HIERARCHY_NODES_N);$

FIELD= INVOICE_NUMBER__O_SINGLE_,
TITLE= 'Invoice Number (O,Single)',
ALIAS= '[INVNUMOS]',
USAGE= A124,ACTUAL= A124,MISSING= ON,$

DEFINE INVOICE_NUMBER__O_SINGLE__C/A60 =
SUBSTR(124,INVOICE_NUMBER__O_SINGLE_,
1,60,60,INVOICE_NUMBER__O_SINGLE__C);$

DEFINE INVOICE_NUMBER__O_SINGLE__N/A64 =
SUBSTR(124,INVOICE_NUMBER__O_SINGLE_,
61,124,64,INVOICE_NUMBER__O_SINGLE__N);$

FIELD= MA_CUSTOMER_GROUP__O_S_,
TITLE= 'MA Customer Group (O,S)',
ALIAS= '[ZMACGOS]',
USAGE= A124,ACTUAL= A124,MISSING= ON,$

DEFINE MA_CUSTOMER_GROUP__O_S__C/A60 =
SUBSTR(124,MA_CUSTOMER_GROUP__O_S_,
1,60,60,MA_CUSTOMER_GROUP__O_S__C);$

DEFINE MA_CUSTOMER_GROUP__O_S__N/A64 =
SUBSTR(124,MA_CUSTOMER_GROUP__O_S_,
61,124,64,MA_CUSTOMER_GROUP__O_S__N);$

FIELD= SERV__RENDERED_DATE__O_S_,
TITLE= 'Serv. rendered date (O,S)',
ALIAS= '[SERVDOS]',
USAGE= A124,ACTUAL= A124,MISSING= ON,$

DEFINE SERV__RENDERED_DATE__O_S__C/A60 =
SUBSTR(124,SERV__RENDERED_DATE__O_S_,
1,60,60,SERV__RENDERED_DATE__O_S__C);$

DEFINE SERV__RENDERED_DATE__O_S__N/A64 =
SUBSTR(124,SERV__RENDERED_DATE__O_S_,
61,124,64,SERV__RENDERED_DATE__O_S__N);$

$ -MEASURES-

FIELD= MA_PAYMENT__TOTAL_,
TITLE= 'MA payment (Total)',
ALIAS= '0AIO1EEK98PMGSJAYIH1CRPR5',
USAGE= D18.2,ACTUAL= D8,MISSING= ON,$

FIELD= MA_INVOICE_VALUE,
TITLE= 'MA invoice value',
ALIAS= 'CJ5LEFPLB5UOS3TXZ4JHM7MTE',
USAGE= D18.2,ACTUAL= D8,MISSING= ON,$

$ DIMENSION 0MATERIAL (Material):
$ HIERARCHY 0MATERIAL (Material):

FIELD= MATERIAL_LEVEL_01,
TITLE= 'Material Level 01',
WITHIN= '*[0MATERIAL]',
ALIAS= 'LEVEL01',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

$ DIMENSION 0MATERIAL (Material):
$ HIERARCHY PRDHA (Product hierarchy for material MARA):

FIELD= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_01,
TITLE= 'Product hierarchy for material MARA Level 01',
WITHIN= '*[0MATERIAL PRDHA]',
ALIAS= 'LEVEL01',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_02,
TITLE= 'Product hierarchy for material MARA Level 02',
WITHIN= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_01,
ALIAS= 'LEVEL02',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_03,
TITLE= 'Product hierarchy for material MARA Level 03',
WITHIN= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_02,
ALIAS= 'LEVEL03',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_04,
TITLE= 'Product hierarchy for material MARA Level 04',
WITHIN= PRODUCT_HIERARCHY_FOR_MATERIAL_MARA_LEVEL_03,
ALIAS= 'LEVEL04',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

$ DIMENSION 0MATERIAL, PROPERTIES:

FIELD= 0MATERIAL_KEY,
TITLE= 'Material Key',
ALIAS= MEMBER_NAME,
USAGE= A64,ACTUAL= A64,MISSING= ON,$

FIELD= 20MATERIAL_KEY,
TITLE= 'Hierarchy Key',
ALIAS= '20MATERIAL',
USAGE= A64,ACTUAL= A64,MISSING= ON,$

FIELD= AFS__COLOR__KEY_,
TITLE= 'AFS: Color (Key)',
ALIAS= '20AF_COLOR',
USAGE= A5,ACTUAL= A5,MISSING= ON,$

FIELD= AFS__COLOR__MEDIUM_NAME_,
TITLE= 'AFS: Color (Medium Name)',
ALIAS= '50AF_COLOR',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= FABRIC_CONTENT_CODE__KEY_,
TITLE= 'Fabric Content Code (Key)',
ALIAS= '20AF_FCOCO',
USAGE= A5,ACTUAL= A5,MISSING= ON,$

FIELD= FABRIC_CONTENT_CODE__MEDIUM_NAME_,
TITLE= 'Fabric Content Code (Medium Name)',
ALIAS= '50AF_FCOCO',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= TARGET_GROUP__KEY_,
TITLE= 'Target group (Key)',
ALIAS= '20AF_GENDER',
USAGE= A2,ACTUAL= A2,MISSING= ON,$

FIELD= TARGET_GROUP__MEDIUM_NAME_,
TITLE= 'Target group (Medium Name)',
ALIAS= '50AF_GENDER',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= AFS_GRID__KEY_,
TITLE= 'AFS Grid (Key)',
ALIAS= '20AF_GRID',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= AFS_GRID__NAME_,
TITLE= 'AFS Grid (Name)',
ALIAS= '10AF_GRID',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= INTERSECTION__KEY_,
TITLE= 'Intersection (Key)',
ALIAS= '20AF_STYLE',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= INTERSECTION__NAME_,
TITLE= 'Intersection (Name)',
ALIAS= '10AF_STYLE',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= APO_PRODUCT__KEY_,
TITLE= 'APO Product (Key)',
ALIAS= '20APO_PROD',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= APO_PRODUCT__MEDIUM_NAME_,
TITLE= 'APO Product (Medium Name)',
ALIAS= '50APO_PROD',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= BASE_UNIT__KEY_,
TITLE= 'Base Unit (Key)',
ALIAS= '20BASE_UOM',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= BASE_UNIT__MEDIUM_NAME_,
TITLE= 'Base Unit (Medium Name)',
ALIAS= '50BASE_UOM',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= BASIC_MATERIAL__KEY_,
TITLE= 'Basic material (Key)',
ALIAS= '20BASIC_MATL',
USAGE= A48,ACTUAL= A48,MISSING= ON,$

FIELD= PRODUCT__KEY_,
TITLE= 'Product (Key)',
ALIAS= '20BBP_PROD',
USAGE= A32,ACTUAL= A32,MISSING= ON,$

FIELD= PRODUCT__NAME_,
TITLE= 'Product (Name)',
ALIAS= '10BBP_PROD',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= PRODUCT__MEDIUM_NAME_,
TITLE= 'Product (Medium Name)',
ALIAS= '50BBP_PROD',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PRODUCT__LONG_NAME_,
TITLE= 'Product (Long Name)',
ALIAS= '40BBP_PROD',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= COMPETITORS__KEY_,
TITLE= 'Competitors (Key)',
ALIAS= '20COMPETITOR',
USAGE= A10,ACTUAL= A10,MISSING= ON,$

FIELD= COMPETITORS__MEDIUM_NAME_,
TITLE= 'Competitors (Medium Name)',
ALIAS= '50COMPETITOR',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= CONTENT_UNIT__KEY_,
TITLE= 'Content unit (Key)',
ALIAS= '20CONT_UNIT',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= CONTENT_UNIT__MEDIUM_NAME_,
TITLE= 'Content unit (Medium Name)',
ALIAS= '50CONT_UNIT',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= CREATED_ON__KEY_,
TITLE= 'Created on (Key)',
ALIAS= '20CREATEDON',
USAGE= A8,ACTUAL= A8,MISSING= ON,$

FIELD= PRODUCT__KEY_1,
TITLE= 'Product (Key)',
ALIAS= '20CRM_PROD',
USAGE= A32,ACTUAL= A32,MISSING= ON,$

FIELD= PRODUCT__NAME_1,
TITLE= 'Product (Name)',
ALIAS= '10CRM_PROD',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= PRODUCT__MEDIUM_NAME_1,
TITLE= 'Product (Medium Name)',
ALIAS= '50CRM_PROD',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PRODUCT__LONG_NAME_1,
TITLE= 'Product (Long Name)',
ALIAS= '40CRM_PROD',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= CURRENCY__KEY_,
TITLE= 'Currency (Key)',
ALIAS= '20CURRENCY',
USAGE= A5,ACTUAL= A5,MISSING= ON,$

FIELD= CURRENCY__NAME_,
TITLE= 'Currency (Name)',
ALIAS= '10CURRENCY',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= CURRENCY__MEDIUM_NAME_,
TITLE= 'Currency (Medium Name)',
ALIAS= '50CURRENCY',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= DIVISION__KEY_,
TITLE= 'Division (Key)',
ALIAS= '20DIVISION',
USAGE= A2,ACTUAL= A2,MISSING= ON,$

FIELD= DIVISION__NAME_,
TITLE= 'Division (Name)',
ALIAS= '10DIVISION',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= EAN_UPC__KEY_,
TITLE= 'EAN/UPC (Key)',
ALIAS= '20EANUPC',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= EXT__MATL_GROUP__KEY_,
TITLE= 'Ext. matl group (Key)',
ALIAS= '20EXTMATLGRP',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= GROSS_CONTENTS__KEY_,
TITLE= 'Gross contents (Key)',
ALIAS= '20GROSS_CONT',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= GROSS_WEIGHT__KEY_,
TITLE= 'Gross weight (Key)',
ALIAS= '20GROSS_WT',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= INDUSTRY_SECTOR__KEY_,
TITLE= 'Industry sector (Key)',
ALIAS= '20IND_SECTOR',
USAGE= A1,ACTUAL= A1,MISSING= ON,$

FIELD= SOURCE_SYSTEM__KEY_,
TITLE= 'Source System (Key)',
ALIAS= '20LOGSYS',
USAGE= A10,ACTUAL= A10,MISSING= ON,$

FIELD= SOURCE_SYSTEM__MEDIUM_NAME_,
TITLE= 'Source System (Medium Name)',
ALIAS= '50LOGSYS',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= MANUFACTURER__KEY_,
TITLE= 'Manufacturer (Key)',
ALIAS= '20MANUFACTOR',
USAGE= A10,ACTUAL= A10,MISSING= ON,$

FIELD= MANUFACTURER__MEDIUM_NAME_,
TITLE= 'Manufacturer (Medium Name)',
ALIAS= '50MANUFACTOR',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= MANUFACT_MAT_NUMBER__KEY_,
TITLE= 'Manufact.Mat.Number (Key)',
ALIAS= '20MANU_MATNR',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= MATERIAL_CATEGORY__KEY_,
TITLE= 'Material category (Key)',
ALIAS= '20MATL_CAT',
USAGE= A2,ACTUAL= A2,MISSING= ON,$

FIELD= MATERIAL_CATEGORY__LONG_NAME_,
TITLE= 'Material category (Long Name)',
ALIAS= '40MATL_CAT',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= MATERIAL_GROUP__KEY_,
TITLE= 'Material group (Key)',
ALIAS= '20MATL_GROUP',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= MATERIAL_GROUP__NAME_,
TITLE= 'Material group (Name)',
ALIAS= '10MATL_GROUP',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= FORM__KEY_,
TITLE= 'Form (Key)',
ALIAS= '20MATL_GRP_1',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= FORM__NAME_,
TITLE= 'Form (Name)',
ALIAS= '10MATL_GRP_1',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= THERAPEUTIC_CLASS__KEY_,
TITLE= 'Therapeutic class (Key)',
ALIAS= '20MATL_GRP_2',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= THERAPEUTIC_CLASS__NAME_,
TITLE= 'Therapeutic class (Name)',
ALIAS= '10MATL_GRP_2',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= ROYALTY_PARTNER__KEY_,
TITLE= 'Royalty partner (Key)',
ALIAS= '20MATL_GRP_3',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= ROYALTY_PARTNER__NAME_,
TITLE= 'Royalty partner (Name)',
ALIAS= '10MATL_GRP_3',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= LICENSE_PARTNER__KEY_,
TITLE= 'License partner (Key)',
ALIAS= '20MATL_GRP_4',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= LICENSE_PARTNER__NAME_,
TITLE= 'License partner (Name)',
ALIAS= '10MATL_GRP_4',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= MATERIAL_TYPE__KEY_,
TITLE= 'Material type (Key)',
ALIAS= '20MATL_TYPE',
USAGE= A4,ACTUAL= A4,MISSING= ON,$

FIELD= MATERIAL_TYPE__MEDIUM_NAME_,
TITLE= 'Material type (Medium Name)',
ALIAS= '50MATL_TYPE',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= USAGE__KEY_,
TITLE= 'Usage (Key)',
ALIAS= '20MSA_USAGE',
USAGE= A10,ACTUAL= A10,MISSING= ON,$

FIELD= USAGE__LONG_NAME_,
TITLE= 'Usage (Long Name)',
ALIAS= '40MSA_USAGE',
USAGE= A60,ACTUAL= A60,MISSING= ON,$

FIELD= NET_CONTENTS__KEY_,
TITLE= 'Net contents (Key)',
ALIAS= '20NET_CONT',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= NET_WEIGHT__KEY_,
TITLE= 'Net weight (Key)',
ALIAS= '20NET_WEIGHT',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= ORDER_UNIT__KEY_,
TITLE= 'Order unit (Key)',
ALIAS= '20PO_UNIT',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= ORDER_UNIT__MEDIUM_NAME_,
TITLE= 'Order unit (Medium Name)',
ALIAS= '50PO_UNIT',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PROD_HIERARCHY__KEY_,
TITLE= 'Prod.hierarchy (Key)',
ALIAS= '20PROD_HIER',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= PROD_HIERARCHY__NAME_,
TITLE= 'Prod.hierarchy (Name)',
ALIAS= '10PROD_HIER',
USAGE= A20,ACTUAL= A20,MISSING= ON,$

FIELD= CROSS_PLANT_CM__KEY_,
TITLE= 'Cross-Plant CM (Key)',
ALIAS= '20RT_CONFMAT',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= CROSS_PLANT_CM__MEDIUM_NAME_,
TITLE= 'Cross-Plant CM (Medium Name)',
ALIAS= '50RT_CONFMAT',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PRICE_BAND_CATEGORY__KEY_,
TITLE= 'Price Band Category (Key)',
ALIAS= '20RT_PRBAND',
USAGE= A2,ACTUAL= A2,MISSING= ON,$

FIELD= PRICE_BAND_CATEGORY__MEDIUM_NAME_,
TITLE= 'Price Band Category (Medium Name)',
ALIAS= '50RT_PRBAND',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PROCUREMENT_RULE__KEY_,
TITLE= 'Procurement Rule (Key)',
ALIAS= '20RT_PRRULE',
USAGE= A1,ACTUAL= A1,MISSING= ON,$

FIELD= PROCUREMENT_RULE__MEDIUM_NAME_,
TITLE= 'Procurement Rule (Medium Name)',
ALIAS= '50RT_PRRULE',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= SEASON__KEY_,
TITLE= 'Season (Key)',
ALIAS= '20RT_SEASON',
USAGE= A4,ACTUAL= A4,MISSING= ON,$

FIELD= SEASON__MEDIUM_NAME_,
TITLE= 'Season (Medium Name)',
ALIAS= '50RT_SEASON',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= SEASON_YEAR__KEY_,
TITLE= 'Season Year (Key)',
ALIAS= '20RT_SEAYR',
USAGE= A4,ACTUAL= A4,MISSING= ON,$

FIELD= SOURCE_OF_SUPPLY__KEY_,
TITLE= 'Source of Supply (Key)',
ALIAS= '20RT_SUPS',
USAGE= A1,ACTUAL= A1,MISSING= ON,$

FIELD= SOURCE_OF_SUPPLY__MEDIUM_NAME_,
TITLE= 'Source of Supply (Medium Name)',
ALIAS= '50RT_SUPS',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= SIZE_DIMENSION__KEY_,
TITLE= 'Size/dimension (Key)',
ALIAS= '20SIZE_DIM',
USAGE= A32,ACTUAL= A32,MISSING= ON,$

FIELD= IND__STD_DESC___KEY_,
TITLE= 'Ind. Std Desc. (Key)',
ALIAS= '20STD_DESCR',
USAGE= A18,ACTUAL= A18,MISSING= ON,$

FIELD= TYPE_OF_CERT_REQ___KEY_,
TITLE= 'Type of Cert Req. (Key)',
ALIAS= '20UCCERTIFTY',
USAGE= A2,ACTUAL= A2,MISSING= ON,$

FIELD= TYPE_OF_CERT_REQ___MEDIUM_NAME_,
TITLE= 'Type of Cert Req. (Medium Name)',
ALIAS= '50UCCERTIFTY',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= CONSTRUCTION_CLASS__KEY_,
TITLE= 'Construction Class (Key)',
ALIAS= '20UCCONSTCLA',
USAGE= A8,ACTUAL= A8,MISSING= ON,$

FIELD= CONSTRUCTION_CLASS__MEDIUM_NAME_,
TITLE= 'Construction Class (Medium Name)',
ALIAS= '50UCCONSTCLA',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= FUNCTION_CLASS__KEY_,
TITLE= 'Function Class (Key)',
ALIAS= '20UCFUNCCLAS',
USAGE= A8,ACTUAL= A8,MISSING= ON,$

FIELD= FUNCTION_CLASS__MEDIUM_NAME_,
TITLE= 'Function Class (Medium Name)',
ALIAS= '50UCFUNCCLAS',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= UNIT__KEY_,
TITLE= 'Unit (Key)',
ALIAS= '20UNIT_DIM',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= UNIT__MEDIUM_NAME_,
TITLE= 'Unit (Medium Name)',
ALIAS= '50UNIT_DIM',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= WEIGHT_UNIT__KEY_,
TITLE= 'Weight unit (Key)',
ALIAS= '20UNIT_OF_WT',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= WEIGHT_UNIT__MEDIUM_NAME_,
TITLE= 'Weight unit (Medium Name)',
ALIAS= '50UNIT_OF_WT',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= VALUATION_CLASS__KEY_,
TITLE= 'Valuation class (Key)',
ALIAS= '20VAL_CLASS',
USAGE= A4,ACTUAL= A4,MISSING= ON,$

FIELD= VALUATION_CLASS__MEDIUM_NAME_,
TITLE= 'Valuation class (Medium Name)',
ALIAS= '50VAL_CLASS',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= VOLUME__KEY_,
TITLE= 'Volume (Key)',
ALIAS= '20VOLUME',
USAGE= A9,ACTUAL= A9,MISSING= ON,$

FIELD= VOLUME_UNIT__KEY_,
TITLE= 'Volume unit (Key)',
ALIAS= '20VOLUMEUNIT',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= VOLUME_UNIT__MEDIUM_NAME_,
TITLE= 'Volume unit (Medium Name)',
ALIAS= '50VOLUMEUNIT',
USAGE= A40,ACTUAL= A40,MISSING= ON,$

FIELD= PRODUCT_MANAGER__KEY_,
TITLE= 'Product manager (Key)',
ALIAS= '2ZCHEF_PRD',
USAGE= A3,ACTUAL= A3,MISSING= ON,$

FIELD= PRODUCT_MANAGER__MEDIUM_NAME_,
 
Posts: 87 | Location: Montreal, QC, Canada | Registered: September 03, 2004Report 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     FOC errors when using a Bex Query as data

Copyright © 1996-2020 Information Builders