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] FOC32686 - Dimension view definition conflict in cluster and base master

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] FOC32686 - Dimension view definition conflict in cluster and base master
 Login/Join
 
Gold member
posted
Hey all,
We have just run an upgrade from 8105M to 8201M and as painful as the overall process was, we are finally up and running on it.
Inside of App Studio however, I am getting the following error message;
(FOC32686) DIMENSTION VIEW DEFINITION CONFLICT IN CLUSTER AND BASE MASTER FOR 'FIELD NAME'
This error message doesn't pop up in InfoAssist when the chart is ran, and within App Studio, if I select to "rerun in new window" the chart will display just fine.
Has anyone seen this yet?
Thanks for any help!

This message has been edited. Last edited by: FP Mod Chuck,


Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
 
Posts: 63 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016Report This Post
Virtuoso
posted Hide Post
Larissa

Post the master file(s) and cluster file definitions so we can see if there is something amiss. That said... If it worked fine in 8105 and not in 8201 you probably should open a case and have techsupport address the issue.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Gold member
posted Hide Post
Hey Chuck,
So I don't see where a description is listed for either the dimension or the active synonym that references the dimension that's throwing the FOC32686. I have descriptions in for each field within the dimension and those all tie out to each other

When I try to open the active synonym, I now get a FOC205 error that reads, THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED; DW_DATA/A_RPT_GL_FINANCIALS. When I click on that hyperlink to the FOC205, I get "No data description can be found for the file requested. Check the Master File Descriptions allocated or available, or the spelling of the file name. If you are in Screen Painter, type IGNore to continue, or any other input to return to TED.

