Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

New Column with numbers Expand / Collapse
Author
Message
Posted Wednesday, November 06, 2013 2:39 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 6:47 AM
Points: 56, Visits: 184
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


  Post Attachments 
picture1.png (3 views, 92.95 KB)
picture2.png (2 views, 151.40 KB)
Post #1512013
Posted Thursday, November 07, 2013 8:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 3:45 AM
Points: 390, Visits: 700
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?





I'm on LinkedIn
Post #1512312
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse