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] 2 Dimension Tables - [NAME] column in both
Go
New
Search
Notify
Tools
Reply
  
[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 8203
WindowsServer 2012 R2,
Excel, PDF, HTML, ActiveReports
 
Posts: 124 | Location: Minnesota | Registered: August 26, 2013Reply With QuoteReport 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: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
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
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 431 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport 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 8203
WindowsServer 2012 R2,
Excel, PDF, HTML, ActiveReports
 
Posts: 124 | Location: Minnesota | Registered: August 26, 2013Reply With QuoteReport 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 8203
WindowsServer 2012 R2,
Excel, PDF, HTML, ActiveReports
 
Posts: 124 | Location: Minnesota | Registered: August 26, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.