SQL Server Analysis Services announcement
-
0 VotesTabular Model 1400 error when updating Import to a custom Query -> An unexpected error occurred (file 'tmsavepoint.cpp', line 1528
When updating a query with the power query advanced editor, I get the following error: Failed to save modifications to the server. Error returned: 'An unexpected error occurred ...Unanswered | 4 Replies | 294 Views | Created by PedroReis-PT - Monday, September 23, 2019 10:43 AM | Last reply by PedroReis-PT - 1 hour 52 minutes ago
-
0 Votes
I have 3 SSAS MDX Cubes and want to use these 3 as Source and create 1 more new Cube. Is this possible?
Hi All, I have 3 SSAS MD Cubes and want to use these 3 as Source and create 1 more new Cube. Is this possible? Thanks Shiven:) If ...Unanswered | 2 Replies | 213 Views | Created by Shivendoo Kumar Dubey - 14 hours 28 minutes ago | Last reply by Alexei Stoyanovsky - 6 hours 46 minutes ago -
0 Votes
Calculated member using SUM with OR condition
I inherited some mdx which uses defined members. I need to make a new member which sums a measure accross a set, but the set is a union, eg SET [DATEFILTER] ...Unanswered | 3 Replies | 68 Views | Created by m_m_s - 12 hours 5 minutes ago | Last reply by Will_Kong - 7 hours 22 minutes ago -
0 Votes
SSAS: Excel MDX runs slower on SQL Server Enterprise 2017 (upgraded from 2008R2)
Hi, Good day! Just wanted to reach out and ask help/advise regarding our issue with using Excel connecting to ...Proposed | 5 Replies | 231 Views | Created by JayceeRobles - Thursday, October 3, 2019 11:02 PM | Last reply by Will_Kong - 7 hours 36 minutes ago -
3 Votes
service accounts when setting up ssas
Hi we will likely set up a stand alone ssas instance in 2017 std. I looked at links ...Unanswered | 12 Replies | 481 Views | Created by db042190 - Wednesday, September 18, 2019 3:03 PM | Last reply by Will_Kong - 8 hours 2 minutes ago -
1 Votes
SSAS Tabular roles - view in SSMS
I'm trying to give a user (or group of users) the ability to both read data from a tabular model and view the model in SSMS Per the roles ...Answered | 5 Replies | 243 Views | Created by james969 - Tuesday, October 1, 2019 5:07 PM | Last reply by Darren Gosbell - 18 hours 21 minutes ago -
0 Votes
alternatives to tabular model
Hi. are there alternatives (even with other vendors) out there to the tabular model? I don't like the tabular model training and instructional reading alternatives. the courses don't ...Unanswered | 19 Replies | 1726 Views | Created by db042190 - Monday, April 30, 2018 8:24 PM | Last reply by db042190 - 22 hours 49 minutes ago -
0 Votes
How to have Azure B2B guest user access AS MD hosted in Azure VM
Hi, I have a analysis services multidimensional model deployed in Azure VM that is domain joined to the domain managed by Azure AD Domain Services. All internal users and B2B guest ...Proposed | 4 Replies | 240 Views | Created by needforAE86 - Monday, September 30, 2019 2:40 PM | Last reply by Will_Kong - Monday, October 7, 2019 5:59 AM -
0 Votes
Simple Calculated Member Running for Forever - MDX
Hi, I am facing very strange issue with MDX (SSAS 2014), on which simplest calculated member is taking forever to execute. Could someone please help me to understand why i am facing ...Proposed | 1 Replies | 123 Views | Created by Shailendra_KS - Friday, October 4, 2019 3:44 PM | Last reply by Will_Kong - Monday, October 7, 2019 2:46 AM -
0 Votes
Hide some Dimension values
Hi, We have Tabular model with say Platform Dimension, ( members: Android, iOS, Windows, Mac etc). Question: We want to hide few Platforms (say ...Proposed | 1 Replies | 88 Views | Created by Rahul Sherawat - Sunday, October 6, 2019 4:24 PM | Last reply by Will_Kong - Monday, October 7, 2019 2:19 AM -
0 Votes
How to make Metadata refresh Dynamic in SSAS Tabular Direct Query against SQL Server
Hi all, I built a SSAS Tabular Cube which is Direct Query against SQL Server. Let's I have a Table with 10 columns when I first built the cube and later on I have added one more ...Answered | 7 Replies | 887 Views | Created by Praveen Y - Friday, September 21, 2018 1:40 PM | Last reply by Darren Gosbell - Monday, October 7, 2019 2:16 AM -
0 Votes
Migrating from Multidimensional Model to Tabular Model
Hi Everyone, I have cubes developed in Multidimensional Model, the cube sizes range between 20 and 40GB. We want to migrate these cubes to tabular models developing from the ...Proposed | 3 Replies | 271 Views | Created by chris2001dc - Wednesday, September 25, 2019 10:43 PM | Last reply by Will_Kong - Friday, October 4, 2019 7:35 AM -
0 Votes
Authentication Failed Analysis Services Deployment
properties -> Deployment -> Server it has the ServerName\InstanceName properly, using the same ServerName\InstanceName on SSMS I can connect without problem. On Data Source I ...Answered | 10 Replies | 392 Views | Created by MarianoHerrera - Thursday, September 26, 2019 2:39 PM | Last reply by Will_Kong - Friday, October 4, 2019 7:28 AM -
0 Votes
Measure to count rows by summarizing columns from 4 different tables in SSAS
Hi I am trying to create a measure in my tabular model which will show number of rows from a particular set of columns from 6 different tables. I tried to use ...Proposed | 5 Replies | 304 Views | Created by AlwaysLearner08 - Friday, September 27, 2019 6:29 AM | Last reply by Will_Kong - Friday, October 4, 2019 7:24 AM -
0 Votes
Query through dynamics ax via odata feed problem with group by
Hello I'm not totally sure if this is the best place for this question but figured I'd give it a shot, I've got a query that has multiple operations for each particular production ...Proposed | 2 Replies | 201 Views | Created by jshinnenkamp - Monday, September 30, 2019 8:37 PM | Last reply by Will_Kong - Friday, October 4, 2019 7:22 AM -
0 Votes
Can we add Measures to SUMMARIZE DAX function
Hi I am trying to create a measure which will show the number of rows returned, if I select particular set of columns from different tables. I want add measures to it as well. ...Proposed | 2 Replies | 401 Views | Created by AlwaysLearner08 - Monday, September 30, 2019 6:23 PM | Last reply by Will_Kong - Friday, October 4, 2019 7:19 AM -
0 Votes
SSAS Tabular Model Scope
Hello, What is best practice when it comes to Tabular model functional scope ? For example, if we have one enterprise system (like HR) with different functional areas (employee ...Proposed | 2 Replies | 210 Views | Created by AK_F - Monday, September 30, 2019 4:00 PM | Last reply by Will_Kong - Friday, October 4, 2019 7:17 AM -
0 Votes
Azure Analysis Service: Connecting from Excel (office 365) data not refresh and stuck at "Running OLAP query"
From Analysis Service" Symptom When the tabular model is processing data refresh in excel seems stuck at "Running OLAP query" and data is not ...Unanswered | 5 Replies | 214 Views | Created by DON'TKNOWWHO - Tuesday, October 1, 2019 7:04 AM | Last reply by Will_Kong - Friday, October 4, 2019 6:22 AM -
1 Votes
SSAS 'Alias' issue - Not able to connect via SSRS report
Hello, We have created 'alias' names for SSAS Tabular servers and trying to use this in SSRS connection string. Actual SSAS tabular server name works but ...Proposed | 7 Replies | 381 Views | Created by Manoj Muthusamy - Wednesday, September 18, 2019 6:23 PM | Last reply by Will_Kong - Friday, October 4, 2019 3:25 AM -
1 Votes
Analysis Services Multidimensional Visual Studio "Go To" in Script View (bookmarks and breakpoints)
hi folks, I have a large base of calculations within Analysis Services Multidimensional and in the Script View Editor, I am able to find all instances of a particular searched ...Answered | 2 Replies | 144 Views | Created by Cos2008 - Thursday, October 3, 2019 11:56 AM | Last reply by Cos2008 - Friday, October 4, 2019 3:19 AM - Items 1 to 20 of 42642 Next ›
