SQL Server Analysis Services announcement
-
0 Votes
Filtering DAX Function Tabular Model SSAS
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 -
0 Votes
Get the month number from datetime in MDX query
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 -
0 Votes
How to put Asterisk (*) in format_string to have it working in excel (for right text alignment)
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 -
0 Votes
Measure location for query-generated SSAS tabular calculated table
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 -
0 Votes
Data Mining - Cube & Cuboids
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 -
0 Votes
SSAS error 3238002688: internal error while processing!
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 -
2 Votes
SSAS Tabular Cube- Error While Processing SQL Server Agent Job
</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 -
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
dimensional process full but it does not seem to work Please helpProposed | 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 -
10 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 ...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 -
0 Votes
Using the Calculated function to get a value from a 1:Many relationship
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 -
0 Votes
Troubleshouting/actions when SSAS Tabular during high consumption of CPU
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 -
0 Votes
Combination of OLS and RLS in SSAS Tabular?
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 -
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 | 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 -
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 ...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 -
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 ...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 -
0 Votes
Simple Question
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 -
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 | 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 -
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 ...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 -
0 Votes
DAX Measure Requirements in tabular model
selected Order Date and Shipping Date isProposed | 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 -
0 Votes
Count of child members is lower than parent
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 ›