SSAS

SQL Server Analysis service

What if a KFTAP salesperson cannot view his/her own sales records when connecting to SSAS ?
What if a KFT salesperson cannot view his/her own sales in KFT sales report? This maybe caused by his/her AD account setting: - User's ac...
Wed, 6 Sep, 2023 1:48 AM
How to get access to SSAS data cubes
Before accessing any SSAS data cube you’ll need to make sure your account has been granted with necessary access rights. To do this you can proceed as foll...
Mon, 8 Apr, 2024 4:10 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 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
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
How to add KAE salesperson regions on GSF_Titanium
On GSF_Titanium data cube the dimensions used by KAE team and called [EAG Area Name] and [EAG Local Division Name] have been renamed as follows: SSAS...
Tue, 17 Dec, 2024 7:39 AM
How to Connect to GSF_Titanium using Power BI Desktop and Excel
This article demonstrates how to connect to the SSAS data cube, GSF_Titanium, using Power BI Desktop and Excel.  Connection details for GSF_T...
Tue, 31 Dec, 2024 5:04 AM