SQL Server Analysis Services announcement
-
1 VotesWho will be announced as the next SSAS Guru? Read more about April 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...
-
0 Votes
DAX Multiple LOOKUPVALUE
Hi, I have measure table where is stored information about Cities (Let's call table Cities). I need to create configuration table (Let's call table Conf_roles) where is stored ... -
3 Votes
PROTECTIONLEVEL property not recognised
Hi all, I am hoping someone can help me, I am connect to AS over https in C#. Here is my connection string: "Data Source=https://EXAMPLE.CO.UK/msmdpump.dll; ...Answered | 5 Replies | 68 Views | Created by JoeyStyles - Monday, April 23, 2018 12:01 PM | Last reply by JoeyStyles - 1 hour 31 minutes ago -
0 Votes
Cannot connect to the cube after making changes to the dimension
Hi Experts, I have a cube with multiple dimensions one of which is Date, like below: But my ...Answered | 5 Replies | 46 Views | Created by Aditya1789 - 6 hours 38 minutes ago | Last reply by willson yuan - 3 hours 44 minutes ago -
0 Votes
creating DateTime dimension attribute to control 15 weeks
Hi, Is there a way to create attribute under DateTime dimension to control only top 15 weeks? My requirement is to allow user to see the selected measures value ...Proposed | 6 Replies | 181 Views | Created by MSRN - Saturday, April 14, 2018 1:36 AM | Last reply by willson yuan - 4 hours 46 minutes ago -
0 Votes
Using multivalued parameters from tabular model in SSRS
I am trying to create a report using MDX. The query contains two columns and a measure, and two filters to slice the data. When i run it in query designer browser by placing the hardcoded filters I ...Unanswered | 1 Replies | 23 Views | Created by Neil037 - 8 hours 0 minutes ago | Last reply by willson yuan - 5 hours 12 minutes ago -
2 Votes
Error message: Excel allows only one filtering path between tables in a data model
Hi, Could you please help me with the following error message. I built a simple PowerBI model consisting of 4 tables. This model works fine in the PowerBI ...Answered | 8 Replies | 1760 Views | Created by ssolovei - Tuesday, January 17, 2017 3:30 PM | Last reply by S Kumar Dubey - 6 hours 48 minutes ago -
0 Votes
Row_Number
Hi I have following SQL query and result of the same is shown in the snapshot attached. I want to write DAX to get output like column name "Result". your assistance would ...Unanswered | 8 Replies | 111 Views | Created by Arnav1210 - Sunday, April 22, 2018 7:40 PM | Last reply by Darren Gosbell - 6 hours 51 minutes ago -
0 Votes
SSAS 2017 error while processing full
Hello, This is under SQL Server 2017 with CU6, getting below error while doing processing full on a tabular model partition: 'An unexpected error occurred (file ...Unanswered | 1 Replies | 54 Views | Created by icefishing - 22 hours 20 minutes ago | Last reply by willson yuan - 9 hours 26 minutes ago -
0 Votes
MSSQL 2014 SP2 CU10 fix of KB4057307 - Does CU11 fix M2M Cache issue?
Hello, I am looking to get official confirmation from Microsoft on whether or not CU11 update fixes the following issue: There is an issue in MSSQL 2014 ...Unanswered | 1 Replies | 71 Views | Created by calleking - Monday, April 23, 2018 6:46 AM | Last reply by willson yuan - 9 hours 46 minutes ago -
1 Votes
Tabular model with table sourced in Excel file living on Sharepoint - how best to automatically re-process that table?
Hi all, I plan to attach an excel file to my tabular model - a sheet of stuff I want the end user to be able to add to or update as needed. I assume every time a ...Proposed | 3 Replies | 73 Views | Created by sherifffruitfly2 - Sunday, April 22, 2018 11:30 PM | Last reply by willson yuan - 9 hours 48 minutes ago -
0 Votes
MDX Filter Hierarchy On MEMBER_CAPTION
0 ) } ON 1 FROM [CashFlow] WHERE ( [Value Date].[Value Date].&[2018-04-13T00:00:00] ) Below are the properties of the row when I run below ...Proposed | 7 Replies | 115 Views | Created by GURSETHI - Friday, April 20, 2018 6:06 AM | Last reply by willson yuan - 10 hours 37 minutes ago -
0 Votes
YTD with Calendar Hierachy not calculating correctly at Month & Quarter
We are implementing the usual time calculation dimension to allow us to have different time dependent calculations of measures. We have created a "Financial YTD" ... -
0 Votes
Dimension member 13 month sum
I'm trying to do a calculated member that is the sum of the last 13 months for whatever measure. I've tried this: MEMBER [Product Post Date].[Calendar].[13thMonth] ...Answered | 7 Replies | 103 Views | Created by Judy Way - Wednesday, April 18, 2018 4:51 PM | Last reply by Judy Way - 21 hours 13 minutes ago -
0 Votes
Cube Partitioning by Year and month in SSAS 2008 R2
Hi there, I need to make partitions by year and month in a SSAS cube to improve the performance. Please let me know the ...Answered | 18 Replies | 12432 Views | Created by Palash Aich - Friday, November 12, 2010 5:12 PM | Last reply by SSASDeveloper - 21 hours 37 minutes ago -
0 Votes
Prior Year Calculation Issue (when filtering for current year)
We have created a (Same Period) Prior Year calculation in our cube (MDX below) CREATE MEMBER CURRENTCUBE.[Measures].[Target Fees Prior FY] AS ...Proposed | 2 Replies | 91 Views | Created by MattA45 - Tuesday, April 17, 2018 8:39 AM | Last reply by MattEvans205GTI - Monday, April 23, 2018 12:40 PM -
0 Votes
SSAS Error: method not found: 'Boolean Microsoft.AnalysisServices.AdomdConnection StringBuilder.Is Azure()
Hi, When I execute an SSIS package that updates an SSAS Tabular Model via Visual Studio 2017 everything is fine. When I run the same package using SQL Server ...Unanswered | 1 Replies | 82 Views | Created by SharonDv - Saturday, April 21, 2018 7:52 PM | Last reply by willson yuan - Monday, April 23, 2018 11:59 AM -
0 Votes
Error Deploying SSAS Cube locally
Mornng, I receive this error when I attempt to deploy my cube locally from visual studio 2017: Severity Code Description ...Proposed | 3 Replies | 102 Views | Created by ElliotP123 - Saturday, April 21, 2018 11:22 PM | Last reply by willson yuan - Monday, April 23, 2018 5:32 AM -
0 Votes
DAX
Hi I have following DAX, I am planning use this DAX in Power BI to generate report output. Here in DAX, I am passing Year=2017 but if I want to pass 2 years like 2017, 2018 ...Answered | 3 Replies | 81 Views | Created by Arnav1210 - Friday, April 20, 2018 3:07 PM | Last reply by willson yuan - Monday, April 23, 2018 3:05 AM -
0 Votes
Is it possible to connect to SSAS via Excel Connection String when Computer is on a different domain?
Basically we are moving customer's SQL server to Azure and they are getting rid of all their servers. They don't want to do VPN, but probably will have to if there is no good way to do ...Proposed | 2 Replies | 60 Views | Created by JZap - Friday, April 20, 2018 12:49 PM | Last reply by willson yuan - Monday, April 23, 2018 1:50 AM -
0 Votes
Cube not showing up when opening a solution
Hi, I have a solution folder which contain 3 cubes. When I open the solution I am only seeing 2 cubes, Not sure why the third cube is not showing up. Can you please let me know what ...Answered | 2 Replies | 80 Views | Created by susheel1347 - Friday, April 20, 2018 11:52 PM | Last reply by Darren Gosbell - Sunday, April 22, 2018 9:16 PM - Items 1 to 20 of 41077 Next ›
