Hi,

I am trying to generate an OLAP enabled report. I have been able to create my own MAS file that has a dimension defined within, and then I am able to see the data correctly in the report.

But I want to see the filter consitions on top of the report, the same way as you see for olaprep7 under ibinccen directory.

My Fex file Code:

-OLAP ON

TABLE FILE GEOSTR
SUM
SEQNBR AS 'No. Of,Cites'
BY AREA
BY REGION
BY COUNTRY
BY SEQNBR NOPRINT
HEADING
"Location Hierarchy Report"
"Prepared on <+0>&DATE<+0> at <+0>&TOD"
FOOTING
"---- End of Report ----"
WHERE AREA NE MISSING;
WHERE ( AREA NE MISSING ) AND ( ALIAS EQ 'N' ) AND ( SEQNBR EQ 1 );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET AUTODRILL ALL
ON TABLE SET OLAPPANE TOP
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=PTS,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
LINES-PER-PAGE=UNLIMITED,
$

My only problem is that I do not get the select dropdowns for my dimensions (AREA, REGION, COUNTRY) etc... on the top of the pane (ON TABLE SET OLAPPANE TOP does not seem to be working).

Instead I get a Javascript error with a message "Permission Denied".

I am completely sstuck up here, I understand that this is a security related thing, but unless I know what it is, and how to counter this, I am not going to make any progress.

Any help in this matter would be great.

Thanks,
Ved

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

What kind of file is GEOSTR? Do you/server have read access to it?

What is the directory/file permission on the master?

Hi Ginny,

This is a Master file that I have created with SUFFIX=SQLORA.

As I already mentioned, there is absolutely no problem in fetching the data. I am seesing the data coming up perfectly in the report with all the OLAP functionalities without the PANEL being present. I want the panel to come up.

Does the Master file need to have some specific permission? I will grant all access and then revert back.

Thanks,
Ved

Just retried after granting all permission on file to everyone (chmod +777)
Still no luck

Check your browser permissions.

Have you tried this on another PC?

Yes, I checked my Browser permission, but I am not really sure what to look for in there.

Another interesting finiding:

1. When I run OLAPREP7 from DevStudio, the OLAP Pane comes on the top as it should.
2. Then I run my report, and this Permission Denied thing comes up
3. Then when I again run OLAPREP7 (step 1), I get the permission Denied error.

Any pointers??? I am really stuck here

You need to figure out where your permission problem is coming from. Is it from the reporting server which means that if you are running with security on, you might be losing your cookies? Are you running from MRE? Or are you running from Data Servers? Do you have web server security?

Just saying 'permission denied' doesn't give us a lot to go on.