April 20, 2007, 08:44 AM
MadhuOLAP Report with sql pass thru
Hi All,
Can any one help me how to do OLAP Report with SQL pass thru. I am new to webfocus.
Thank you
Madhu
April 25, 2007, 11:32 AM
KerryHi Madhu,
Heard from internal resources: OLAP cannot be done with SQL Passthru. OLAP involves creating dimensions from master files and there are no master files with SQL Passthru.
To confirm this, and/or submit this as a New Feature Request (NFR), please contact Information Builders' Customer Support Services and open a new case for that. You may either call at 1-800-736-6130, or access the online system InfoResponse at
http://techsupport.ibi.com. Here is a list of information to be ready when you call:
http://techsupport.ibi.com/before_you_call.jsp.
Hope this helps.
Cheers,
Kerry
April 26, 2007, 09:52 AM
Jessica BottoneKerry, couldn't he use APP HOLD to save off the HOLD and the associated MFD? For example:
(this assumes Oracle but could be any RDBMS)
APP HOLD BASEAPP
SQL SQLORA
-*- enter your sql here
;
TABLE ON TABLE HOLD AS MADHU
END
-RUN
TABLE FILE MADHU
-*- do your OLAP reporting here
END
APP HOLD
When this is done, there will be a MADHU.FTM and a MADHU.MAS in the BASEAPP folder that he could then do his OLAP reporting against. Would this not work? Note: the APP HOLD at the end is important in that it turns that feature off again.
May 03, 2007, 10:58 AM
KerryHi Jessica,
You are correct that, you can do OLAP against the hold file. However, that is static data. It is no longer going through SQL Passthru, so if the data in the database changes, you will need to recreate the hold files to get up-to-time data.
Hope this helps.
Cheers,
Kerry