SQL Server Analysis Services announcement
-
0 VotesError deploying SSAS cubo
Hi, everyone. I'm facing a issue when a try to deploy a SSAS project. See the messages ...
-
0 Votes
SQL 2014 OLAP Cube - Dimensional Attribute Writeback
Hi, I have a SSAS cube presented in Excel, I need to add a action comment field/attribute to be populated in cube/pivot please help on setting this up, ...Unanswered | 3 Replies | 192 Views | Created by Ismailc1 - Tuesday, December 24, 2019 3:05 PM | Last reply by Ismailc1 - 13 hours 3 minutes ago -
0 Votes
In Multidimensional model, is the data pre-aggregated for all the dimensions and store that data in a Cube?
Hello Everyone, Consider, the below ...Unanswered | 0 Replies | 46 Views | Created by 00000000-0000-0000-0000-000000000000 - 13 hours 22 minutes ago -
0 Votes
Can we do transformation in Multidimensional Model?
Hello Everyone, I am new in Multidimensional model. But, I am familiar with Tabular model. We can perform transformation like calculated columns and filtering the ... -
0 Votes
MDX Dynamic dimension filter based on value of other dimension
How can I filter using values from two dimension in MDX? The required result should include records where [Purchase Date].[Date] is before today minus number of years ...Unanswered | 2 Replies | 181 Views | Created by Fenix Z - Tuesday, December 24, 2019 2:02 PM | Last reply by Fenix Z - 14 hours 12 minutes ago -
2 Votes
Filter a tabular cube to have only rolling last 24 months of data only
Hi, I have a report sitting on a tabular cube and its pretty slow because of a very large fact table (data from last 10 years). I want to create a new cube with ...Answered | 6 Replies | 632 Views | Created by Jennifer Zen - Thursday, December 19, 2019 1:49 PM | Last reply by Jennifer Zen - Friday, December 27, 2019 9:46 AM -
0 Votes
Adding new multiple measures under existing measure group in single go ?
Hi, I'm trying to add new measures under the existing measure group using SSDT/BIDS. Measure is already exist on the table in the in relational database and now ...Unanswered | 2 Replies | 430 Views | Created by DhoriAlpesh - Tuesday, December 24, 2019 12:55 PM | Last reply by DhoriAlpesh - Thursday, December 26, 2019 5:48 AM -
0 Votes
SSAS Tabular Model 1103 unable to connect MSDASQL provider for Hana Database
Hi, I am working on connecting a hana database through SSAS Tabular Model of 1103 compatibility level from SSDT version 10. Test connection works fine with the following ...Unanswered | 5 Replies | 216 Views | Created by Vaishali Singh - Tuesday, December 24, 2019 6:33 AM | Last reply by Will_Kong - Thursday, December 26, 2019 5:32 AM -
0 Votes
Problem summarizing totals for a calculated measure
Hello! We are having some trouble with the totals for a calculated measure at some hierarchies's attributes. This is the MDX of the calculated ...Unanswered | 6 Replies | 512 Views | Created by Paco Rodriguez M - Wednesday, December 18, 2019 6:58 AM | Last reply by Will_Kong - Thursday, December 26, 2019 2:36 AM -
3 Votes
SSAS 2008 taking all server memory
We just upgraded to SSAS 2008 64 bit (and windows 2008 R2) a couple of weeks ago and now we have an issue that I can't seem to figure out. Our cubes have not changed at all. ...Answered | 6 Replies | 9602 Views | Created by William Lowers - Sunday, September 26, 2010 9:38 PM | Last reply by Ann-Roden - Wednesday, December 25, 2019 10:12 AM -
1 Votes
Filter Attribute in Dimension Hierarchy
Hello, There is a cube "Plankosten" with a dimension hierarchy "Kostengruppe" with 4 levels from KSTGRP01 down to KSTGRP04. Now i need to ...Answered | 6 Replies | 580 Views | Created by Wolf_108 - Wednesday, December 18, 2019 4:24 PM | Last reply by Will_Kong - Tuesday, December 24, 2019 6:03 AM -
0 Votes
Compress old Measure Group Partitions
Hi, I need to compress the old partitions of for the Measure Groups of my cube, as the size is continiously getting increased. Anyone please guide me on ...Proposed | 5 Replies | 718 Views | Created by Payel Saha - Monday, December 16, 2019 1:49 PM | Last reply by Will_Kong - Tuesday, December 24, 2019 5:56 AM -
0 Votes
Problem in processing tabular model table in SQL Server
We are using SQL server Management Studio 17.1 and Visual Studio 2015 for deploying and processing the tabular model. We are able to deploy and process cube in Visual Studio but while processing model ...Proposed | 3 Replies | 1643 Views | Created by anonymouswws - Monday, July 17, 2017 10:43 AM | Last reply by mcooper89 - Monday, December 23, 2019 8:06 PM -
0 Votes
SSAS Cube - Exclude values from distinct count measure conditionally
DISTINCT COUNT(InvestorID) it is still including the InvestorID of Inv2 when we query against dimREGION. I have tried many ways like FILTER, SCOPE, changing the ...Proposed | 3 Replies | 455 Views | Created by Ashu_Blueray - Thursday, December 19, 2019 5:37 PM | Last reply by Will_Kong - Monday, December 23, 2019 7:42 AM -
0 Votes
Looking for a ssas developer urgently
Hi everyone I'm looking for a ssas developer for a user segmentation the work is remunated Please let me know if you are interested MarieProposed | 2 Replies | 529 Views | Created by MarieNtiru - Saturday, December 21, 2019 9:13 PM | Last reply by Vaibhav-Chaudhari - Monday, December 23, 2019 5:17 AM -
0 Votes
Connection failure - The JSON DDL request failed with the following error: Failed to execute XMLA
We are facing huge issue after deployment of xmla code. XMLA code deployment is fine. After that we are refreshing msdax. When we do we are getting below error: The JSON DDL ...Unanswered | 3 Replies | 307 Views | Created by kdinuk - Friday, December 20, 2019 2:37 AM | Last reply by Will_Kong - Monday, December 23, 2019 2:55 AM -
0 Votes
SCD type 2
How do we find record that yesterday date using SQL Query SCD type 2?Proposed | 2 Replies | 504 Views | Created by gaan - Friday, December 20, 2019 6:42 PM | Last reply by Will_Kong - Monday, December 23, 2019 2:40 AM -
0 Votes
How could I use AWS S3 as a datasource to on-premise SSAS (Tabular)?
We tried importing Snowflake data into SSAS Tabular (through ODBC) and the performance is just atrocious, unusable. Someone suggested dumping the data from Snowflake to S3, and then ...Discussion | 1 Replies | 922 Views | Created by EricLeBouffon - Friday, November 29, 2019 10:01 AM | Last reply by BrunoSat - Sunday, December 22, 2019 3:16 AM -
0 Votes
Unable to start SQL Server Analysis Services
Hi all, As per issue title, suddenly I'm unable to start SQL Server Analysis Services. This isn't the case when I was able to do so earlier this year. I tried to ...Proposed | 5 Replies | 529 Views | Created by Lim Yea Han - Tuesday, December 17, 2019 3:15 AM | Last reply by Darren Gosbell - Friday, December 20, 2019 8:34 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 ...Proposed | 5 Replies | 760 Views | Created by sergey vdovin (aka evolex) - Thursday, December 12, 2019 4:50 PM | Last reply by Lukas DreiKlein - Friday, December 20, 2019 8:43 AM - Items 1 to 20 of 42820 Next ›
