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!

Custom MDX User FUnction HAAALP!!

Status
Not open for further replies.
MadSQLMan

MadSQLMan

Programmer
Aug 22, 2001
3
CA
I thought of doing something a little kewl.

I wanted to encrypt some data in my database and store it encrypted in the cube.

IE:

Dencrypt([Measures].[Stocks])


The function works Great.. so Now I wanted to use this as a measure..

No Joy.. :(

I was wondering.. I know that I have to check for Nulls with and IIF.. but is there w way that I can tell it to show the sum for whatever I am looking at without Custom coding every possibility?
 
Status
Not open for further replies.

Similar threads

burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
195
burakcan
burakcan
Recce
  • Locked
  • Question
Automating MDX
Replies
0
Views
76
Recce
Recce
Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
102
Rolaper
Rolaper
eo
  • Locked
  • Question
Aggregation type - NONE; but setting aggregation through MDX - how to?
Replies
1
Views
121
Shab
Shab
petersJazz
  • Locked
  • Question
MDX Filter or Except
Replies
0
Views
73
petersJazz
petersJazz

Part and Inventory Search

Sponsor

Back
Top