SQL Server Analysis Services announcement
-
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about July 2017 competition:
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...
-
0 Votes
Analysis services processing task buggy?
Hi all, Whenever I use the analysis services processing task after I did some changes to the cube, I had to remove and add all dimensions/measure groups ...Unanswered | 1 Replies | 57 Views | Created by YvesEnfoVl - 18 hours 45 minutes ago | Last reply by willson yuan - 1 hour 17 minutes ago -
1 Votes
MDX: Sum of amount from Start to End
Hello All, I have a date dimension that has data at the year and month level. [Measures].[Amount] is the SUM of the amounts from the fact table. I have ...Answered | 2 Replies | 40 Views | Created by Itz Shailesh - 7 hours 1 minutes ago | Last reply by Itz Shailesh - 5 hours 52 minutes ago -
1 Votes
Best practice for operational reporting on sql server 2012
stored procedure --> SSRS --> Web reports. For a small change in business structure needs update in all 30 stored procedure and which is painful. Just wanted to know ...Answered | 2 Replies | 53 Views | Created by Roshan_123 - Wednesday, July 19, 2017 9:30 PM | Last reply by Roshan_123 - 10 hours 41 minutes ago -
0 Votes
Sorting day of years name
I have a dimension date with day Name column(01-Jan,02-Jan,...,31-Dec) and a Day of year column (1,2,3,4,...365/366) I want to display a colum day (366 day ...Proposed | 3 Replies | 68 Views | Created by LeoRog - Wednesday, July 19, 2017 4:08 PM | Last reply by LeoRog - 11 hours 25 minutes ago -
0 Votes
MDX Scope with time hierarchy
Semester-->Trimester-->Month (The Month key is YYYYMM). I have some attributes such as the month name. When I display my calculated ... -
0 Votes
MDX works correctly on SQL 2008R2 but does not work at all on SQL 2016
Hi colleagues! We have been run into issue after migration from SQL 2008R2 to SQL 2016. Our reporting application (Tableau) generates MDX queries wich we can not affect on. But in ... -
0 Votes
modeling surveys in tabular
Hi we run 2012 enterprise. We are thinking about modeling our survey data in tabular. The core columns are question, answer, survey, date, person, account. I think ...Answered | 3 Replies | 52 Views | Created by db042190 - Wednesday, July 19, 2017 11:15 AM | Last reply by db042190 - 15 hours 46 minutes ago -
1 Votes
Two Attributes used at a time should be null
Hello All, Am having two attributes say a and b from two different dimensions A and B respectively. So in general the cube should not give any result when both the ...Unanswered | 5 Replies | 69 Views | Created by Bharath_RAM - 22 hours 19 minutes ago | Last reply by Darren Gosbell - 17 hours 36 minutes ago -
0 Votes
Date Range Filter in MDX
Hi, I have a dimension, lets call it DIM_A, DIM_A has the following attributes and sample data like ...Answered | 5 Replies | 106 Views | Created by Aka_Maddy - Monday, July 17, 2017 6:50 PM | Last reply by willson yuan - 19 hours 42 minutes ago -
1 Votes
is sql server 2014 with tabular model compatible with VS 2015
hi all, i'm having SQL SERVER 2014 with tabular model installed in my system & VS 2015. while i'm developing a tabular model project in Analysis services i faced ...Answered | 3 Replies | 67 Views | Created by LuckyLucky12 - Tuesday, July 18, 2017 12:58 PM | Last reply by LuckyLucky12 - 20 hours 7 minutes ago -
0 Votes
SSAS 2016 Tabular Visual Studio 2015 Design Performance
Hey Everyone, I'm trying to add some new features to our 2016 SSAS Tabular model and the design process is torture. Everything is slow. To start the ...Unanswered | 3 Replies | 73 Views | Created by David.Squires - Tuesday, July 18, 2017 3:44 PM | Last reply by willson yuan - 20 hours 8 minutes ago -
0 Votes
Microsoft Access Database Engine 2010 Redistributable not found on local machine”
Am trying to import excel 2016 files from network drive but an getting “Microsoft Access Database Engine 2010 Redistributable not found on local machine" error ,.. which i ...Unanswered | 3 Replies | 59 Views | Created by Kosambi2212 - Tuesday, July 18, 2017 9:26 PM | Last reply by willson yuan - 20 hours 17 minutes ago -
0 Votes
cant connect remotely ssas
Hi experts, I can’t connect remotely to my SSAS, I created manually the inbound: ...Proposed | 2 Replies | 48 Views | Created by maca128 - Wednesday, July 19, 2017 3:42 PM | Last reply by willson yuan - 20 hours 37 minutes ago -
0 Votes
MDX Pivot to Table View
Hi All, Wonder if you could help me please. i'm stuck on following MDX Query to show me in Table (Tabular) Format, so that i can calculate duration between Legs of the ...Unanswered | 1 Replies | 33 Views | Created by Alan Aung - Wednesday, July 19, 2017 1:46 PM | Last reply by willson yuan - 23 hours 41 minutes ago -
0 Votes
Incorrect Total for Cumulative Measure When Multiple Years Are Selected
Hi, We are using below MDX for calculating Cumulative value. It is working fine when one year is selected. But when we select multiple years as filter, grand ...Proposed | 5 Replies | 72 Views | Created by SriniNag - Wednesday, July 19, 2017 10:48 AM | Last reply by willson yuan - Thursday, July 20, 2017 2:01 AM -
1 Votes
MDX Dimension Filter based on Dimension Attribute
I am having difficulty with an MDX query. It has been a while since I worked with MDX and while this seems so simple I am having difficulty figuring out what I am doing wrong. I have a ...Answered | 2 Replies | 44 Views | Created by Matt Karriker - Wednesday, July 19, 2017 2:14 PM | Last reply by Matt Karriker - Wednesday, July 19, 2017 4:18 PM -
1 Votes
Using Annotations in SSAS cubes
When we connect to a cube and browse the cube through an Excel pivot , we can see a brief description field while hovering over a certain cell of data. The attached image shows the same where it ...Discussion | 2 Replies | 61 Views | Created by SuryaBose - Tuesday, July 18, 2017 11:47 AM | Last reply by SuryaBose - Wednesday, July 19, 2017 12:06 PM -
0 Votes
MDX query - 2 hierarchy levels on 1 axis
I'm trying to write a basic query with 2 different levels of a hierachy displayed on 1 axis. SELECT { [Date].[Calendar].[Year].&[2013] } ON COLUMNS ...Answered | 7 Replies | 4335 Views | Created by Lee Hawthorn - Thursday, February 21, 2013 9:24 AM | Last reply by Dhir_Mehta - Wednesday, July 19, 2017 11:17 AM -
0 Votes
SSAS ROLAP Cube Sync
I can Sync between default instance , but when i use Named instance I get the below error , Can guide why We could not ...Answered | 4 Replies | 81 Views | Created by Moug45 - Tuesday, July 18, 2017 10:11 AM | Last reply by Moug45 - Wednesday, July 19, 2017 9:04 AM -
0 Votes
Row level security using AD Groups
I am trying to implement row level security for the cube and I created a bridge table and also users table. I am able to do this at user level. But when I try to do the same using AD Groups it is not ...Answered | 11 Replies | 120 Views | Created by SSRSBI - Monday, July 17, 2017 9:12 PM | Last reply by yger - Wednesday, July 19, 2017 8:20 AM - Items 1 to 20 of 39898 Next ›
