Unsupported Data format from msmdpump.dll OLAP connection
I am using the msmdpump.dll to connect my OLAP cube to Excel. Only SSL / port 443 connection
…![SSAS]()
SSAS
SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organi...
Read more- 1.0K Content
- 450 Contributors
Expert Spotlight
SQL Server Consultant
Database Expert with 15+ years experience (SQL, Access, Power BI).
Troubleshooting Question
Advice Question
Filter Dimension hierarchy to exclude last level
In my cube I have dimension Arrival Date. I have two user crated hierarchy Calendar and Fiscal.
In
…
Troubleshooting Question
MDX code to provide me with the count of members in a dimension
I'm not sure of the correct terminology but I need MDX code to provide me with the count of members
…
Troubleshooting Question
SSAS - .Tmp files created in file folder.
SSAS (or the cubes) is creating several .tmp files on the Olap/temp file folder on a daily basis.
…
Troubleshooting Question
Analysis Server (SSAS) - Please verify that SQL Browser re-director service is enable
Hi , I have geeting follwong warning message when i was trying to connect to the SSAS via EXCEL and …
Troubleshooting Question
Which Microsoft Visual Studio Data Mining Model should I use in predicting where ships ,in terms of voyage, will go based on continuous lat lon coordinates?
Hello I am writing my first data mining project
Which Microsoft Visual Studio Data Mining Model …
Which Microsoft Visual Studio Data Mining Model …
Troubleshooting Question
Row Level Security (RLS) created in SSAS Tabular works in Power BI Desktop but does not work in Power BI Service
I have created an SSAS tabular model (within Visual Studio), then created a role named "Standard …
Troubleshooting Question
Power BI Reports cannot be viewed in Power BI Service when logged in by different users of same priviliges
There are three users A, B, and C.
User A is an AD Domain User and has Admin rights in SSAS as well …
User A is an AD Domain User and has Admin rights in SSAS as well …
Troubleshooting Question
There is no gateway to access the data source rls_pbi
1. I have created a tabular model in Visual Studio and created two roles in it, each role has two …
Troubleshooting Question
Automation of adding users to Power BI Roles
Can we automatically create Roles and assign users to these Roles in Power BI.
I have a list of both …
I have a list of both …
Troubleshooting Question
Implement SSAS Tabular Model Row-Level-Security for non domain users
I have implemented row-level security for the active directory domain users for SSAS tabular model. …
Troubleshooting Question
Can we implement SSAS tabular model row-level-security on windows group rather than individual user's level?
Can we implement SSAS tabular model row-level-security based on the windows group rather than an …
Troubleshooting Question
How can I output SQL Messages Tab contents into a variable that i can then email to support in SQL
I'm trying to send a more accurate email when a cube process fails
I can see the desired detailed …
I can see the desired detailed …
Troubleshooting Question
Maximum number of row you can extract from SSAS Cube into Excel
Hi Experts
Is there a limit on the maximum number of rows, data you can pull into excel in from SSAS …
Is there a limit on the maximum number of rows, data you can pull into excel in from SSAS …
Troubleshooting Question
Get Last N weeks using DAX
Hi Team ,
Could you please help me in getting the DAX query for last 70 weeks from the …
Could you please help me in getting the DAX query for last 70 weeks from the …
Troubleshooting Question
Get last 70 weeks using DAX
Hi Experts ,
I have set current_date_flag=1 for my latest week and I am migrating the …
I have set current_date_flag=1 for my latest week and I am migrating the …
Troubleshooting Question
Fact table for registering events
Question regarding Fact table.
It is question more about general approach to the issue.
In data …
It is question more about general approach to the issue.
In data …
Troubleshooting Question
DAX DATEDIFF - filter out a date
Hi experts,
I'm trying to perform a datediff between a date column and todays date e.g.
…
I'm trying to perform a datediff between a date column and todays date e.g.
…
Troubleshooting Question
MS SQL server to SQL Azure migration.
Hi,
We are considering to Migrate from MS SQL to SQL Azure, what is the steps involve ? I knew if…
We are considering to Migrate from MS SQL to SQL Azure, what is the steps involve ? I knew if…
Troubleshooting Question
In MDX, Trying to get a "Count" field to either return 0 or an absence of a value with the "Count" column head presevered
In the event the entire row of measures is (null) this logic, that normally works, does not
it …
it …
Explore solutions and more
![SSAS]()
SSASBack to the top
SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.