[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
ThankyouThis 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.