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] 2 Dimension Tables - [NAME] column in both

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] 2 Dimension Tables - [NAME] column in both
 Login/Join
 
Platinum Member
posted
I'm having an issue where I'm joining a fact table - to a Vehicle dimension - and a Driver dimension table. (PostgreSQL).

The joins are pretty trivial

JOIN
INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.VEHICLE_DIMENSION IN
telogis_trip_fact TO UNIQUE TELOGIS_VEHICLE.TELOGIS_VEHICLE.ID
IN telogis_vehicle TAG J0 AS J0
END
JOIN
INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DRIVER_DIMENSION IN telogis_trip_fact
TO UNIQUE TELOGIS_DRIVER.TELOGIS_DRIVER.ID IN telogis_driver TAG J1 AS J1
END 


I'm running into an issue where BOTH the Driver and Vehicle dimension have a column called "Name".

When I'm pulling the data, I'm aliasing the Name column so we can tell them apart in the report:

     J0.TELOGIS_VEHICLE.NAME AS 'Vehicle'
     J1.TELOGIS_DRIVER.NAME AS 'Driver'	


Sadly - I get an error. (Error in webFOCUS is deceptive - checking the SQL generated and running that - the true error appeared)

It does not seem like webFOUCS passes the alias to the database - and the error coming back from the cloud database is:

ERROR: {"error":"SQL compilation error:duplicate column name 'NAME'"} SQL state: 42601

Is there some SET command that will help the database to acknowledge my alias. I know I'm pulling back 2 name columns....but they are from different Dimensions - and I'd like them both returned.

I'll need to join to some other Location/Address Dimensions that also have a NAME column too...so ultimately - I may need 4 different "NAME" fields in my report.

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


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report This Post
Expert
posted Hide Post
This is not my favorite solution/Work-Around. But... You can change the name of the NAME fields in each of the tables and HOLD them, after specified filtering is done, then JOIN those 'held' tables... That should get the job done... Not elegant... But done...

Or, change the synonym to account for the FIELDNAME / ALIAS and work from there...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Master
posted Hide Post
Can you post the output of the SQL trace?

 
-SET &ECHO = ALL;
SET TRACEUSER = ON
SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACESTAMP = OFF
SET XRETRIEVAL = OFF
 


Hallway

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
 
