SQL Server Analysis Services announcement
-
0 Voteshow to perform partial cube processing without losing data.
Hi All, I have cube where measure groups are partitioned into 2 partition for different time frame as below: 1. latest 2 years data ( PRT_DATA_2YEARS ...Unanswered | 9 Replies | 346 Views | Created by ScriptSoft - Friday, January 17, 2020 9:12 AM | Last reply by ScriptSoft - 27 minutes ago
-
0 Votes
MDX row level calculation
Hi Everyone, I have an MDX related issue which I cannot find a solution to and am hoping that someone here can help me (I'm quite new to MDX BTW). I have a measure group with 2 ... -
0 Votes
Connect from IIS (BASIC Authentication) to SSAS failed
Hello I am trying to connect to SSAS from IIS located in another domain I defined one connection using MSMDPUMP without ...Unanswered | 3 Replies | 160 Views | Created by Capitantrueno - Thursday, January 23, 2020 5:29 PM | Last reply by yger - 14 hours 58 minutes ago -
0 Votes
user is in reader role but all he sees is empty databases folder
Hi. We have a couple of ssas 14.0.239.1 tabular models as shown in figure 1. I added a role to tabular 3 called user and added my user to the role. When he uses ssms from his pc to reach the tabular ...Unanswered | 4 Replies | 161 Views | Created by db042190 - Friday, January 24, 2020 5:33 PM | Last reply by db042190 - 16 hours 29 minutes ago -
0 Votes
SSAS Extended Events - CPU Time vs Duration
What exactly is the difference between CPU Time and Duration in the extended events. I see a lot of cases where CPU Time shows up as say 130 ms and Duration shows up as 4100 ...Answered | 3 Replies | 91 Views | Created by VivDev - Monday, January 27, 2020 3:54 PM | Last reply by Darren Gosbell - Tuesday, January 28, 2020 2:11 AM -
0 Votes
SSAS Common Dimension Processing
Hi Experts, I have 3 Cubes, all in different solution (SSAS Multi Dimension) and are live on production. All 3 Cubes have 10 Dimension in Common Plus Every ...Unanswered | 2 Replies | 74 Views | Created by MS308 - Monday, January 27, 2020 7:28 AM | Last reply by Darren Gosbell - Tuesday, January 28, 2020 12:08 AM -
0 Votes
MDX query - how to show values
Hi, I am little bit stuck in my POWER BI report, where I get data from SSAS. My query is quite easy SELECT NON EMPTY { ( [Common ...Unanswered | 3 Replies | 143 Views | Created by volyn - Friday, January 24, 2020 7:26 PM | Last reply by Darren Gosbell - Monday, January 27, 2020 10:47 PM -
0 Votes
SSAS POWER BI SERVICE- Export Limitation
Hi Experts , This Question is related to Power BI (POWER BI SERVICE-PREMIUM) connect "Live Connection" with ...Unanswered | 2 Replies | 160 Views | Created by MS308 - Thursday, January 23, 2020 6:07 AM | Last reply by Darren Gosbell - Monday, January 27, 2020 9:47 PM -
0 Votes
Percentage measure to return an average instead of total
I've got a measure that I'm using in a pbi matrix. Its currently just two values divided by each other giving me a percentage. However in the total column, instead of taking the total of the values ...Answered | 3 Replies | 159 Views | Created by jshinnenkamp - Friday, January 24, 2020 9:24 PM | Last reply by jshinnenkamp - Monday, January 27, 2020 2:52 PM -
0 Votes
Cube processing suddenly failing with timeouts
We have a two cubes that previously had no issues being processed with the full option. Suddenly the cube is now failing with timeouts. I have ...Unanswered | 1 Replies | 204 Views | Created by JLJ1976 - Saturday, January 25, 2020 2:49 PM | Last reply by Lukas DreiKlein - Monday, January 27, 2020 8:11 AM -
0 Votes
Web Based Front End tool for SSAS cube browser
Hi All, Can anyone suggest me the best web based Front End tool for browsing SQL Server Analysis Service cube?? A tool similar to the excel pivot table which ...Answered | 11 Replies | 19705 Views | Created by Rama R - Friday, February 22, 2013 9:45 AM | Last reply by Vitaliy Fedorchenko - Sunday, January 26, 2020 9:21 AM -
1 Votes
Partitioned Fact Table Causing Double Results??
So, we have a tabular model which we want to partition in order to speed up processing. What we're now seeing is somewhat odd. There are three key measures we're looking at: ...Answered | 6 Replies | 219 Views | Created by ansonee - Wednesday, January 22, 2020 9:31 PM | Last reply by ansonee - Friday, January 24, 2020 9:19 PM -
0 Votes
Tabular Models unloading from memory?
So the scenario we have is we have 4 front facing SSAS Tabular servers spread across a number of data centres to help us with worldwide geographic challenges and to provide ...Proposed | 4 Replies | 603 Views | Created by Steve Powell - Thursday, February 21, 2019 4:13 PM | Last reply by zenzeinet - Friday, January 24, 2020 6:09 PM -
0 Votes
SSAS Tabular performance issue with Powerbi
Hello community, My company has just stopped supporting our Cube and we are moving to tabular/Powerbi. I have picked up a relatively small tabular model and i need to Port some MDX ...Unanswered | 1 Replies | 126 Views | Created by BLDataCrank - Friday, January 24, 2020 4:28 AM | Last reply by Will_Kong - Friday, January 24, 2020 8:14 AM -
0 Votes
Issue Processing tabular model through SQL server agent Jobs
Hi, We have oracle DB as datasource. We built tabular model creating oracle as datasource and published to SQL server tabular server. we trying to process the database(Process ...Unanswered | 5 Replies | 810 Views | Created by Raghav1983 - Thursday, October 31, 2019 12:17 PM | Last reply by Karteekk - Thursday, January 23, 2020 6:22 PM -
0 Votes
Issue with Mapping in MDX
Hello All, When am trying to assign a value to a member in one dimension with value assigned to another member from another dimension as ...Unanswered | 3 Replies | 194 Views | Created by Bharath_RAM - Tuesday, January 21, 2020 5:10 PM | Last reply by Alexei Stoyanovsky - Thursday, January 23, 2020 11:51 AM -
0 Votes
converting string date to yyyy-mm-dd
Hi All, I am totally new to these types and queries but forced to figure stuff out on the fly. I wrote the below query the ...Answered | 2 Replies | 193 Views | Created by spittingfire - Wednesday, January 22, 2020 1:09 PM | Last reply by spittingfire - Thursday, January 23, 2020 11:32 AM -
0 Votes
Question regarding SQL Server analysis
If i wish to create a calculated member that intersects all measures ,where i should put it and why ?Unanswered | 2 Replies | 157 Views | Created by Trupti thakur - Wednesday, January 22, 2020 5:59 AM | Last reply by Will_Kong - Thursday, January 23, 2020 2:47 AM -
2 Votes
How to see the existing hierarchies in SSAS Tabular Model
Hello, I can see there are existing hierarchies while browse the cube in SQL Server, where as i am not able to see the same hierarchies in .bml file in visual studio? Can someone ...Proposed | 4 Replies | 271 Views | Created by ShyamReddy - Wednesday, January 15, 2020 9:42 PM | Last reply by ShyamReddy - Wednesday, January 22, 2020 3:30 PM -
0 Votes
MDX Leap year with parallelPeriod
Hello Everyone, I get this MDX query by a predecessor and I think it's not working this year with february. I'm trying to get the sum of "MyNumbers" for the same period ...Unanswered | 3 Replies | 255 Views | Created by Quentin_SQL - Monday, January 20, 2020 10:46 AM | Last reply by Will_Kong - Wednesday, January 22, 2020 2:31 AM - Items 1 to 20 of 42849 Next ›