Here is the txt for the MST_DIM_GL_ACCT:
FILENAME=MST_DIM_GL_ACCT, SUFFIX=SQLMSS , BV_NAMESPACE=OFF, $
SEGMENT=GL_ACCOUNT_DIM, SEGTYPE=S0,
DESCRIPTION='GENERAL LEDGER - Provides descriptions for the General Ledger Accounts used for financial reporting.', $
FIELDNAME=GL_ACCT_KEY, ALIAS=GL_ACCT_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Account Key', DESCRIPTION='Primary Surrogate Key for Dimension', $
FIELDNAME=GL_ACCT_DURABLE_KEY, ALIAS=GL_ACCT_DURABLE_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Account Durable Key', DESCRIPTION='Alternate Surrogate Key for Dimension to support Type 2 SCD', $
FIELDNAME=GL_ACCT_NUM, ALIAS=GL_ACCT_NUM, USAGE=A15V, ACTUAL=A15V, FIELDTYPE=R,
TITLE='GL Account Number', DESCRIPTION='Full GL with branching. Sample (01-109-511580)', $
FIELDNAME=ALLOW_LINE_ITEM, ALIAS=ALLOW_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='Allowance Line Item', DESCRIPTION='Type of product the Allowance is for. Sample (Personal Secured, Unsecured, TDR)', $
FIELDNAME=BOARD_LINE_ITEM, ALIAS=BOARD_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='Board Line Item', DESCRIPTION='Summary to sort GL''s, for reporting level higher that Financial Statement Line Item. Sample (Transaction Fees, Over Draft Fees)', $
FIELDNAME=BUD_LINE_ITEM, ALIAS=BUD_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='Budget Line Item', DESCRIPTION='GL ledger number with account description. Sample (171258 Accum Depr - ATM)', $
FIELDNAME=FS_LINE_ITEM, ALIAS=FS_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='FS Line Item', DESCRIPTION='Summary to sort GL''s into Financial Statement Line item order. Sample (Computer Operations, Office Operations)', $
FIELDNAME=FS_SORT_CD, ALIAS=FS_SORT_CD, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='FS Sort Code', DESCRIPTION='Number to sort GL''s into Financial Statement Line item order. Sample (750, 760, 740)', $
FIELDNAME=GL_ACCT_DESCR, ALIAS=GL_ACCT_DESCR, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='GL Account Description', DESCRIPTION='Written description of GL Account. Sample (Accum Depr - Network, Furniture and Fixtures)', $
FIELDNAME=GL_ACCT_TYPE, ALIAS=GL_ACCT_TYPE, USAGE=A3V, ACTUAL=A3V, FIELDTYPE=R,
TITLE='GL Account Type', DESCRIPTION='Just GL, not useful for GL Metaview. Sample (GL, TOT)', $
FIELDNAME=GL_BR_NAME, ALIAS=GL_BR_NAME, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='GL Branch Name', DESCRIPTION='Name of the branch that owns the GL. Sample (Bonner County, Northtown Square)', $
FIELDNAME=GL_BR_NUM, ALIAS=GL_BR_NUM, USAGE=I6, ACTUAL=I2, FIELDTYPE=R,
TITLE='GL Branch Number', DESCRIPTION='Number of the branch that owns the GL. Sample (107, 108, 109)', $
FIELDNAME=GL_DB_CR, ALIAS=GL_DB_CR, USAGE=A2V, ACTUAL=A2V, FIELDTYPE=R,
TITLE='GL Debit Credit', DESCRIPTION='Normal account balance is either Debit or Credit. Sample (DR, CR)', $
FIELDNAME=GL_LDGR_NUM, ALIAS=GL_LDGR_NUM, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Ledger Number', DESCRIPTION='The GL number does not include branching. Sample (220320, 220300)', $
FIELDNAME=GL_LDGR_TYPE, ALIAS=GL_LDGR_TYPE, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='GL Ledger Type', DESCRIPTION='Sort for Income Statement only Non-Interest Income and Expense are available. Sample (Asset, Statistical, Liability)', $
FIELDNAME=GL_LVL_NUM, ALIAS=GL_LVL_NUM, USAGE=I6, ACTUAL=I2, FIELDTYPE=R,
TITLE='GL Level Number', DESCRIPTION='Extra field in PHX, current all have 100 or the 01 at beginning of full GL. Sample (100, 30, 20)', $
FIELDNAME=LOCK_FLAG, ALIAS=LOCK_FLAG, USAGE=A1, ACTUAL=A1, FIELDTYPE=R,
TITLE='Lock Flag', DESCRIPTION='Notes the GL is locked, only closed GL''s are being locked. Sample (Y, N)', $
FIELDNAME=NCUA_CD, ALIAS=NCUA_CD, USAGE=A10V, ACTUAL=A10V, FIELDTYPE=R,
TITLE='NCUA Code', DESCRIPTION='The number code of NCUA for each GL. Sample (730A, 009A)', $
FIELDNAME=PSTAR_LINE_ITEM, ALIAS=PSTAR_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='PSTAR Line Item', DESCRIPTION='Line item used in PSTAR. Sample (Other Assets, Cash, Mtg CUNA Riverbend)', $
FIELDNAME=PSTAR_TYPE, ALIAS=PSTAR_TYPE, USAGE=A10V, ACTUAL=A10V, FIELDTYPE=R,
TITLE='PSTAR Type', DESCRIPTION='GL number used in PSTAR. Sample (170101, 40220)', $
FIELDNAME=RADDON_LINE_ITEM, ALIAS=RADDON_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
TITLE='Raddon Line Item', DESCRIPTION='For reporting to Raddon this indicates the group the account is in. Sample (UNSECURED LOC, SOLD MORTGAGE, SOLD AUTO, PLATINUM CARD, HELOC)', $
FIELDNAME=PROD_LINE_ITEM, ALIAS=PROD_LINE_ITEM, USAGE=A40V, ACTUAL=A40V, FIELDTYPE=R,
MISSING=ON,
TITLE='Product Line Item', DESCRIPTION='The field links GL numbers to the corresponding loan or deposit product class code. Sample (420, 465, 550, 555, etc.)', $
FIELDNAME=ETL_VERS_START_DTM, ALIAS=ETL_VERS_START_DTM, USAGE=HMDYYs, ACTUAL=HYYMDs, FIELDTYPE=R,
MISSING=ON,
DESCRIPTION='ETL/DW Metadata', $
FIELDNAME=ETL_VERS_END_DTM, ALIAS=ETL_VERS_END_DTM, USAGE=HMDYYs, ACTUAL=HYYMDs, FIELDTYPE=R,
MISSING=ON,
DESCRIPTION='ETL/DW Metadata', $
FIELDNAME=ETL_VERS_CURR_FLAG, ALIAS=ETL_VERS_CURR_FLAG, USAGE=A1, ACTUAL=A1, FIELDTYPE=R,
MISSING=ON,
DESCRIPTION='ETL/DW Metadata', $
FIELDNAME=ETL_SNAPSHOT_DTM, ALIAS=ETL_SNAPSHOT_DTM, USAGE=HMDYYs, ACTUAL=HYYMDs, FIELDTYPE=R,
MISSING=ON,
DESCRIPTION='ETL/DW Metadata', $
DEFINE ATM_LIST/A29V=IF SUBSTR( 40, GL_ACCT_DESCR, 1, 11, 11, 'A11V' ) EQ 'ATM Cash - ' THEN SUBSTR( 40, GL_ACCT_DESCR, 12, 40, 29, 'A29V' ) ELSE 'Z Other - Do Not Use';
TITLE='ATM List', DESCRIPTION='List of STCU ATMs, based on GL description starting with the string ''ATM Cash - ''', $
DEFINE ETL_VERS_START_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, YEAR);
TITLE='ETL_VERS_START_DTM,Year', $
DEFINE ETL_VERS_START_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, QUARTER);
TITLE='ETL_VERS_START_DTM,Quarter', $
DEFINE ETL_VERS_START_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, MONTH);
TITLE='ETL_VERS_START_DTM,Month', $
DEFINE ETL_VERS_START_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, DAY);
TITLE='ETL_VERS_START_DTM,Day', $
DEFINE ETL_VERS_START_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, YEAR);
TITLE='ETL_VERS_START_DTM,Y', $
DEFINE ETL_VERS_START_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, QUARTER);
TITLE='ETL_VERS_START_DTM,Y-Q', $
DEFINE ETL_VERS_START_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, MONTH);
TITLE='ETL_VERS_START_DTM,Y-M', $
DEFINE ETL_VERS_START_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, DAY);
TITLE='ETL_VERS_START_DTM,Y-M-D', $
DEFINE ETL_VERS_END_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, YEAR);
TITLE='ETL_VERS_END_DTM,Year', $
DEFINE ETL_VERS_END_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, QUARTER);
TITLE='ETL_VERS_END_DTM,Quarter', $
DEFINE ETL_VERS_END_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, MONTH);
TITLE='ETL_VERS_END_DTM,Month', $
DEFINE ETL_VERS_END_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, DAY);
TITLE='ETL_VERS_END_DTM,Day', $
DEFINE ETL_VERS_END_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, YEAR);
TITLE='ETL_VERS_END_DTM,Y', $
DEFINE ETL_VERS_END_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, QUARTER);
TITLE='ETL_VERS_END_DTM,Y-Q', $
DEFINE ETL_VERS_END_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, MONTH);
TITLE='ETL_VERS_END_DTM,Y-M', $
DEFINE ETL_VERS_END_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, DAY);
TITLE='ETL_VERS_END_DTM,Y-M-D', $
DEFINE ETL_SNAPSHOT_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Year', $
DEFINE ETL_SNAPSHOT_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Quarter', $
DEFINE ETL_SNAPSHOT_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Month', $
DEFINE ETL_SNAPSHOT_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Day', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Y', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Y-Q', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Y-M', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Y-M-D', $
FOLDER=FLT_GL_ACCOUNT_DIM, PARENT=.,
DESCRIPTION='Filters and Variables', $
FOLDER=MG_GL_ACCOUNT_DIM, PARENT=.,
DV_ROLE=MEASURE,
DESCRIPTION='Measures', $
FOLDER=DIM_GL_ACCOUNT_DIM, PARENT=.,
DV_ROLE=DIMENSION,
DESCRIPTION='Dimensions', $
FOLDER=GL_HIERARCHY, PARENT=DIM_GL_ACCOUNT_DIM,
DESCRIPTION='GL Hierarchy', $
FOLDER=GL_HIERARCHY1, PARENT=GL_HIERARCHY,
DESCRIPTION='GL Hierarchy', $
FIELDNAME=FS_SORT_CD, BELONGS_TO_SEGMENT=GL_ACCOUNT_DIM,
DV_ROLE=LEVEL, $
FIELDNAME=FS_LINE_ITEM, BELONGS_TO_SEGMENT=GL_ACCOUNT_DIM,
DV_ROLE=LEVEL, $
FIELDNAME=GL_LDGR_NUM, BELONGS_TO_SEGMENT=GL_ACCOUNT_DIM,
DV_ROLE=LEVEL, $

