SSAS

SQL Server Analysis service

Freight cost management on the global sales file
The new freight cost management process rolled out as of 1st of July 2021 defines 5 possible options:     1. Freight on delivered price          2...
Mon, 2 Oct, 2023 12:28 AM
How to solve SSRS "Could not load folder contents"
User face this error when access to SSRS Kemin, local IT support may add the security group TS_MAS_ALL to the user profile in AD. Error message: ...
Wed, 6 Sep, 2023 1:55 AM
How to request for a new division to be added to the global sales file
When the business sends a request for a new division to be added to the global sales file, the following parameters should be provided in order to complete ...
Mon, 2 Oct, 2023 12:13 AM
How to enter/update the 'KH Region Name' field on BPW
The "KH Region Name" is visible on SSAS_KMN data cube This field is pulling records from table [MatrixData].dbo.[Dim_KHSalespersonReg...
Tue, 2 May, 2023 1:42 AM
How to handle changes to [EAG Local Division] column on SSAS
In order to update the [EAG Local Division] column on SSAS_KMN you'll need to update records in table  [BPW_Datamarts].dbo. [Dim_Europe_Salesperson_Area...
Tue, 17 Oct, 2023 2:37 AM
ThreeM segment dimension
The 'ThreeM Segment' is available for item segmentation purposes on the SSAS_KMN and SSAS_NexaRefresh data cube as column of the 'Item' and ...
Fri, 5 Jan, 2024 3:57 AM
SSAS_NexaRefresh data cube
In July 2023 the SSAS_Nexa data cube has been replaced  by the SSAS_NexaRefresh featuring  a brand new set of measures.  Please refer to the attached ...
Tue, 6 Feb, 2024 8:35 AM