MS SQL Server OLAP - CellSetGrid

Author

CellSetGrid

danpowley@yahoo.co.uk

2005-04-21, 11:24 am

Hi

I am trying to extend CellSetGrid so that I can save views. Other Olap
clients I've used (JPivot) create each grid with a piece of standalone
MDX. CellSetGrid uses NamedSets (with v.good reason) so its not as easy
to save a view.

Does anyone know the easiest way to save views with CellSetGrid, I see
that the state serialized as XML is available and this can be used to
re-create a CellSetQuery object, but I am struggling to achieve this.

If I can re-create a CellSetQuery from a saved state, and then re-run
the MDX which gets the grid, is this the best way to extend
CellSetGrid? Any pointers would be great, am very inexperienced, no
advice too trivial!

Thanks for any help
Cheers, Dan Powley

dan

2005-04-21, 11:24 am

Sorry for wasting peoples time, I was loding the state in the
CreateChildControls method when I should have been doing it in the open
method (seems obvious now!) seems to be working great, am very pleased
with CellSetGrid, highly recommended.

Thanks
Dan

Godina

2005-04-26, 3:24 am

Request: Hope is reasonable.

I have used Cognos Power Play and it has a function that is useful
when browsing cubes. Having the avility to drill-through, for
example, if one of your dimensions is Location, you might have USA,
Canada. If you drill through USA, Canada will go away. If you drill
up, Canada will show again. Having a drill-down is very helpfull, but
when you have a lot of drill downs, the screen can look some what
messy and hard to read. Having the Drill-Through solves this
problem.

Thanks :D

> Richard Tkachuk [MSFT]wrote:
"]Glad you like it. I have a blast playing with it. You can give it
mdx with
> the restriction that measures has to be the last hierarchy on the
columns
> axis. For example
>
> select measures.allmembers on 0, Customer.countries on 1 from sales
>
> will work fine, but
>
> select Customer.countries.members on 0, measures.allmembers on 1
from sales

> or
> select Customer.countries.members on 0 from sales where
(measures.)
>
> will throw an exception.
>
> I'm looking at removing this odd restriction, but this is the way it
is now.
> Of course, since you have the code you can fix it yourself :)
>
> Shameless plug: the asp.net cube browser control and well as the
source code
> Woody references is available at
http:// www:sqlserveranalysi
sservices.com .
> It's some sample code I put together that I'm still working on. If
anyone
> encounters problems or has a (reasonable) request, drop a note here
or send
> me a note. No promises, but I'll at least consider it. If you make
changes
> or fixes that would be generally requested, please drop me a note
and we can
> get them incorporated. (Thanks to Kris Kaminski who spotted the
multi-form
> problem since fixed).
>
> And if you really like it, include a link on your web site. I'm
trying to
> match Mosha's google ranking (http://www.mosha.com).
>
> Have fun,
> Richard
> --
> _______________
> Disclaimer : This posting is provided "AS IS" with no warranties,
and
> confers no rights.
>
>
> "woody" <david.wood@harpercollins.co.uk> wrote in message
> news:1110557281.522583.235480@f14g2000cwb.googlegroups.com...
> Great .net application. Just what I have been looking for. Does
anyone
> know how to initialise the object by passing in some
dimension/ measure
> parameters to show a default view.
>
> thanks
> [/quote:41ea230561] :D

Sponsored Links