Database Reference
In-Depth Information
12. This will calculate the PivotTable, but to write the information to the database,
you need to publish the changes. To do this, navigate to
OLAP Tools
|
What-
If Analysis
|
Publish Changes
:
Now the information has been written to Analysis Services and Analysis Services
has written it to the write back table. You can examine the values written to the table
by issuing the following query:
SELECT [SalesAmountQuota_0]
,[EmployeeKey_1]
,[DateKey_2]
,[MS_AUDIT_TIME_3]
,[MS_AUDIT_USER_4]
FROM
[AdventureWorksDW2012].[dbo].[WriteTable_Fact
Sales Quota]
Search WWH ::
Custom Search