dbTalk Databases Forums  

urgent action required

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


Discuss urgent action required in the microsoft.public.sqlserver.olap forum.



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

Default urgent action required - 07-12-2004 , 08:32 AM






hi,
i need to create an action using URL. i'm trying with the
foodmart database. my query is

"http://localhost/test/orderscube.asp?customers="+
[Customers].CurrentMember.Name + "&time=" +
[Time].currentmember.name +"&store=" +
[Store].currentmember.name +".htm"

my target is for a level (customers dim)in the cube. its
just displaying names for the time and customer name in
the output ..i want it todisplay the store name also..

how can we do this ???

also if i want to include two more dimensions like gender
and product to this one .... how to include those?
any one plz help me.

Reply With Quote
  #2  
Old   
Fernando Ponte
 
Posts: n/a

Default RE: urgent action required - 07-12-2004 , 12:09 PM






Hi.

This is happening because you did not filter the Store dimension, and the default member for that dimension (and possible all dimensions in your cube) are set to ALL.

If you want to know where your customer bought some product, and what kind of product. I guess you have to find other way to reach the desirable answer.

Try LOOKUP.

I hope it may help.
--
Fernando Ponte

"alex" wrote:

Quote:
hi,
i need to create an action using URL. i'm trying with the
foodmart database. my query is

"http://localhost/test/orderscube.asp?customers="+
[Customers].CurrentMember.Name + "&time=" +
[Time].currentmember.name +"&store=" +
[Store].currentmember.name +".htm"

my target is for a level (customers dim)in the cube. its
just displaying names for the time and customer name in
the output ..i want it todisplay the store name also..

how can we do this ???

also if i want to include two more dimensions like gender
and product to this one .... how to include those?
any one plz help me.


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.