Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

PB with SQL Server OLAP

52 views
Skip to first unread message

César Ratto

unread,
Jul 23, 2003, 11:22:43 AM7/23/03
to
Is there a page where I can find information on how to connect a pb
application (PB 8.0.3) to an OLAP cube and how can I make MDX sentences over
it?

TIA


--
Ing. César Ratto Díaz MCSE
Coordinador de Informática
Colegio Antonio Raimondi


WS

unread,
Jul 23, 2003, 3:29:55 PM7/23/03
to
Integrating the OLAP with PB:


Step1: install English Query type library. You could only this test only on
the computers it is installed. Its "Microsoft English Query Type Library
2.0"

Step2: compile the db model into an English Query Domain (.eqd) file from
BUILD menu

Step3: Create a new session and set its domain as the eqd file created with
initdomain function call

Step4: create SQL stmt and pass to parserequest function call. The result
will be a response objects with olap commands defined under it.

Step5: Iterated through these commands 0 to maxcount till you match
DBMSTYPE of the command on the count to be an olap command. The result
would be a query variable which would have QUERYTEXT as the required OLAP
command.

A VB example for references could be found on
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8035&pg=2.

Good luck

WS

"César Ratto" <cra...@ciaraimondi.edu.pe> wrote in message
news:e4A309SUDHA.280@forums-2-dub...

0 new messages