This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows Server
  • System Center
  • Microsoft Edge
 
  • Office
  • Office 365
  • Exchange Server
 
  • SQL Server
  • SharePoint Products
  • Skype for Business
  • See all products »
Resources
  • Channel 9 Video
  • Evaluation Center
  • Learning Resources
  • Microsoft Tech Companion App
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Windows Update
Trials
  • Windows Server 2016
  • System Center 2016
  • Windows 10 Enterprise
  • SQL Server 2016
  • See all trials »
Related Sites
  • Microsoft Download Center
  • Microsoft Evaluation Center
  • Drivers
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Expert-led, virtual classes
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • Microsoft Official Courses On-Demand
Certifications
  • Certification overview
  • Special offers
  • MCSE Cloud Platform and Infrastructure
  • MCSE: Mobility
  • MCSE: Data Management and Analytics
  • MCSE Productivity
Other resources
  • Microsoft Events
  • Exam Replay
  • Born To Learn blog
  • Find technical communities in your area
  • Azure training
  • Official Practice Tests
Support options
  • For business
  • For developers
  • For IT professionals
  • For technical support
  • Support offerings
More support
  • Microsoft Premier Online
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums
SQL Server
 
Sign in
United States (English)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中国 (中文)台灣 (中文)日本 (日本語)
 
 
Home20122008 R2200820052000LibraryForums
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

    Filtering DAX Function Tabular Model SSAS

    SQL Server
     > 
    SQL Server Analysis Services
    Suppose that you are working in retail company. There is Stores, Products and etc dimensions. And also there is Sales, Prices and etc facts. For stores, there is one store with code 0 that, it is ...
    Unanswered | 1 Replies | 273 Views | Created by Aynur Agayeva - Friday, December 13, 2019 12:18 PM | Last reply by Darren Gosbell - 4 hours 26 minutes ago
  • large check mark
    0 Votes

    Get the month number from datetime in MDX query

    SQL Server
     > 
    SQL Server Analysis Services
    I want to get the month number from datetime in MDX query, Example if i have the date as: 12/07/2019, the query should return me as ...
    Proposed | 3 Replies | 309 Views | Created by Get the Month number from datetime - Thursday, December 12, 2019 1:57 PM | Last reply by Alexei Stoyanovsky - Friday, December 13, 2019 8:13 PM
  • large check mark
    0 Votes

    How to put Asterisk (*) in format_string to have it working in excel (for right text alignment)

    SQL Server
     > 
    SQL Server Analysis Services
    hello everybody Format string ;;;* @ In excel delivers right alignment for text values The problem is when we apply the ...
    Unanswered | 2 Replies | 251 Views | Created by sergey vdovin (aka evolex) - Thursday, December 12, 2019 4:50 PM | Last reply by sergey vdovin (aka evolex) - Friday, December 13, 2019 2:35 PM
  • large check mark
    0 Votes

    Measure location for query-generated SSAS tabular calculated table

    SQL Server
     > 
    SQL Server Analysis Services
    I am using a calculated table called Query_SuppliesUpdate in SSAS Tabular 2016 with a query like this: SUMMARIZECOLUMNS ( "Budget PQM1", [Budget ...
    Unanswered | 13 Replies | 1079 Views | Created by Rory Noone - Saturday, July 20, 2019 8:00 PM | Last reply by Upitor - Friday, December 13, 2019 9:32 AM
  • large check mark
    0 Votes

    Data Mining - Cube & Cuboids

    SQL Server
     > 
    SQL Server Analysis Services
    Can this (customer_state, supplier, supplier_state, product, product_group) be a possible cuboid if a cube has following dimension hierarchies: {customer < customer_city < ...
    Unanswered | 1 Replies | 263 Views | Created by Rick.15t - Thursday, December 12, 2019 5:44 PM | Last reply by Lukas DreiKlein - Friday, December 13, 2019 7:13 AM
  • large check mark
    0 Votes

    SSAS error 3238002688: internal error while processing!

    SQL Server
     > 
    SQL Server Analysis Services
    hello, we are facing an issue that we dont quite understand between our different environments while processing a cube, error 3238002688, described as an internal error on ...
    Unanswered | 1 Replies | 175 Views | Created by Oussama MOUMSIK - Thursday, December 12, 2019 2:29 PM | Last reply by Darren Gosbell - Thursday, December 12, 2019 10:14 PM
  • large check mark
    2 Votes

    SSAS Tabular Cube- Error While Processing SQL Server Agent Job

    SQL Server
     > 
    SQL Server Analysis Services
    </Messages></root></return>.  The step failed. The script i use to run the SQL Server Agent job is this:  {   ...
    Proposed | 4 Replies | 557 Views | Created by ShyamReddy - Monday, December 9, 2019 5:36 PM | Last reply by ShyamReddy - Thursday, December 12, 2019 5:10 PM
  • large check mark
    0 Votes

    Full Cube Process Script sets Attribute to "Unknown" and when i do a process full on dimension attribute afterwards the attribute is correct

    SQL Server
     > 
    SQL Server Analysis Services
    dimensional process full but it does not seem to work Please help
    Proposed | 10 Replies | 691 Views | Created by Ismailc1 - Thursday, November 14, 2019 9:05 AM | Last reply by Ismailc1 - Wednesday, December 11, 2019 6:27 PM
  • large check mark
    10 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 ...
    Answered | 17 Replies | 1572 Views | Created by OneWithQuestions - Tuesday, November 5, 2019 8:42 PM | Last reply by Bethesda Startup - Wednesday, December 11, 2019 6:21 PM
  • large check mark
    0 Votes

    Using the Calculated function to get a value from a 1:Many relationship

    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 ...
    Unanswered | 3 Replies | 341 Views | Created by J.C.Heich - Tuesday, December 10, 2019 4:13 PM | Last reply by Alexei Stoyanovsky - Wednesday, December 11, 2019 7:36 AM
  • large check mark
    0 Votes

    Troubleshouting/actions when SSAS Tabular during high consumption of CPU

    SQL Server
     > 
    SQL Server Analysis Services
    Hi Experts, I have a ssas tabular model, accessed by the end-users through PBI with live connection with a gateway. This model has been optimized in terms of memory consumption also ...
    Proposed | 2 Replies | 386 Views | Created by Sisal - Monday, December 9, 2019 12:10 PM | Last reply by Alexei Stoyanovsky - Wednesday, December 11, 2019 7:24 AM
  • large check mark
    0 Votes

    Combination of OLS and RLS in SSAS Tabular?

    SQL Server
     > 
    SQL Server Analysis Services
    When having the same user in multiple roles - using both OLS (object-level security) and RLS (row-level security) - the SSAS service will throw the user an error stating that this is not ...
    Answered | 3 Replies | 630 Views | Created by Jonas Kjeldsen - Monday, December 9, 2019 2:06 PM | Last reply by Will_Kong - Wednesday, December 11, 2019 5:28 AM
  • 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 | 5 Replies | 1218 Views | Created by antiwodka - Friday, November 29, 2019 10:48 AM | Last reply by Will_Kong - Tuesday, December 10, 2019 5:43 AM
  • 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 ...
    Proposed | 3 Replies | 608 Views | Created by Ryan AB - Thursday, December 5, 2019 1:30 AM | Last reply by Will_Kong - Tuesday, December 10, 2019 1:20 AM
  • 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 ...
    Proposed | 2 Replies | 590 Views | Created by J.C.Heich - Thursday, December 5, 2019 3:15 PM | Last reply by Alexei Stoyanovsky - Monday, December 9, 2019 8:36 AM
  • large check mark
    0 Votes

    Simple Question

    SQL Server
     > 
    SQL Server Analysis Services
    Hi All Looking to see what this piece of MDX means, as in what is L1 and L2? I get it's the Visit ID from the ...
    Proposed | 1 Replies | 369 Views | Created by andyhutch119 - Monday, December 9, 2019 6:41 AM | Last reply by Alexei Stoyanovsky - Monday, December 9, 2019 8:13 AM
  • 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 | 3 Replies | 701 Views | Created by Kazimcc01 - Thursday, December 5, 2019 11:58 AM | Last reply by Will_Kong - Monday, December 9, 2019 6:06 AM
  • 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 ...
    Proposed | 3 Replies | 702 Views | Created by Yerkhan - Friday, December 6, 2019 8:14 AM | Last reply by Darren Gosbell - Monday, December 9, 2019 5:29 AM
  • large check mark
    0 Votes

    DAX Measure Requirements in tabular model

    SQL Server
     > 
    SQL Server Analysis Services
    selected Order Date and Shipping Date is
    Proposed | 2 Replies | 675 Views | Created by Anil Katabathuni - Friday, December 6, 2019 7:45 AM | Last reply by Will_Kong - Monday, December 9, 2019 3:04 AM
  • large check mark
    0 Votes

    Count of child members is lower than parent

    SQL Server
     > 
    SQL Server Analysis Services
    Hello,  I have a problem creating an hierarchy : I have a distinct count of child members that is lower than distinct count of parent and SSAS does not let me create this ...
    Proposed | 3 Replies | 768 Views | Created by Aidana07 - Friday, December 6, 2019 10:25 AM | Last reply by Will_Kong - Monday, December 9, 2019 2:25 AM
  • Items 1 to 20 of 42797 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

 
© 2019 Microsoft. All rights reserved.
Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback