Re: Drillthrough sample for visual basic 6

• Previous message: Jéjé: "how to list ALL cubes (processed and not) using ADOMD.NET?"
• In reply to: Mario Gherardi: "Re: Drillthrough sample for visual basic 6"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 11 Nov 2004 13:30:07 -0800

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c20c9be-6112-4596-92d9-10163ba60427&DisplayLang=en

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mario Gherardi" <MarioGherardi@discussions.microsoft.com> wrote in message
news:D5C4F96A-69F9-4A2C-9D58-CA6BC7AB6819@microsoft.com...
> Please, i need some help,
> Any somple code would be of great value.
>
> "Mario Gherardi" wrote:
>
> > Pivottable Its an ActiveX control on my vb application (it comes with
> > Microsoft Ofice XP Web component), once you have this control on a vb
form
> > you set the ConnectionString and Datamember properties:
> >
> > In my code Pivottable component has the name pvtPanel
> >         pvtPanel.ConnectionString = "...string connection...."
> >         pvtPanel.Datamember = "...Name of the OLAP cube..."
> >
> > Then there's a lot of Events, Methods and Properties to play with, in
> > runtime the user makes a query by Dragging the dimensions and Dropping
it on
> > Pages, Columns or rows on this component, i know there's a way to
generate
> > the MDX command (of the query shown in the component) by catching some
event
> > and programming a "for each" that loops a collection of Pages, Columns,
> > Rows... and generates a string with the MDX command, then you instance a
new
> > pivottable, and send the command to the OLAP that bring the details
back.
> >
> > Thanks again.
> >
> > "Dave Wickert [MSFT]" wrote:
> >
> > > Hmmm... Let's step back a bit.
> > > Pivottable embedded in a VB form?
> > > I assume that you mean hosting an OWC ActiveX control in your VB
> > > application?
> > > This Pivottable -- how is it generated? or is this something
> > > you are writing?
> > > -- 
> > > Dave Wickert [MSFT]
> > > dwickert@online.microsoft.com
> > > Program Manager
> > > BI SystemsTeam
> > > SQL BI Product Unit (Analysis Services)
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > > "Mario Gherardi" <MarioGherardi@discussions.microsoft.com> wrote in
message
> > > news:04EA7BB0-4A90-44A1-80E7-93632AF2E79B@microsoft.com...
> > > > Thanks Dave, but i just download this code before and help me a
little,
> > > this
> > > > code asume that you know the MDX command, i need sample code about
> > > generate
> > > > MDX command from a pivottable embedded in a visual basic form (its a
> > > dynamic
> > > > MDX command depending on the query shown in the pivot object).
> > > >
> > > > "Dave Wickert [MSFT]" wrote:
> > > >
> > > > >
> > >
http://www.microsoft.com/downloads/details.aspx?FamilyID=3c20c9be-6112-4596-92d9-10163ba60427&DisplayLang=en
> > > > >
> > > > > Should do it exactly.
> > > > > Hope you find it useful.
> > > > > -- 
> > > > > Dave Wickert [MSFT]
> > > > > dwickert@online.microsoft.com
> > > > > Program Manager
> > > > > BI SystemsTeam
> > > > > SQL BI Product Unit (Analysis Services)
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > > "Mario Gherardi" <Mario Gherardi@discussions.microsoft.com> wrote
in
> > > message
> > > > > news:56712025-274C-4505-8E17-65B2B5EBBBCD@microsoft.com...
> > > > > > Can anybody provide sample code to invoke drillthrough from
visual
> > > basic
> > > > > > application.
> > > > > > I'm developing a vb application using OWC 10 and don't know how
to
> > > > > implement
> > > > > > the drillthrough functionality. I found some samples but just
for a
> > > web
> > > > > > application or from excel.
> > > > > > Any sample would be of great value
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >

• Previous message: Jéjé: "how to list ALL cubes (processed and not) using ADOMD.NET?"
• In reply to: Mario Gherardi: "Re: Drillthrough sample for visual basic 6"
• Messages sorted by: [ date ] [ thread ]