i want to basically duplicate the functionality of the dimension browser--
just let people navigate a single dimension and launch a url at the bottom
level; or maybe right click at the 2nd level and launch a report at that
level.

it's gonna be parent child; and i want to make it run off of olap..

would love to see something in either ActiveX or .net that would make this a
reality..

i just really like how olap simplifies parent-child dimensions; and i am
designing this relational table that looks _just_ like a typical OLAP
parent-child dimension...

am i going to have to write this on my own?

Yes, you will need to do this on your own. Here is what is happening.

There is no API for browsing just a dimension. The query facility is really
against a cube. When you browse a dimension, Analysis Manager first checks
to see if it can find a processed cube containing the dimension in an
unmodified form (no disabled levels, etc). If such a cube is found it is
used for browsing. Otherwise, Analysis Manager will attempt to create a
temporary desktop cube (what we call "DCube") containing just this dimension
for browsing. However, this could turn out to be very slow if the dimension
is large as all the members must be re-read from the data source. To
prevent the appearance of hanging, Analysis Manager limits the size of the
dimensions that it will attempt to browse via DCube. There are also a few
features supported in regular dimensions which are not supported by
dimensions in DCube. This is why sometimes Analysis Manager will tell you
that you must process a cube before it can browse the dimension. Thus to
implement dimension browsing in your application, you will need to do the
same thing; not a trivial task.

Hope you found this useful.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

<aaron_kempf (AT) hotmail (DOT) com> wrote

I made a factless fact table (bound to an aggregate/constat = 0)

and now i just show it in a standard OWC PivotList and it works just like a
charm

now i just wish that i could get actions to work correctly

you know any good examples of actions via OWC?




"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Office XP OWC toolpack:
http://www.microsoft.com/downloads/d...DisplayLang=en

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

<aaron_kempf (AT) hotmail (DOT) com> wrote