SSAS

SQL Server Analysis service

What determines if a M3 sales record is included in the SSAS Sales cube?
Sales records are filtered from the  SSAS Sales cube (SSAS_KMN) anytime the following conditions are met:  For all divisions: · If the customer order ty...
Mon, 6 Nov, 2023 12:25 PM
How to connect to SQL Server Analysis Server using Excel
Open Excel 2016 on your computer Select menu Data Select Get Data,  From Database, then From Analysis Services     ...
Tue, 30 Jan, 2024 10:16 AM
How to open the Stock Evolution data cube on Power BI service
1. Getting permissions to open the data cube Before accessing the SSAS Stock Evolution data cube you need to make sure your account has been granted ...
Mon, 2 Oct, 2023 12:05 AM
How to open the Stock Evolution data cube using Excel
1. Getting permissions to open the data cube Before accessing the SSAS Stock Evolution data cube you need to make sure your account has been granted with...
Mon, 4 Dec, 2023 2:09 AM
What is a SSAS data cube?
What is a SSAS data cube? SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Anal...
Mon, 2 Oct, 2023 12:30 AM
SSAS_Nexa data model relationship and measures
This article describes the structure of the SSAS_Nexa data cube.  If you want to know more about SSAS data cubes you can read the article at the follo...
Mon, 2 Oct, 2023 12:24 AM
Sales Channel added to SSAS_KMN data cube
A new M3 field has been added to the existing SSAS_KMN data model. This field is “Sales Channel” and is based on the Sales Channel field which can be found ...
Mon, 2 Oct, 2023 12:02 AM
How to open the WW Inventory report on Power BI service
1. Getting permissions to open the data cube Before accessing the WW Inventory report you need to make sure your account has been granted with necessa...
Mon, 2 Oct, 2023 12:14 AM
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