Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX select statement to show all cube data based on the user login ID

Status
Not open for further replies.
gaperry

gaperry

IS-IT--Management
Jan 29, 2002
37
US
I am somewhat new to MDX. I have a webpage that displays a
pivot table based on an Analysis server data cube. I am trying to create and MDX statement that would show ALL data in the cube for a given sales person based on the Microsoft login ID.

Example: Show all data in a given cube for sales person number 70 where user name is 70.

I have a few books on this but can't seem to find the answer in any of them or in any of the Microsoft supplied materials. Any help here would be appreciated.

Thanks
 
Status
Not open for further replies.

Similar threads

Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
96
Antonius222
Antonius222
isoman4not5
  • Locked
  • Question
Is it possible to derive a recurring date based upon a single date?
Replies
0
Views
240
isoman4not5
isoman4not5
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
428
k5tm
k5tm
maxzikpi
  • Locked
  • Question
How to Create a cube with a survey result. Pls help!
Replies
4
Views
287
maxzikpi
maxzikpi
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
239
acoronel
acoronel

Part and Inventory Search

Sponsor

Back
Top