Here is the txt for the A_RPT_GL_FINANCIALS.mas
FILENAME=A_RPT_GL_FINANCIALS, SUFFIX=SQLMSS , BV_NAMESPACE=OFF, $
SEGMENT=MST_RPT_FINANCIALS, SEGTYPE=S0,
DESCRIPTION='RPT FINANCIALS', $
FIELDNAME=GL_MTH_KEY, ALIAS=GL_MTH_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Month Key', $
FIELDNAME=GL_ACCT_KEY, ALIAS=GL_ACCT_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Acct Key', DESCRIPTION='Foreign Key for Dimension - GL', $
FIELDNAME=POSTED_DTE_KEY, ALIAS=POSTED_DTE_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='Posted Date Key', DESCRIPTION='Foreign Key for Dimension - POSTED DATE', $
FIELDNAME=GL_ACCT_DURABLE_KEY, ALIAS=GL_ACCT_DURABLE_KEY, USAGE=I11, ACTUAL=I4, FIELDTYPE=R,
TITLE='GL Acct Durable Key', DESCRIPTION='Foreign Key for Dimension - GL DURABLE', $
FIELDNAME=CR_MTD_AMT, ALIAS=CR_MTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='CR MTD Amount', DESCRIPTION='Monthly sum of credits posted to the GL for the month.', $
FIELDNAME=DB_MTD_AMT, ALIAS=DB_MTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='DB MTD Amount', DESCRIPTION='Monthly sum of debits posted to the GL for the month.', $
FIELDNAME=AVG_BAL_MTD_AMT, ALIAS=AVG_BAL_MTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='Avg Bal MTD Amount', DESCRIPTION='The average balance for the month for the GL.', $
FIELDNAME=CR_YTD_AMT, ALIAS=CR_YTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='CR YTD Amount', DESCRIPTION='Yearly sum of credits posted to the GL for the year.', $
FIELDNAME=DB_YTD_AMT, ALIAS=DB_YTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='DB YTD Amount', DESCRIPTION='Yearly sum of debits posted to the GL for the year.', $
FIELDNAME=AVG_BAL_YTD_AMT, ALIAS=AVG_BAL_YTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='AVG Bal YTD Amount', DESCRIPTION='The average balance year to date on a GL.', $
FIELDNAME=BUD_MTD_AMT, ALIAS=BUD_MTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='BUD MTD Amount', DESCRIPTION='Current months budgeted amount per Budget file maintained from accounting.', $
FIELDNAME=BUD_YTD_AMT, ALIAS=BUD_YTD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='BUD YTD Amount', DESCRIPTION='YTD budgeted amount per Budget File maintained from accounting.', $
FIELDNAME=EOM_BAL_AMT, ALIAS=EOM_BAL_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='EOM Bal Amount', DESCRIPTION='PHX GL End of Month Balance.', $
FIELDNAME=CUR_EOY_BUD_AMT, ALIAS=CUR_EOY_BUD_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='Current EOY BUD Amount', DESCRIPTION='Sums the YTD Budget for December and creates this field/amount.', $
FIELDNAME=PREV_EOM_BAL_AMT, ALIAS=PREV_EOM_BAL_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='Prev EOM BAL Amount', DESCRIPTION='The balance at the end of the month for the previous month.', $
FIELDNAME=EOM_CHG_AMT, ALIAS=EOM_CHG_AMT, USAGE=P16.2C, ACTUAL=P8, FIELDTYPE=R,
MISSING=ON,
TITLE='EOM CHG Amount', DESCRIPTION='The amount (credit or debit) that had changed on the account.', $
FIELDNAME=POSTED_DTE_CNT, ALIAS=posted_dte_cnt, USAGE=P20C, ACTUAL=P10, FIELDTYPE=R,
MISSING=ON,
TITLE='Posted DTE Count', $
SEGMENT=GL_DTE_MONTH, SEGTYPE=KU, PARENT=MST_RPT_FINANCIALS, CRFILE=DW_DATA/MST_DIM_DTE_MTH, CRSEGMENT=DATE_MONTH_DIM, CRINCLUDE=ALL, CRJOINTYPE=INNER,
JOIN_WHERE=GL_MTH_KEY EQ GL_DTE_MONTH.MTH_KEY;,
DESCRIPTION='GL DATE MONTH - Describes standard ways to group month for reporting', $
DEFINE ETL_SNAPSHOT_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Year', $
DEFINE ETL_SNAPSHOT_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Quarter', $
DEFINE ETL_SNAPSHOT_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Month', $
DEFINE ETL_SNAPSHOT_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Day', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Y', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Y-Q', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Y-M', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Y-M-D', $
SEGMENT=GL_ACCOUNT, SEGTYPE=KU, PARENT=MST_RPT_FINANCIALS, CRFILE=DW_DATA/MST_DIM_GL_ACCT, CRSEGMENT=GL_ACCOUNT_DIM, CRINCLUDE=ALL, CRJOINTYPE=INNER,
JOIN_WHERE=MST_RPT_FINANCIALS.GL_ACCT_DURABLE_KEY EQ GL_ACCOUNT.GL_ACCT_DURABLE_KEY;,
DESCRIPTION='GENERAL LEDGER - Provides descriptions for the General Ledger Accounts used for financial reporting.', $
DEFINE ETL_VERS_START_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, YEAR);
TITLE='ETL_VERS_START_DTM,Year', $
DEFINE ETL_VERS_START_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, QUARTER);
TITLE='ETL_VERS_START_DTM,Quarter', $
DEFINE ETL_VERS_START_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, MONTH);
TITLE='ETL_VERS_START_DTM,Month', $
DEFINE ETL_VERS_START_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_VERS_START_DTM, DAY);
TITLE='ETL_VERS_START_DTM,Day', $
DEFINE ETL_VERS_START_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, YEAR);
TITLE='ETL_VERS_START_DTM,Y', $
DEFINE ETL_VERS_START_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, QUARTER);
TITLE='ETL_VERS_START_DTM,Y-Q', $
DEFINE ETL_VERS_START_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, MONTH);
TITLE='ETL_VERS_START_DTM,Y-M', $
DEFINE ETL_VERS_START_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_VERS_START_DTM, DAY);
TITLE='ETL_VERS_START_DTM,Y-M-D', $
DEFINE ETL_VERS_END_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, YEAR);
TITLE='ETL_VERS_END_DTM,Year', $
DEFINE ETL_VERS_END_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, QUARTER);
TITLE='ETL_VERS_END_DTM,Quarter', $
DEFINE ETL_VERS_END_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, MONTH);
TITLE='ETL_VERS_END_DTM,Month', $
DEFINE ETL_VERS_END_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_VERS_END_DTM, DAY);
TITLE='ETL_VERS_END_DTM,Day', $
DEFINE ETL_VERS_END_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, YEAR);
TITLE='ETL_VERS_END_DTM,Y', $
DEFINE ETL_VERS_END_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, QUARTER);
TITLE='ETL_VERS_END_DTM,Y-Q', $
DEFINE ETL_VERS_END_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, MONTH);
TITLE='ETL_VERS_END_DTM,Y-M', $
DEFINE ETL_VERS_END_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_VERS_END_DTM, DAY);
TITLE='ETL_VERS_END_DTM,Y-M-D', $
DEFINE ETL_SNAPSHOT_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Year', $
DEFINE ETL_SNAPSHOT_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Quarter', $
DEFINE ETL_SNAPSHOT_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Month', $
DEFINE ETL_SNAPSHOT_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Day', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Y', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Y-Q', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Y-M', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Y-M-D', $
SEGMENT=POSTED_DATE, SEGTYPE=KU, PARENT=MST_RPT_FINANCIALS, CRFILE=DW_DATA/MST_DIM_DTE, CRSEGMENT=DATE_DIM, CRINCLUDE=ALL, CRJOINTYPE=INNER,
JOIN_WHERE=POSTED_DTE_KEY EQ DTE_KEY;,
DESCRIPTION='POSTED DATE - Describes standard ways to group dates for reporting', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_YEAR/I4=DTPART(CAL_WK_ENDING_SUNDAY_DTE, YEAR);
TITLE='Calendar Week Ending Sunday Date,Year', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_QUARTER/I1=DTPART(CAL_WK_ENDING_SUNDAY_DTE, QUARTER);
TITLE='Calendar Week Ending Sunday Date,Quarter', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_MONTH/I2=DTPART(CAL_WK_ENDING_SUNDAY_DTE, MONTH);
TITLE='Calendar Week Ending Sunday Date,Month', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_DAY/I2=DTPART(CAL_WK_ENDING_SUNDAY_DTE, DAY);
TITLE='Calendar Week Ending Sunday Date,Day', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_YEAR_Y/YYMDy=DTRUNC(CAL_WK_ENDING_SUNDAY_DTE, YEAR);
TITLE='Calendar Week Ending Sunday Date,Y', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_YEAR_Q/MDYYq=DTRUNC(CAL_WK_ENDING_SUNDAY_DTE, QUARTER);
TITLE='Calendar Week Ending Sunday Date,Y-Q', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_YEAR_M/MDYYm=DTRUNC(CAL_WK_ENDING_SUNDAY_DTE, MONTH);
TITLE='Calendar Week Ending Sunday Date,Y-M', $
DEFINE CAL_WK_ENDING_SUNDAY_DTE_YEAR_D/MDYY=DTRUNC(CAL_WK_ENDING_SUNDAY_DTE, DAY);
TITLE='Calendar Week Ending Sunday Date,M-D-Y', $
DEFINE DTE_YEAR/I4=DTPART(DTE, YEAR);
TITLE='Date,Year', $
DEFINE DTE_QUARTER/I1=DTPART(DTE, QUARTER);
TITLE='Date,Quarter', $
DEFINE DTE_DAY/I2=DTPART(DTE, DAY);
TITLE='Date,Day', $
DEFINE DTE_YEAR_Y/YYMDy=DTRUNC(DTE, YEAR);
TITLE='Date,Y', $
DEFINE DTE_YEAR_Q/MDYYq=DTRUNC(DTE, QUARTER);
TITLE='Date,Y-Q', $
DEFINE DTE_YEAR_M/MDYYm=DTRUNC(DTE, MONTH);
TITLE='Date,Y-M', $
DEFINE DTE_YEAR_D/MDYY=DTRUNC(DTE, DAY);
TITLE='Date,M-D-Y', $
DEFINE CURR_MTH_FIRST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(CURR_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Current Month First Day,Year', $
DEFINE CURR_MTH_FIRST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(CURR_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Current Month First Day,Quarter', $
DEFINE CURR_MTH_FIRST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(CURR_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Current Month First Day,Month', $
DEFINE CURR_MTH_FIRST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(CURR_MTH_FIRST_DAY_DTE, DAY);
TITLE='Current Month First Day,Day', $
DEFINE CURR_MTH_FIRST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(CURR_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Current Month First Day,Y', $
DEFINE CURR_MTH_FIRST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(CURR_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Current Month First Day,Y-Q', $
DEFINE CURR_MTH_FIRST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(CURR_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Current Month First Day,Y-M', $
DEFINE CURR_MTH_FIRST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(CURR_MTH_FIRST_DAY_DTE, DAY);
TITLE='Current Month First Day,M-D-Y', $
DEFINE CURR_MTH_LAST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(CURR_MTH_LAST_DAY_DTE, YEAR);
TITLE='Current Month Last Day,Year', $
DEFINE CURR_MTH_LAST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(CURR_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Current Month Last Day,Quarter', $
DEFINE CURR_MTH_LAST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(CURR_MTH_LAST_DAY_DTE, MONTH);
TITLE='Current Month Last Day,Month', $
DEFINE CURR_MTH_LAST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(CURR_MTH_LAST_DAY_DTE, DAY);
TITLE='Current Month Last Day,Day', $
DEFINE CURR_MTH_LAST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(CURR_MTH_LAST_DAY_DTE, YEAR);
TITLE='Current Month Last Day,Y', $
DEFINE CURR_MTH_LAST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(CURR_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Current Month Last Day,Y-Q', $
DEFINE CURR_MTH_LAST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(CURR_MTH_LAST_DAY_DTE, MONTH);
TITLE='Current Month Last Day,Y-M', $
DEFINE CURR_MTH_LAST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(CURR_MTH_LAST_DAY_DTE, DAY);
TITLE='Current Month Last Day,M-D-Y', $
DEFINE PREV_MTH_FIRST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(PREV_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Previous Month First Day,Year', $
DEFINE PREV_MTH_FIRST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(PREV_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Previous Month First Day,Quarter', $
DEFINE PREV_MTH_FIRST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(PREV_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Previous Month First Day,Month', $
DEFINE PREV_MTH_FIRST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(PREV_MTH_FIRST_DAY_DTE, DAY);
TITLE='Previous Month First Day,Day', $
DEFINE PREV_MTH_FIRST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(PREV_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Previous Month First Day,Y', $
DEFINE PREV_MTH_FIRST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(PREV_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Previous Month First Day,Y-Q', $
DEFINE PREV_MTH_FIRST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(PREV_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Previous Month First Day,Y-M', $
DEFINE PREV_MTH_FIRST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(PREV_MTH_FIRST_DAY_DTE, DAY);
TITLE='Previous Month First Day,M-D-Y', $
DEFINE PREV_MTH_LAST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(PREV_MTH_LAST_DAY_DTE, YEAR);
TITLE='Previous Month Last Day,Year', $
DEFINE PREV_MTH_LAST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(PREV_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Previous Month Last Day,Quarter', $
DEFINE PREV_MTH_LAST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(PREV_MTH_LAST_DAY_DTE, MONTH);
TITLE='Previous Month Last Day,Month', $
DEFINE PREV_MTH_LAST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(PREV_MTH_LAST_DAY_DTE, DAY);
TITLE='Previous Month Last Day,Day', $
DEFINE PREV_MTH_LAST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(PREV_MTH_LAST_DAY_DTE, YEAR);
TITLE='Previous Month Last Day,Y', $
DEFINE PREV_MTH_LAST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(PREV_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Previous Month Last Day,Y-Q', $
DEFINE PREV_MTH_LAST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(PREV_MTH_LAST_DAY_DTE, MONTH);
TITLE='Previous Month Last Day,Y-M', $
DEFINE PREV_MTH_LAST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(PREV_MTH_LAST_DAY_DTE, DAY);
TITLE='Previous Month Last Day,M-D-Y', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(SECOND_PREV_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Second Previous Month First Day,Year', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(SECOND_PREV_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Second Previous Month First Day,Quarter', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(SECOND_PREV_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Second Previous Month First Day,Month', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(SECOND_PREV_MTH_FIRST_DAY_DTE, DAY);
TITLE='Second Previous Month First Day,Day', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_FIRST_DAY_DTE, YEAR);
TITLE='Second Previous Month First Day,Y', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_FIRST_DAY_DTE, QUARTER);
TITLE='Second Previous Month First Day,Y-Q', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_FIRST_DAY_DTE, MONTH);
TITLE='Second Previous Month First Day,Y-M', $
DEFINE SECOND_PREV_MTH_FIRST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_FIRST_DAY_DTE, DAY);
TITLE='Second Previous Month First Day,M-D-Y', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(SECOND_PREV_MTH_LAST_DAY_DTE, YEAR);
TITLE='Second Previous Month Last Day,Year', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(SECOND_PREV_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Second Previous Month Last Day,Quarter', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(SECOND_PREV_MTH_LAST_DAY_DTE, MONTH);
TITLE='Second Previous Month Last Day,Month', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(SECOND_PREV_MTH_LAST_DAY_DTE, DAY);
TITLE='Second Previous Month Last Day,Day', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_LAST_DAY_DTE, YEAR);
TITLE='Second Previous Month Last Day,Y', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_LAST_DAY_DTE, QUARTER);
TITLE='Second Previous Month Last Day,Y-Q', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_LAST_DAY_DTE, MONTH);
TITLE='Second Previous Month Last Day,Y-M', $
DEFINE SECOND_PREV_MTH_LAST_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(SECOND_PREV_MTH_LAST_DAY_DTE, DAY);
TITLE='Second Previous Month Last Day,M-D-Y', $
DEFINE PREV_BUS_DAY_DTE_YEAR/I4 MISSING ON ALL=DTPART(PREV_BUS_DAY_DTE, YEAR);
TITLE='Previous Business Day,Year', $
DEFINE PREV_BUS_DAY_DTE_QUARTER/I1 MISSING ON ALL=DTPART(PREV_BUS_DAY_DTE, QUARTER);
TITLE='Previous Business Day,Quarter', $
DEFINE PREV_BUS_DAY_DTE_MONTH/I2 MISSING ON ALL=DTPART(PREV_BUS_DAY_DTE, MONTH);
TITLE='Previous Business Day,Month', $
DEFINE PREV_BUS_DAY_DTE_DAY/I2 MISSING ON ALL=DTPART(PREV_BUS_DAY_DTE, DAY);
TITLE='Previous Business Day,Day', $
DEFINE PREV_BUS_DAY_DTE_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(PREV_BUS_DAY_DTE, YEAR);
TITLE='Previous Business Day,Y', $
DEFINE PREV_BUS_DAY_DTE_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(PREV_BUS_DAY_DTE, QUARTER);
TITLE='Previous Business Day,Y-Q', $
DEFINE PREV_BUS_DAY_DTE_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(PREV_BUS_DAY_DTE, MONTH);
TITLE='Previous Business Day,Y-M', $
DEFINE PREV_BUS_DAY_DTE_YEAR_D/MDYY MISSING ON ALL=DTRUNC(PREV_BUS_DAY_DTE, DAY);
TITLE='Previous Business Day,M-D-Y', $
DEFINE ETL_SNAPSHOT_DTM_YEAR/I4 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Year', $
DEFINE ETL_SNAPSHOT_DTM_QUARTER/I1 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Quarter', $
DEFINE ETL_SNAPSHOT_DTM_MONTH/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Month', $
DEFINE ETL_SNAPSHOT_DTM_DAY/I2 MISSING ON ALL=DTPART(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Day', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Y/YYMDy MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, YEAR);
TITLE='ETL_SNAPSHOT_DTM,Y', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_Q/MDYYq MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, QUARTER);
TITLE='ETL_SNAPSHOT_DTM,Y-Q', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_M/MDYYm MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, MONTH);
TITLE='ETL_SNAPSHOT_DTM,Y-M', $
DEFINE ETL_SNAPSHOT_DTM_YEAR_D/MDYY MISSING ON ALL=DTRUNC(ETL_SNAPSHOT_DTM, DAY);
TITLE='ETL_SNAPSHOT_DTM,Y-M-D', $
FOLDER=FLT_MST_RPT_FINANCIALS, PARENT=.,
DESCRIPTION='Filters and Variables', $
FOLDER=MG_MST_RPT_FINANCIALS, PARENT=.,
DV_ROLE=MEASURE,
DESCRIPTION='Measures', $
FOLDER=DIM_MST_RPT_FINANCIALS, PARENT=.,
DV_ROLE=DIMENSION,
DESCRIPTION='Dimensions', $
FOLDER=GL, PARENT=DIM_MST_RPT_FINANCIALS,
DESCRIPTION='GL', $
FOLDER=GL_HIERARCHY, PARENT=GL,
DESCRIPTION='GL Hierarchy', $
FIELDNAME=FS_SORT_CD, BELONGS_TO_SEGMENT=GL_ACCOUNT,
DV_ROLE=LEVEL, $
FIELDNAME=FS_LINE_ITEM, BELONGS_TO_SEGMENT=GL_ACCOUNT,
DV_ROLE=LEVEL, $
FIELDNAME=GL_LDGR_NUM, BELONGS_TO_SEGMENT=GL_ACCOUNT,
DV_ROLE=LEVEL, $

When using a compare software for the two similar pieces, it looks like everything is in the active synonym that should be, and it all ties to the master dimension. The only difference is that in the active synonym, it doesn't have all the field names and descriptions, but has all the defines. That seems to be the way of all the active synonyms however. Right?

Let me know if you see anything, I'll also load a case and if they get back to me, I'll post their findings within this post.


Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
 
Posts: 63 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016Report This Post
Virtuoso
posted Hide Post
Larissa

Sorry it took me a while to get back to this. I don't see anything wrong as well. Hopefully techsupport will get to the bottom of if.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
Did you ever get an answer on this one?
Seeing the same sort of thing after changing DV_INCLUDE to NO.

Thanks,
Ken Kerns


WebFocus / DataMigrator 8105M
 
Posts: 4 | Registered: October 17, 2016Report This Post
Virtuoso
posted Hide Post
Ken

Here is the link to Larissa's case. https://techsupport.informatio...track/171120057.html


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
The link for Larissa's case, posted by Chuck, would not open for me. We are having a similar issue. Could you tell me what worked in this case or tell me how I can view her case?
 
Posts: 6 | Registered: June 16, 2015Report This Post
Virtuoso
posted Hide Post
You need to have an account with IB tech support associated with a site code. You can create the account yourself as long as you have the site code.


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
Gold member
posted Hide Post
Hi devr,
I went through all my case notes on this one and my final solution to fixing this, was to delete the active synonym and recreate it.

I was getting the error on a procedure that ran fine in our test environment, but not on our prod environment. After following the line by line code of seeing how things were referenced to the data fields, I noticed that one of our joined dimensions was named differently on the production side, than the test side.
Example:
TEST: A_ACCT_ALL_DLY.DATE_EFFECTIVE.DTE
PROD: A_ACCT_ALL_DLY.DTE_EFFECTIVE.DTE
So once the procedure was run on PROD, it was looking for DATE_EFFECTIVE.DTE and that exact join didn't exist.
I also noticed with the upgrade from 8105M to 8201, you cannot have two date dimensions mapped into a join with the same segment name. We have a bunch of date keys, but we had to go in and change the segment name from dim_dte on both joins to dim_dte_effective and dim_dte_posted (or whatever the specific date key was determining for the join)
Hope that helped!


Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
 
Posts: 63 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016Report 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] FOC32686 - Dimension view definition conflict in cluster and base master

Copyright © 1996-2020 Information Builders