November 6, 2013 at 2:39 pm
Goal:
Create a new column, named test , containing numbers in SSAS only inside of DSV design view.
If StatePrinceCode's column has value NSW it shall have value 1 etc.
StateProvinceCode test
------------------------------
NSW 1
QLD 2
SA 3
Problem:
How should I enable to do it? I tried using IIF and case statement but it doesn't want to do it due to text value. It only works with numbers only.
Information:
- I strongly believe that you need to create a named calculation as a extra column to add the value
The new column shall apply in the table Geography in SSAS.
In this context no usage of SQL server database
November 7, 2013 at 8:31 am
akirajt (11/6/2013)
Problem:How should I enable to do it? I tried using IIF and case statement but it doesn't want to do it due to text value. It only works with numbers only.
Could you explain this problem with more detail please - what is the column for? why must it be an integer?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply