Customized Table inside of VS project

legato

New Member
Joined
Jun 4, 2013
Messages
13
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.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,181,708
Messages
5,931,592
Members
436,795
Latest member
mazigazi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top