If you have a fact table that you have uloaded från SQL server to VS2010 SSAS tabular with this table and its data:
Table A
PK_test qty productNumber
-----------------------------------------------
1 5 asdf
2 4 asdf
3 9 sdfg
4 1 sdfg
5 1 lkj
6 6 lkj
7 3 lkj
8 3 mnb
However, before you want to deploy the model to the tabular instance for SQL server 2012 I want to make some changes that table A:s data will be changed into:
PK_test qty productNumber
-----------------------------------------------
1 9 asdf
3 10 sdfg
5 10 lkj
8 3 mnb
In order word, that data will be changed inside of the VS:s project before you deploy it to SQL server.
The question is: What course of action should I do it?
Info:
- I see that it would be some kind of calculated table, not calculated column.
- No SQL coding shall not be used.
Table A
PK_test qty productNumber
-----------------------------------------------
1 5 asdf
2 4 asdf
3 9 sdfg
4 1 sdfg
5 1 lkj
6 6 lkj
7 3 lkj
8 3 mnb
However, before you want to deploy the model to the tabular instance for SQL server 2012 I want to make some changes that table A:s data will be changed into:
PK_test qty productNumber
-----------------------------------------------
1 9 asdf
3 10 sdfg
5 10 lkj
8 3 mnb
In order word, that data will be changed inside of the VS:s project before you deploy it to SQL server.
The question is: What course of action should I do it?
Info:
- I see that it would be some kind of calculated table, not calculated column.
- No SQL coding shall not be used.
