This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in
Subscriber portal
Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 1

SQL Server Analysis Services announcement

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

RRS feed

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
SQL Server Analysis Services
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    0 Votes

    Array instead of data in dimension

    SQL Server
     > 
    SQL Server Analysis Services
    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 ...
    Unanswered | 0 Replies | 26 Views | Created by Yerkhan - 46 minutes ago
  • large check mark
    0 Votes

    DAX Measure Requirements in tabular model

    SQL Server
     > 
    SQL Server Analysis Services
    selected Order Date and Shipping Date is
    Unanswered | 0 Replies | 78 Views | Created by Anil Katabathuni - 1 hour 15 minutes ago
  • large check mark
    0 Votes

    Performance issue on large dimension security in SSAS

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    errors with lookupvalue in ssas tabular cube

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    MDX using lag with last periods

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    SSAS Tabular DAX Functions - Use FILTER instead of LOOKUPVALUE

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    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

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    1 Votes

    OLE DB error when processing dimensions in Analysis services using AMO with only TLS1.2 enabled on the server

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    Do you want to be acknowledged as Microsoft SSAS Guru? Submit your work to December 2019 competition!

    SQL Server
     > 
    SQL Server Analysis Services
    What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles ...
    Discussion | 0 Replies | 62 Views | Created by Luigi Bruno - 16 hours 53 minutes ago
  • large check mark
    0 Votes

    The 'Semi-additive measures' feature is not included in the 'Standard Edition' - removed semi-additive, still issues?

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    SQL Server Analysis Services

    SQL Server
     > 
    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
  • large check mark
    0 Votes

    Error on deployment of tabular model

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    Row Filter on SSAS Tabular Roles

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    SSAS Syncs with a different user

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    8 Votes

    Tabular 2019 compatibility level 1500: unable to process table or deploy?

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    Drillthrough Query Results duplicate amount with ROLAP

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    Reviewing SQL Analysis Services (SSAS) backup Commnad

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    MDX Date Dependent Formula

    SQL Server
     > 
    SQL Server Analysis Services
    = [Effective Date].[FY Date].[Month]&[FY 2017-Nov] and [Effective Date].[FY Date].[Month].CURRENTMEMBER.MEMBERVALUE
    Proposed | 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
  • large check mark
    2 Votes

    SSAS Calc including all rows in dataset?

    SQL Server
     > 
    SQL Server Analysis Services
    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
  • large check mark
    0 Votes

    key not found when processing partition with special hierarchy

    SQL Server
     > 
    SQL Server Analysis Services
    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 ›
Announcement: 1

SQL Server Analysis Services announcement

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2019 Microsoft