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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculation using member property

Status
Not open for further replies.
BKhanna

BKhanna

MIS
Jul 19, 2004
38
US
I am trying to use a member property to do a calculation. The property is in the period dimension and is called UDA, and I am just testing to see if it works by creating the calculated member below, but I get #ERR when I look at the data. I am just trying to have it show a 0 if the member property is "Period_FirstPeriod" and show a 1 otherwise. Does anyone know what's wrong with it?

Iif(Period.CurrentMember.Properties("UDA")="Period_FirstPeriod",0,1)

Thanks!
BK
 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
137
Benedito Almeida
Benedito Almeida
scabral1979
  • Locked
  • Question
filtering using strtoset
Replies
0
Views
126
scabral1979
scabral1979
capitanosol
  • Locked
  • Question
Extracting the DataSource Property from DataTable in DSV
Replies
2
Views
122
capitanosol
capitanosol
ianclarke
  • Locked
  • Question
Unknown Member & Null Processing
Replies
0
Views
87
ianclarke
ianclarke
msasnewb
  • Locked
  • Question
Help with calculation in analysis services
Replies
1
Views
88
Recce
Recce

Part and Inventory Search

Sponsor

Back
Top