dbTalk Databases Forums  

Filter Axis and CurrentMember Function

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


Discuss Filter Axis and CurrentMember Function in the microsoft.public.sqlserver.olap forum.



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

Default Filter Axis and CurrentMember Function - 12-01-2003 , 04:20 AM






Hi,

I am trying to create a URL Action with "Cells in this Cube" as the Target
an need to retrieve the Current Member of some Dimensions.

I have used the "CurrentMember" Function but this doesn't work when the
dimension is on the Filter Axis as it then returns the Default Member
regardless of which Member is actually selected.

How do I return the selected Member of a dimension on the Filter Axis in an
Action?

Thanks,
Richard



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Filter Axis and CurrentMember Function - 12-04-2003 , 06:30 PM






How are you viewing the Action? If using the cube browser, then this is a
known bug within the cube browser. If you view the cell-level action through
a real end-user application, then the correct CurrentMember is returned.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Richard" <erasmus (AT) ntlworld (DOT) com> wrote

Quote:
Hi,

I am trying to create a URL Action with "Cells in this Cube" as the Target
an need to retrieve the Current Member of some Dimensions.

I have used the "CurrentMember" Function but this doesn't work when the
dimension is on the Filter Axis as it then returns the Default Member
regardless of which Member is actually selected.

How do I return the selected Member of a dimension on the Filter Axis in
an
Action?

Thanks,
Richard





Reply With Quote
  #3  
Old   
Richard Erasmus
 
Posts: n/a

Default Re: Filter Axis and CurrentMember Function - 01-06-2004 , 07:11 PM





Hi Dave,

You might come across another message I posted to the newsgroup again
today regarding this issue. I have tried a "real" client (Office Web
Components 10) and its even worse. It returns the default member for all
dimensions ... even those on the Pivots Axis.

Any more ideas?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.