SQL Server Analysis Services announcement
-
0 Votes
Array instead of data in dimension
Hi everyone! I have an OLAP cube with two dimensions: date and category, and measure of data for each category and date. When I try to use this cube in Power BI line chart, it gives ... -
0 Votes
DAX Measure Requirements in tabular model
selected Order Date and Shipping Date is -
0 Votes
Performance issue on large dimension security in SSAS
Hi, We are trying to implement security on our OLAP cubes. Security limitations should be applied on a large +50mln members Customer dimension. Roles are created using ...Unanswered | 3 Replies | 204 Views | Created by edie1982 - Wednesday, December 4, 2019 10:46 AM | Last reply by Will_Kong - 1 hour 21 minutes ago -
0 Votes
errors with lookupvalue in ssas tabular cube
Does anyone have troubleshooting ideas with a LOOKUPVALUE function between 2 tables? V_LOG_BASED - Listing of Surgical Logs, 1 row per ...Answered | 3 Replies | 323 Views | Created by J.C.Heich - Wednesday, December 4, 2019 7:08 PM | Last reply by Will_Kong - 1 hour 33 minutes ago -
0 Votes
MDX using lag with last periods
Hi, Is this the best way to represent 12 months rolling data and lagging 2 months? sum(Intersect ([Time].[Fiscal].[Fiscal Mo].Members, LastPeriods (12, ...Unanswered | 3 Replies | 142 Views | Created by Mike Alb - Thursday, December 5, 2019 2:41 AM | Last reply by Will_Kong - 2 hours 5 minutes ago -
0 Votes
SSAS Tabular DAX Functions - Use FILTER instead of LOOKUPVALUE
2 tables that are explicitly related by LOG_ID V_LOG_BASED - Listing of Surgical Logs, 1 row per LOG_ID in a defined 1:Many relationship ...Unanswered | 2 Replies | 129 Views | Created by J.C.Heich - 18 hours 13 minutes ago | Last reply by Will_Kong - 2 hours 32 minutes ago -
0 Votes
Use FIRSTNONBLANK DAX function to avoid 'A table of multiple values was supplied where a single value was expected' in SSAS Tabular Cube
Using 2 tables V_LOG_BASED - Listing of Surgical Logs, 1 row per LOG_ID in a defined 1:Many relationship with V_LOG_STAFF_PANEL_1 - Listing of ...Unanswered | 1 Replies | 136 Views | Created by J.C.Heich - 17 hours 45 minutes ago | Last reply by Will_Kong - 2 hours 53 minutes ago -
1 Votes
OLE DB error when processing dimensions in Analysis services using AMO with only TLS1.2 enabled on the server
Hi, I recently enabled TLS1.2 exclusively(only 1.2 enabled with all others like TLS1 and SSL disabled) on my SQL server. I installed all necessary patches ...Answered | 7 Replies | 1131 Views | Created by DennySong - Thursday, November 22, 2018 7:41 AM | Last reply by intrasight - 15 hours 3 minutes ago -
0 Votes
Do you want to be acknowledged as Microsoft SSAS Guru? Submit your work to December 2019 competition!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ... -
0 Votes
The 'Semi-additive measures' feature is not included in the 'Standard Edition' - removed semi-additive, still issues?
Hello, we came to the issue where we tried to deploy our cube to the standard edition. We got an error The 'Semi-additive measures' feature is not included in the 'Standard ...Answered | 2 Replies | 5523 Views | Created by YuliaKlimov - Friday, April 22, 2011 3:24 PM | Last reply by Wim SQL Server - 17 hours 22 minutes ago -
0 Votes
SQL Server Analysis Services
Hi Everyone, Can we write script to generate alert on the SQL Analysis Service database goes to suspect mode. Or query that check all the SSAS ...Proposed | 1 Replies | 174 Views | Created by Kazimcc01 - 21 hours 1 minutes ago | Last reply by philfactor - 18 hours 0 minutes ago -
0 Votes
Error on deployment of tabular model
I am looking to rename my tabular project in visual studio and then deploy it to the same analysis services server as the original one. I am going into properties of the project and then changing the ...Proposed | 2 Replies | 471 Views | Created by mjmar27 - Thursday, October 31, 2019 2:44 PM | Last reply by UlfenB - 18 hours 11 minutes ago -
0 Votes
Row Filter on SSAS Tabular Roles
Hi, I'm trying to setup row filtering on certain roles I have in one of my SSAS cubes. I have a table containing usernames for users who's access should be ...Answered | 8 Replies | 483 Views | Created by Alex_2308 - Monday, December 2, 2019 3:35 PM | Last reply by Alex_2308 - 22 hours 5 minutes ago -
0 Votes
SSAS Syncs with a different user
I try to sync 2 SSAS databases on different hosts located on the same domain. I login SSAS with windows authentication using user MSBI\Admin. When I use SSAS Sync to sync my database with a database ...Unanswered | 1 Replies | 152 Views | Created by Ryan AB - Thursday, December 5, 2019 1:30 AM | Last reply by Will_Kong - Thursday, December 5, 2019 2:38 AM -
8 Votes
Tabular 2019 compatibility level 1500: unable to process table or deploy?
I have found that using SQL Server SSAS 2019 models work fine up to compatibility level 1400. However, after changing it to level 1500 I am no longer able to ...Unanswered | 16 Replies | 1001 Views | Created by OneWithQuestions - Tuesday, November 5, 2019 8:42 PM | Last reply by OneWithQuestions - Wednesday, December 4, 2019 4:05 PM -
0 Votes
Drillthrough Query Results duplicate amount with ROLAP
Hallo, we are using drillthrough actions and getting correct values when using MOLAP. When we switch to ROLAP mode, we get the same rows, but with duplicate ...Proposed | 3 Replies | 809 Views | Created by antiwodka - Friday, November 29, 2019 10:48 AM | Last reply by antiwodka - Wednesday, December 4, 2019 9:04 AM -
0 Votes
Reviewing SQL Analysis Services (SSAS) backup Commnad
Need to understand below Analysis Services (SSAS) backup Command for Cubes. I am the new SQL Admin and previous Admin setup this local SSAS Backup and I don't know what this website and password means ...Proposed | 5 Replies | 613 Views | Created by Bundoo - Wednesday, November 27, 2019 4:12 PM | Last reply by Will_Kong - Wednesday, December 4, 2019 3:05 AM -
0 Votes
MDX Date Dependent Formula
= [Effective Date].[FY Date].[Month]&[FY 2017-Nov] and [Effective Date].[FY Date].[Month].CURRENTMEMBER.MEMBERVALUEProposed | 2 Replies | 694 Views | Created by jeffbednar - Thursday, November 14, 2019 7:13 PM | Last reply by jeffbednar - Tuesday, December 3, 2019 7:29 PM -
2 Votes
SSAS Calc including all rows in dataset?
Hi - I need a calc to ignore the null/empty cells. The calc should evaluate to less than 1000, however it is evaluating to around 750k. I'm guessing because the cube attributes ...Answered | 2 Replies | 413 Views | Created by Mike Alb - Monday, December 2, 2019 2:45 AM | Last reply by Mike Alb - Monday, December 2, 2019 5:29 PM -
0 Votes
key not found when processing partition with special hierarchy
Hello, several years ago I have created an olap cube that works with special hierarchy. It's Leading Currency Hierarchy for country ...Answered | 19 Replies | 1034 Views | Created by ziembol1977 - Thursday, November 28, 2019 8:47 PM | Last reply by ziembol1977 - Monday, December 2, 2019 8:15 AM - Items 1 to 20 of 42786 Next ›