Posts: 608 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Report This Post
Platinum Member
posted Hide Post
Trace Results
Detail:
 SET TRACEUSER = ON
 SET TRACEOFF = ALL
 SET TRACEON = SQLAGGR//CLIENT
 SET TRACEON = STMTRACE//CLIENT
 SET TRACEON = STMTRACE/2/CLIENT
 SET TRACESTAMP = OFF
 SET XRETRIEVAL = OFF
 JOIN
 INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.VEHICLE_DIMENSION IN
 telogis_trip_fact TO UNIQUE TELOGIS_VEHICLE.TELOGIS_VEHICLE.ID
 IN telogis_vehicle TAG J0 AS J0
 END
 JOIN
 INNER TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DRIVER_DIMENSION IN telogis_trip_fact
 TO UNIQUE TELOGIS_DRIVER.TELOGIS_DRIVER.ID IN telogis_driver TAG J1 AS J1
 END
 DEFINE FILE TELOGIS_TRIP_FACT
 filterDate/YYMD=HDATE(TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC, 'YYMD');
 myTime/D12.2=HTIME(10, TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC, 'D12.2');
 driverName/A256V=J1.TELOGIS_DRIVER.FIRST_NAME | ' ' | J1.TELOGIS_DRIVER.LAST_NAME ;
 tripCounter/I5 = IF TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DEPARTURE_TIME_UNIT_TZ IS MISSING  THEN tripCounter ELSE tripCounter+1;
 END
 TABLE FILE TELOGIS_TRIP_FACT
 PRINT
 J0.TELOGIS_VEHICLE.NAME AS 'Vehicle'
 driverName AS 'Driver'
 J1.TELOGIS_DRIVER.NAME AS 'Driver 2'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC/MDY AS 'Date'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC/HHIA AS 'Depart Time'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_TIME AS 'End Time Raw'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_TIME/HHIA AS 'End Time'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.IGNITION_ON_TIME_UNIT_TZ
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DEPARTURE_TIME_UNIT_TZ
 tripCounter
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.IGNITION_OFF_TIME_UNIT_TZ
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ARRIVAL_TIME_UNIT_TZ
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ARRIVAL_TIME_UNIT_TZ/HHIA AS 'Arrival Time'
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.ENGINE_TIME
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.TOTAL_DISTANCE
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.TRIP_DURATION
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.END_ODO
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.PREIDLE_DURATION
 TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.POSTIDLE_DURATION
 BY  TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.START_TIME_UTC NOPRINT
 WHERE TELOGIS_TRIP_FACT.TELOGIS_TRIP_FACT.DRIVER_DIMENSION EQ 54810602259;
 WHERE filterDate EQ '20190516';
 WHERE myTime NE '.00';
 ON TABLE SET PAGE-NUM NOLEAD
 ON TABLE SET ASNAMES ON
 ON TABLE NOTOTAL
 ON TABLE PCHOLD FORMAT HTML
 ON TABLE SET HTMLEMBEDIMG ON
 ON TABLE SET HTMLCSS ON
 ON TABLE SET STYLE *
 -INCLUDE _EDAHOME/ETC/warm.sty
 $ Copyright 1996-2015 Information Builders, Inc. All rights reserved.
 -*  $Revision: 1.33 $
 *TABLE_STYLE
 TYPE=REPORT,
 GRID=OFF,
 FONT='IBIDefault',
 SIZE=9,
 STYLE=NORMAL,
 SQUEEZE=ON,
 COLOR=RGB(20 20 20),
 PAGECOLOR='WHITE',
 BORDER-COLOR=RGB(219 219 219),
 TITLELINE=SKIP,
 HYPERLINK-COLOR=RGB(51 102 255),
 $
 TYPE=REPORT,GRAPHCOLOR='SILVER',GRAPHCOLORNEG='RED',GRAPHWIDTH=.18,$
 TYPE=REPORT,
 OBJECT=MENU,
 SIZE=9,
 COLOR=RGB(#6B6B6B),
 BACKCOLOR=RGB(#F8F8F8),
 HOVER-COLOR=RGB(#495263),
 HOVER-BACKCOLOR=RGB(#DFDFDF),
 $
 TYPE=DATA,
 TOPGAP=0.05,
 BOTTOMGAP=0.05,
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(219 219 219),
 BORDER-BOTTOM=LIGHT,
 BORDER-BOTTOM-COLOR=RGB(219 219 219),
 $
 TYPE=TITLE,
 STYLE=-UNDERLINE + BOLD,
 BORDER-BOTTOM=LIGHT,
 BORDER-BOTTOM-COLOR=RGB(219 219 219),
 $
 TYPE=DATA,
 COLUMN=ROWTOTAL(*),
 STYLE=BOLD,
 $
 TYPE=TITLE,
 COLUMN=ROWTOTAL(*),
 STYLE=-UNDERLINE +BOLD,
 $
 TYPE=TABHEADING,
 SIZE=14,
 JUSTIFY=LEFT,
 STYLE=BOLD,
 COLOR=RGB(75 75 75),
 $
 TYPE=TABFOOTING,
 SIZE=10,
 COLOR=RGB(75 75 75),
 $
 TYPE=HEADING,
 JUSTIFY=LEFT,
 SIZE=12,
 STYLE=BOLD,
 COLOR=RGB(75 75 75),
 $
 TYPE=FOOTING,
 SIZE=10,
 COLOR=RGB(75 75 75),
 $
 TYPE=SUBHEAD,
 BACKCOLOR=RGB(246 246 246),
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(219 219 219),
 $
 TYPE=SUBHEAD,
 BY=1,
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(102 102 102),
 $
 TYPE=SUBHEAD,
 OBJECT=FIELD,
 STYLE=BOLD,
 $
 TYPE=SUBFOOT,
 SIZE=9,
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(219 219 219),
 $
 TYPE=SUBFOOT,
 OBJECT=FIELD,
 STYLE=BOLD,
 $
 TYPE=SUBTOTAL,
 STYLE=BOLD,
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(219 219 219),
 $
 TYPE=ACROSSVALUE,
 BACKCOLOR='NONE',
 STYLE=NORMAL,
 JUSTIFY=CENTER,
 $
 TYPE=ACROSSTITLE,
 ACROSSTITLE=SIDE,
 STYLE=BOLD,
 $
 TYPE=GRANDTOTAL,
 STYLE=BOLD,
 BORDER-TOP=LIGHT,
 BORDER-TOP-COLOR=RGB(102 102 102),
 $
 -*ACTIVE Specific
 TYPE=REPORT,OBJECT=CURRENT-ROW,HOVER-BACKCOLOR=rgb(243 243 243), BACKCOLOR=rgb(215 215 215),$
 TYPE=REPORT, CALC-LOCATION=TOP, $
 TYPE=REPORT, ARICONSET=BLUE, ARSTYLESET=bipib,$
 TYPE=REPORT, OBJECT=CALC-AREA, COLOR=RGB(0 0 0), $
 TYPE=REPORT, OBJECT=STATUS-AREA, COLOR=RGB(51 51 51), BACKCOLOR=RGB(255 255 255), JUSTIFY=LEFT, PAGE-LOCATION=BOTTOM,$
 TYPE=REPORT,ARGRAPHENGINE=JSCHART,$
 *GRAPH_SCRIPT
 setFillColor(getSeries(0),new Color(#5388be));
 setFillColor(getSeries(1),new Color(#9ed675));
 setFillColor(getSeries(2),new Color(#4fa03d));
 setFillColor(getSeries(3),new Color(#fcce58));
 setFillColor(getSeries(4),new Color(#e1542b));
 setFillColor(getSeries(5),new Color(#efcca2));
 setSeriesLooping(6);
 setColorMode(4);
 setAutoColorLerpFactor(0.8);
 setTransparentBorderColor(getChartBackground(),true);
 setTransparentBorderColor(getSeries(*), true);
 setTransparentBorderColor(getFrame(),true);
 setTransparentBorderColor(getSeries(0),true);
 setTransparentBorderColor(getSeries(1),true);
 setTransparentBorderColor(getSeries(2),true);
 setTransparentBorderColor(getSeries(3),true);
 setTransparentBorderColor(getSeries(4),true);
 setTransparentBorderColor(getSeries(5),true);
 setTransparentBorderColor(getSeries(6),true);
 setTransparentBorderColor(getSeries(7),true);
 setTransparentBorderColor(getSeries(8),true);
 setTransparentBorderColor(getSeries(9),true);
 setTransparentBorderColor(getSeries(10),true);
 setTransparentBorderColor(getSeries(11),true);
 setTransparentBorderColor(getSeries(12),true);
 setTransparentBorderColor(getSeries(13),true);
 setTransparentBorderColor(getSeries(14),true);
 setTransparentBorderColor(getSeries(15),true);
 setTransparentBorderColor(getSeries(16),true);
 setTransparentBorderColor(getSeries(17),true);
 setX1MajorTickDisplay (true);
 setTickLength (getX1MajorTick(), 200);
 setBorderColor(getX1MajorTick(),new Color(192,192,192));
 setTickStyle(getX1MajorTick(),3);
 setLegendPosition(2);
 setSmoothLines(false);
 setFillColor(getO1Label(),new Color(128,128,128));
 setDisplay(getO1MajorGrid(),false);
 setBorderColor(getO1MajorGrid(),new Color(128,128,128));
 setFillColor(getO1MajorGrid(),new Color(128,128,128));
 setAltFmtFrameNumColors(getO1AltFmtFrame(),5);
 setFontName(getO1Title(),"IBIDefault");
 setFontSizeAbsolute(getO1Title(), true);
 setFontSizeInPoints(getO1Title(), 10);
 setPlaceResize(getO1Title(), 0);
 setFillColor(getO1Title(),new Color(128,128,128));
 setTickLength (getY1MajorTick(), 200);
 setBorderColor(getY1AxisLine(),new Color(192,192,192));
 setFillColor(getY1AxisLine(),new Color(192,192,192));
 setLineWidth(getY1AxisLine(),1);
 setDisplay(getY1ZeroLine(),true);
 setBorderColor(getY1ZeroLine(),new Color(192,192,192));
 setLineWidth(getY1ZeroLine(),1);
 setFillColor(getY1Label(),new Color(128,128,128));
 setBorderColor(getY1MajorGrid(),new Color(128,128,128));
 setFillColor(getY1MajorGrid(),new Color(128,128,128));
 setAltFmtFrameNumColors(getY1AltFmtFrame(),5);
 setScaleMustIncludeZero(getY1Axis(),true);
 setFontSizeAbsolute(getY1Title(), true);
 setFontSizeInPoints(getY1Title(), 10);
 setPlaceResize(getY1Title(), 0);
 setFillColor(getY1Title(),new Color(128,128,128));
 setFontName(getY1Title(),"IBIDefault");
 setFontName(getY1Label(),"IBIDefault");
 setFontSizeAbsolute(getY1Label(), true);
 setFontSizeInPoints(getY1Label(), 9);
 setPlaceResize(getY1Label(), 0);
 setBorderColor(getY1MajorTick(),new Color(192,192,192));
 setDisplay(getY1MajorTick(),true);
 setTickStyle(getY1MajorTick(),3);
 setDisplay(getY1MajorGrid(),false);
 setFontName(getX1Title(),"IBIDefault");
 setFontSizeAbsolute(getX1Title(), true);
 setFontSizeInPoints(getX1Title(), 10);
 setPlaceResize(getX1Title(), 0);
 setFillColor(getX1Title(),new Color(128,128,128));
 setTickLength (getY2MajorTick(), 200);
 setBorderColor(getY2AxisLine(),new Color(88,88,88));
 setFillColor(getY2AxisLine(),new Color(88,88,88));
 setLineWidth(getY2AxisLine(),1);
 setDisplay(getY2ZeroLine(),true);
 setBorderColor(getY2ZeroLine(),new Color(88,88,88));
 setLineWidth(getY2ZeroLine(),1);
 setFillColor(getY2Label(),new Color(64,64,64));
 setBorderColor(getY2MajorGrid(),new Color(64,64,64));
 setFillColor(getY2MajorGrid(),new Color(64,64,64));
 setAltFmtFrameNumColors(getY2AltFmtFrame(),5);
 setScaleMustIncludeZero(getY2Axis(),true);
 setFontSizeAbsolute(getY2Title(), true);
 setFontSizeInPoints(getY2Title(), 10);
 setPlaceResize(getY2Title(), 0);
 setFillColor(getY2Title(),new Color(64,64,64));
 setFontName(getY2Title(),"IBIDefault");
 setFontName(getY2Label(),"IBIDefault");
 setFontSizeAbsolute(getY2Label(), true);
 setFontSizeInPoints(getY2Label(), 9);
 setPlaceResize(getY2Label(), 0);
 setBorderColor(getY2MajorTick(),new Color(88,88,88));
 setDisplay(getY2MajorTick(),true);
 setTickStyle(getY2MajorTick(),3);
 setDisplay(getY2MajorGrid(),false);
 setFontName(getX1Title(),"IBIDefault");
 setFontSizeAbsolute(getX1Title(), true);
 setFontSizeInPoints(getX1Title(), 10);
 setPlaceResize(getX1Title(), 0);
 setFillColor(getX1Title(),new Color(128,128,128));
 setFontName(getO1Label(),"IBIDefault");
 setFontSizeAbsolute(getO1Label(), true);
 setFontSizeInPoints(getO1Label(), 9);
 setPlaceResize(getO1Label(), 0);
 setFontName(getLegendText(),"IBIDefault");
 setFillColor(getLegendText(),new Color(80,80,80));
 setSquareMarkers(true);
 setUseSeriesShapes(true);
 setMarkerShape(getSeries(*),0);
 setPieFeelerTextDisplay(0);
 setFontName(getPieRingLabel(),"IBIDefault");
 setFontSizeAbsolute(getPieRingLabel(),true);
 setAutofit(getPieRingLabel(),false);
 setFontSizeInPoints(getPieRingLabel(),28);
 setPlaceResize(getPieRingLabel(),0);
 setDisplay(getX1MajorGrid(),false);
 setBorderColor(getO1AxisLine(),new Color(192,192,192));
 setLineWidth(getO1AxisLine(),1);
 setBorderColor(getX1AxisLine(),new Color(192,192,192));
 setLineWidth(getX1AxisLine(),1);
 setScaleMustIncludeZero(getX1Axis(),true);
 setBorderColor(getO1MajorTick(),new Color(192,192,192));
 setDisplay(getO1MajorTick(),false);
 setTickStyle(getO1MajorTick(),3);
 setTransparentFillColor(getFrame(),true);
 setPieRingSize(64);
 setDisplay(getQuadrantLine(),false);
 setFillColor(getX1Label(),new Color(128,128,128));
 setFontName(getX1Label(),"IBIDefault");
 setFontSizeAbsolute(getX1Label(), true);
 setFontSizeInPoints(getX1Label(), 9);
 setPlaceResize(getX1Label(), 0);
 setPlaceTruncateCount(getLegendText(), 15);
 setZeroValueDataTextDisplay(false);
 *GRAPH_JS
 "fill": {
 "color": "transparent"
 },
 "border": {
 "width": 1,
 "color": "transparent",
 "dash": ""
 },
 "blaProperties": {
 "areaFillEffect": "70%",
 "barGroupGapWidth": "0.4"
 },
 "bubbleMarker": {
 "maxSize": "11%"
 },
 "pieProperties": {
 "holeSize": 0,
 "totalLabel": {
 "visible": "auto",
 "font": "10pt Sans-Serif",
 "color": "#505050"
 }
 },
 "gaugeProperties": {
 "totalLabel": {
 "color": "#505050"
 },
 "secondaryRingFillColor": "#e5e5e5",
 "startAngle": 270,
 "endAngle": 270,
 "axisWidth": "25%",
 "outerBorder": {
 "fill": {
 "color": "transparent"
 },
 "width": "6%"
 }
 },
 "series": [
 {
 "series": "all",
 "dataLabels": {
 "visible": "auto",
 "font": "7.5pt Sans-Serif",
 "color": "auto"
 },
 "color": null,
 "border": {
 "width": 3
 },
 "marker": {
 "visible": false,
 "size": 10,
 "border": {
 "width": 2
 },
 "shape": "circle",
 "fillEffect": "seriesAuto"
 }
 },
 {
 "series": 0,
 "color": "#5388be"
 },
 {
 "series": 1,
 "color": "#9ed675"
 },
 {
 "series": 2,
 "color": "#4fa03d"
 },
 {
 "series": 3,
 "color": "#FCCE58"
 },
 {
 "series": 4,
 "color": "#e1542b"
 },
 {
 "series": 5,
 "color": "#efcca2"
 }
 ],
 "legend": {
 "visible": "auto",
 "lineStyle": {
 "width": 1,
 "color": "transparent"
 },
 "title": {
 "visible": false,
 "font": "10pt Sans-Serif",
 "color": "#505050"
 },
 "labels": {
 "font": "7.5pt Sans-Serif",
 "color": "#505050"
 },
 "shadow": false,
 "position": "auto",
 "backgroundcolor": "transparent",
 "scroll": {
 "enabled": true,
 "handle": {
 "color": "#D1D1D1",
 "hoverColor": "#B3B3B3"
 }
 },
 "dock": {
 "enabled": true,
 "button": {
 "color": "#D1D1D1",
 "hoverColor": "#B3B3B3"
 }
 }
 },
 "colorScale": {
 "title": {
 "text": "",
 "visible": true
 },
 "colors": [
 "#D73027",
 "#FDAE61",
 "#FFFFBF",
 "#A6D96A",
 "#1A9850"
 ],
 "labels": {
 "visible": true,
 "font": "7.5pt Sans-Serif",
 "color": "#505050"
 },
 "majorGrid": {
 "visible": true,
 "aboveRisers": true,
 "lineStyle": {
 "width": 1,
 "color": "rgba(255, 255, 255, 0.3)"
 },
 "ticks": {
 "length": 5,
 "visible": false,
 "style": "outer",
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 }
 },
 "xaxis": {
 "mustIncludeZero": true,
 "title": {
 "visible": true,
 "font": "10pt Sans-Serif",
 "color": "#505050"
 },
 "labels": {
 "visible": true,
 "font": "9pt Sans-Serif",
 "color": "#505050",
 "excludeMin": false,
 "nestingConcatSymbol": " : ",
 "rotation": null
 },
 "labelLayout": {
 "stagger": false,
 "skip": "auto",
 "scroll": "auto",
 "truncate": "auto"
 },
 "bodyLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "baseLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "majorGrid": {
 "visible": false,
 "aboveRisers": false,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "visible": false,
 "style": "inner",
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 },
 "minorGrid": {
 "visible": false,
 "count": null,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "visible": false,
 "style": "inner",
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 }
 },
 "yaxis": {
 "mustIncludeZero": true,
 "title": {
 "visible": true,
 "font": "10pt Sans-Serif",
 "color": "#505050"
 },
 "labels": {
 "visible": true,
 "font": "9pt Sans-Serif",
 "color": "#505050",
 "excludeMin": false,
 "rotation": null
 },
 "bodyLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "baseLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "minorGrid": {
 "visible": false,
 "count": null,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "style": "outer",
 "visible": false,
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 },
 "majorGrid": {
 "visible": false,
 "aboveRisers": false,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "visible": true,
 "style": "outer",
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 }
 },
 "y2axis": {
 "mustIncludeZero": true,
 "title": {
 "visible": true,
 "font": "10pt Sans-Serif",
 "color": "#505050"
 },
 "labels": {
 "visible": true,
 "font": "9pt Sans-Serif",
 "color": "#505050",
 "excludeMin": false,
 "rotation": null
 },
 "bodyLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "baseLineStyle": {
 "width": 1,
 "color": "#BABABA",
 "dash": ""
 },
 "minorGrid": {
 "visible": false,
 "count": null,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "style": "outer",
 "visible": false,
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 },
 "majorGrid": {
 "visible": false,
 "aboveRisers": false,
 "lineStyle": {
 "width": 1,
 "color": "#EEEEEE",
 "dash": ""
 },
 "ticks": {
 "length": 5,
 "visible": true,
 "style": "outer",
 "lineStyle": {
 "width": 1,
 "color": "#BABABA"
 }
 }
 }
 },
 "zaxis": {
 "title": {
 "text": "",
 "visible": true,
 "font": "10pt Sans-Serif",
 "color": "#505050"
 },
 "labels": {
 "visible": true,
 "font": "9pt Sans-Serif",
 "color": "#505050",
 "excludeMin": false,
 "excludeMax": "auto",
 "rotation": null
 },
 "majorGrid": {
 "visible": false,
 "ticks": {
 "visible": false
 }
 }
 },
 "mouseOverIndicator": {
 "color": "transparent",
 "border": {
 "width": 2,
 "color": "#303030"
 },
 "marker": {
 "color": "rgba(255, 255, 0, 0.88)",
 "size": 8,
 "shape": "circle",
 "rotation": 0,
 "position": "top",
 "border": {
 "width": 0,
 "color": "rgba(26, 26, 26, 0.9)",
 "dash": ""
 }
 }
 },
 "matrixProperties": {
 "rowLabels": {
 "color": "#505050",
 "font": "8pt Sans-Serif"
 },
 "colLabels": {
 "color": "#505050",
 "font": "8pt Sans-Serif"
 },
 "rowHeader": {
 "color": "#505050",
 "font": "10pt Sans-Serif"
 },
 "colHeader": {
 "color": "#505050",
 "font": "10pt Sans-Serif"
 },
 "cellBorder": {
 "width": 1,
 "color": "#AAAAAA"
 }
 },
 "dataSelection": {
 "unselectedColor": "85%",
 "selectionRect": {
 "fill": "rgba(120, 120, 180, 0.45)",
 "border": {
 "width": 1,
 "color": "rgba(120, 120, 205, 0.8)"
 }
 }
 },
 "tagcloudProperties": {
 "engine": "new",
 "font": "14pt Sans-serif"
 },
 "morphAnimation": {
 "duration": 1000
 },
 "dataGridProperties": {
 "colHeader": {
 "sorting": {
 "enabled": true
 },
 "resize": {
 "enabled": true
 }
 }
 },
 "riserCycleEndLightness": 0.8,
 "riserBevel": "none",
 "showNullGroups": false,
 "narrativeText": {
 "label": {
 "font": "11pt Arial",
 "color": "#000000",
 "align": "left"
 },
 "backgroundColor": "#FFFFFF",
 "border": {
 "width": 0,
 "color": "#000000",
 "dash": ""
 }
 },
 "extensions": {
 "com.esri.map": {
 "baseLayer": {
 "basemap": "gray"
 }
 }
 }
 *END
 $
 ENDSTYLE
 END
 FOC2565 - THE OBJECT  OF IF/WHERE CANNOT BE CONVERTED TO SQL
 FOC2566 - DEFINE myTime CANNOT BE CONVERTED TO SQL
 FOC2567 - FUNCTION HTIME CANNOT BE CONVERTED TO SQL
 FOC2590 - AGGREGATION NOT DONE FOR THE FOLLOWING REASON:
 FOC2594 - AGGREGATION IS NOT APPLICABLE TO THE VERB USED
 SELECT
 T1."abs_count",
 T1."arrival_time_unit_tz",
 T1."departure_time_unit_tz",
 T1."driver_dimension",
 T1."end_odo",
 T1."end_time",
 T1."engine_time",
 T1."ignition_off_time_unit_tz",
 T1."ignition_on_time_unit_tz",
 T1."postidle_duration",
 T1."preidle_duration",
 T1."start_time_utc",
 T1."total_distance",
 T1."trip_duration",
 T1."vehicle_dimension",
 T2."name",
 T3."first_name",
 T3."last_name",
 T3."name"
 FROM
 zonesf31d.trip_fact T1,
 zonesf31d.vehicle T2,
 zonesf31d.driver T3
 WHERE
 (T2."id" = T1."vehicle_dimension") AND
 (T3."id" = T1."driver_dimension") AND
 (DATE_TRUNC('DAY',CAST(T1."start_time_utc" AS TIMESTAMP)) =
 DATE '2019-05-16') AND
 (T1."driver_dimension" = 54810602259)
 ORDER BY
 T1."start_time_utc";
 0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report This Post
Platinum Member
posted Hide Post
I will follow Doug's suggestion if needed. That will indeed work. I'm just hoping there's some magic set command that fixes my issue where I'm pulling T2.Name and T3.Name - that's what the database is unhappy about.


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report 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] 2 Dimension Tables - [NAME] column in both

Copyright © 1996-2020 Information Builders