Focal Point
[CLOSED] 'null' text is adding up in front of column title on drill down-OLAP

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6027075426

September 28, 2012, 11:09 AM
rags
[CLOSED] 'null' text is adding up in front of column title on drill down-OLAP
Hi,
can any one help, iam trying to run olap report, but when i drag and drop any dimension field or if i drill down on any field the text called 'null' is adding up to the column title.
Ex: if the column title is 'Student Name'
it's showing 'null Student Name'

This is my Code:

SET ASNAMES=OFF
SET EMPTYREPORT = OFF
-OLAP ON
OLAP DIMENSIONS
Dimensions: DESC_1,DESC_2,DESC_3,DESC_4,CC_CODE,CC_NAME;
END

TABLE FILE EXAPLE_RATES
PRINT
DST.START_DATE AS 'Start Date'
DST.END_DATE AS 'End Date'
DST.BUDGET_RATE AS 'B Rate'
DST.TRANSFER_RATE AS 'Trans Rate'
BY DESC_1
BY DESC_2
ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
ON TABLE SET OLAPPANE TABBED
ON TABLE SET NODATA ' '
ON TABLE SET STYLE *
END

Thankyou

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.7.03
Linux, All Outputs
October 05, 2012, 10:51 AM
Kerry
Hi rags,

From our technicals: this seems to be a known issue in OLAP, so please open a case with Customer Support Services for confirmation. You may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.