windows server 2008 and windows 10 and sql server 2000
I have a network around Windows Server 2008, and client workstations under Windows 7 and SQL Server 2000 database applications, everything works well by adding a workstation under Windows 10 and SQL Server 2000 locally it works well, but in network the…
Unable to connect to localhost in Visual Studio 2019 (tabular model designer)
I want to create Tabular Project in Visual Studio 2019. After opening Visual Studio 2019 i click on "Create New Project". Then i had clicked on "Analysis Services Tabular Project". Then configure new project and when i was about to…
Building a super-efficient incremental refresh process in SSAS
Suppose I have 2 years time entry data (~25M rows) by employee and day and project etc. At any point of time any rows within those 2 years can change (new rows added, existing rows modified or potentially some rows deleted too). The number of rows…
Unable to open the Tabular Model Designer due to Access denied.
Hi, Last few weeks we had encountered an issue where all our cube was not able to be opened with an error access is denied. Besides that, we have also tried to open a cube from our local repo which also showed an error where access is denied. We have…
Is there any way to set a latitude and longitude attribute type for a dimension?
I am trying to connect from Power BI to an Analysis Services Cube (2016) using the live connection and a map visualizer. Is there anyway to define the latitude and longitude in Visual Studio for the dimension attribute so Power BI picks it up? I notice…
SSAS tabular cube occupies RAM dynamically depending on server RAM size
I have an SSAS tabular cube deployed on 2 servers. One server is having 512GB RAM (server1) and the other has 256GB RAM (server2). When we check the Memory details on task manager on both the servers, it shows 110GB (of 512GB) as occupied RAM on server1.…
Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"
We got this error when it was processing a tabular model partition in SSAS from an SSIS package. This is the JSON that process the partition: { "refresh": { "type": "full", "objects": [ { "database":…
Get list Administrators - DISCOVER_XML_METADATA
Hi, Running an XMLA script to get all administrators of SSAS. See below. Do you have to be an administrator to run this script or is it possible to give the user that runs the script another role/access that do not give that user admin rights, but the…
SSAS : Errors in the metadata file - error trying to update cube in a system table 'DataSource'
0 A few days ago, we started having an error with the processing in our cube. The cube is being processed by the job and returns the error: The following system error occurred: Invalid data. Failed to decrypt sensitive data. Possibly the encryption key…
VS solution cannot open .bim value of '311' is not valid
I have a VS solution tabular model .bim that has been created and deployed to our production and development environment. The data is being processed nightly through Azure. HOwever, I am now not able to open the .bim in the solution. I receive the…
Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient
Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient yesterday Let's say I have this MDX query against SQL Server's Analysis Service Adventure Works sample: select [Measures].[Customer Count] on columns,…
error message om ssas
In my SSAS im getting the below message Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. any suggestions on how to fix this?
SSIS package is not opening
I am getting issue while opening any package in SSIS. The task with the name “SQL – Get Last Run Date” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer. Contact Information: Execute SQL Task; Microsoft Corporation;…
Problems opening a tabular model file in different computer where it was created (localhost issues)
Hi! I have been working with analysis services for years (both olap and tabular). In the past, I was able to share the original files of a tabular model with my team members. I found that when someone different from the creator tried to open the file,…
How do I change SSAS 2022 default compatibility level from 1200 to 1500
I installed SQL Server Analysis Enterprise 2022 and the default compatibility level is 1200. How do I change it to 1500? Thanks for the help!
An error on ssas
Hi. When I use SSAS, an error occurred. Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. Why? How can I fix this? Thanks a lot.
Visual Studio 2019 (SSAS) - Error when trying to open my model
The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model. I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that…
Tabular Model processing a calculated table (recalc)
I have a calculated table in my SSAS Tabular Model which is getting data load using a dax script. when we are checking the data using evaluate tablename' in ssms , I am getting errror like- table need to be processed or recalc. When we are processing…
SSAS Connect Problem
I have trouble connecting to SSAS, is there any documentation I can learn? Thanks!
Week dimension in case of month split
Hello! For example In year 2024 week 9 splits into two months PK_Date Month Month_Of_Year Week Week_Name Week_Of_Year 2024-02-26 00:00:00.000 2024-02-01 00:00:00.000 2 2024-02-26 00:00:00.000 vko.9 9 2024-02-27 00:00:00.000 2024-02-01…