dbTalk Databases Forums  

HOWTO place named sets on an axis in a manner similar to a dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss HOWTO place named sets on an axis in a manner similar to a dimension in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Madan
 
Posts: n/a

Default HOWTO place named sets on an axis in a manner similar to a dimension - 09-09-2003 , 03:48 AM






Hi

I looking for help regarding
HOWTO place named sets on an axis in a manner similar to a
dimension in a client application.

I'm using OWC 9.0 (Pivot Table component) and this is
embedded in an ASP Page.

I need to show only data that match to a criteria (For
Example, Age > 25)... and unfortunately OWC 9.0 cannot
take MDX Queries ...

I want to try whether i can use Named sets for this
purpose.

I'm very new to OWC but have worked with MDX and MS OLAP a
little bit.

Looking fwd to your help ...

Madan

Reply With Quote
  #2  
Old   
Tom Chester
 
Posts: n/a

Default Re: HOWTO place named sets on an axis in a manner similar to a dimension - 09-09-2003 , 09:02 AM






The only way to reference a named set using owc is in a SELECT statement,
which as you note is not supported in older versions.

tom @ the domain below
www.tomchester.net


"Madan" <madddan (AT) yahoo (DOT) com> wrote

Quote:
Hi

I looking for help regarding
HOWTO place named sets on an axis in a manner similar to a
dimension in a client application.

I'm using OWC 9.0 (Pivot Table component) and this is
embedded in an ASP Page.

I need to show only data that match to a criteria (For
Example, Age > 25)... and unfortunately OWC 9.0 cannot
take MDX Queries ...

I want to try whether i can use Named sets for this
purpose.

I'm very new to OWC but have worked with MDX and MS OLAP a
little bit.

Looking fwd to your help ...

Madan



Reply With Quote
  #3  
Old   
Madan
 
Posts: n/a

Default Re: HOWTO place named sets on an axis in a manner similar to a dimension - 09-09-2003 , 09:52 AM



Hi Tom

Thanks for your response.

Can i disable the filter option for a particular dimension
alone?

what i want to achieve is that i have a Cube will all data
and i want the user to access only data that he is
responsible for ... in that case i need to restrict the
data flow from the server to the client and is possible
thru MDX but OWC 9.0 doesn't support this.

on the other hand, can i get all the data to the
client ... then apply filter using client-side script and
disable the option for selecting or deselecting any member
from the dimension?

Looking fwd to your reply

Madan

Quote:
-----Original Message-----
The only way to reference a named set using owc is in a
SELECT statement,
which as you note is not supported in older versions.

tom @ the domain below
www.tomchester.net


"Madan" <madddan (AT) yahoo (DOT) com> wrote in message
news:528901c376af$1df5d3b0$a601280a (AT) phx (DOT) gbl...
Hi

I looking for help regarding
HOWTO place named sets on an axis in a manner similar
to a
dimension in a client application.

I'm using OWC 9.0 (Pivot Table component) and this is
embedded in an ASP Page.

I need to show only data that match to a criteria (For
Example, Age > 25)... and unfortunately OWC 9.0 cannot
take MDX Queries ...

I want to try whether i can use Named sets for this
purpose.

I'm very new to OWC but have worked with MDX and MS
OLAP a
little bit.

Looking fwd to your help ...

Madan


.


Reply With Quote
  #4  
Old   
Tom Chester
 
Posts: n/a

Default Re: HOWTO place named sets on an axis in a manner similar to a dimension - 09-09-2003 , 10:55 AM



Sorry Madan, I don't have OWC 9 at hand to remind myself.

tom @ the domain below
www.tomchester.net


"Madan" <madddan (AT) yahoo (DOT) com> wrote

Quote:
Hi Tom

Thanks for your response.

Can i disable the filter option for a particular dimension
alone?

what i want to achieve is that i have a Cube will all data
and i want the user to access only data that he is
responsible for ... in that case i need to restrict the
data flow from the server to the client and is possible
thru MDX but OWC 9.0 doesn't support this.

on the other hand, can i get all the data to the
client ... then apply filter using client-side script and
disable the option for selecting or deselecting any member
from the dimension?

Looking fwd to your reply

Madan

-----Original Message-----
The only way to reference a named set using owc is in a
SELECT statement,
which as you note is not supported in older versions.

tom @ the domain below
www.tomchester.net


"Madan" <madddan (AT) yahoo (DOT) com> wrote in message
news:528901c376af$1df5d3b0$a601280a (AT) phx (DOT) gbl...
Hi

I looking for help regarding
HOWTO place named sets on an axis in a manner similar
to a
dimension in a client application.

I'm using OWC 9.0 (Pivot Table component) and this is
embedded in an ASP Page.

I need to show only data that match to a criteria (For
Example, Age > 25)... and unfortunately OWC 9.0 cannot
take MDX Queries ...

I want to try whether i can use Named sets for this
purpose.

I'm very new to OWC but have worked with MDX and MS
OLAP a
little bit.

Looking fwd to your help ...

Madan


.




Reply With Quote
  #5  
Old   
Chris
 
Posts: n/a

Default RE: HOWTO place named sets on an axis in a manner similar to a dimension - 09-12-2009 , 04:10 PM



I need to know the answer to this as well if anyone knows. I've been searching all over the place and can't find anything.

From http://www.google.com/url?sa=t&sourc...vwrCjrl5u7yK_Q

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.