Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     OLAP Report with sql pass thru

Read-Only Read-Only Topic
Go
Search
Notify
Tools
OLAP Report with sql pass thru
 Login/Join
 
Silver Member
posted
Hi All,

Can any one help me how to do OLAP Report with SQL pass thru. I am new to webfocus.

Thank you

Madhu


Madhu

WF Version 7.1 Windows, SQL Server Database
 
Posts: 36 | Location: Mississauga, Ontario | Registered: April 12, 2007Report This Post
Expert
posted Hide Post
Hi 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. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Silver Member
posted Hide Post
Thank you, Kerry


Madhu

WF Version 7.1 Windows, SQL Server Database
 
Posts: 36 | Location: Mississauga, Ontario | Registered: April 12, 2007Report This Post
Platinum Member
posted Hide Post
Kerry, 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.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Report This Post
Expert
posted Hide Post
Hi 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. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     OLAP Report with sql pass thru

Copyright © 1996-2020 Information Builders