SQL Server Analysis Services announcement
-
0 Votescalculated measure = sum of a row level number divided by sum of a summary row level number
Hi , I just set up an ssas (2017 std) server and deployed a tabular model from vs2019. Long term I wont be doing this but for the time being my fact table looks like what's in the code block and ...Proposed | 13 Replies | 273 Views | Created by db042190 - Thursday, October 17, 2019 2:04 PM | Last reply by Will_Kong - 15 minutes ago
-
2 Votes
How to get the ssas work properly in ssms?
I have sql server2014, When I open ssms, I can see ssas and ssrs and so on... The ssrs works well, But ssas etc. can not be operated because the server was not runing. If I want to ...Proposed | 9 Replies | 86 Views | Created by zhgart - 17 hours 19 minutes ago | Last reply by Will_Kong - 41 minutes ago -
0 Votes
memory exception when deploying tabular - doesnt jive with what resources are available
Hi I'm reading marco's article at https://www.sqlbi.com/articles/memory-settings-in-tabular-instances-of-analysis-services/. I'm assuming the vertipaq memory limit i see in the ssas ...Unanswered | 5 Replies | 80 Views | Created by db042190 - 16 hours 12 minutes ago | Last reply by Will_Kong - 53 minutes ago -
0 Votes
Multiple target environments/Configurations for Data Source View
Hello, I have a multidimensional SSAS Visual Studio solution. I have 3 target environments: DEV, UAT, and PROD. The Data Source (DS) handles ...Proposed | 1 Replies | 37 Views | Created by Pragmateek - 13 hours 34 minutes ago | Last reply by Will_Kong - 1 hour 32 minutes ago -
0 Votes
SSAS MD 2017 (latest SP) -- deploy MDX script only
hello folks, I was wondering if it is possible to only deploy MDX script changes, in an otherwise fairly complex cube, without deploying measure groups and all other ...Unanswered | 1 Replies | 232 Views | Created by Cos2008 - 11 hours 17 minutes ago | Last reply by Will_Kong - 4 hours 8 minutes ago -
0 Votes
SSAS 2019 Deploy Error
server (computername/instances) This is my first SSAS practical and I'm stressed to deploy it. Building the project doesn't provided error(s) only when deploying it. If someone can remote my ...Unanswered | 1 Replies | 49 Views | Created by okatokat - 8 hours 1 minutes ago | Last reply by Will_Kong - 5 hours 41 minutes ago -
0 Votes
SSAS Tabular Model Processing Error
Hi, I'm trying to process my analysis services tabular model in Visual Studio, but I got: Error: Method not found: ...Unanswered | 6 Replies | 376 Views | Created by Leo Sugianto - Thursday, September 26, 2019 4:01 AM | Last reply by Leo Sugianto - 12 hours 15 minutes ago -
0 Votes
Calculate distinct Customers who purchased a product
I need to calculate the distinct number of customers who purchased a product. I have a Customer table with CutomerKey, Cutomer Name Product ...Answered | 1 Replies | 45 Views | Created by jschroeder - 15 hours 10 minutes ago | Last reply by jschroeder - 14 hours 48 minutes ago -
0 Votes
MDX total aggregation (sum) doesn't update when filtering
Hello, I cannot resolve a problem that is caused by incorrect aggregation on Year level. In below table there are ...Answered | 4 Replies | 164 Views | Created by ziembol1977 - Friday, October 18, 2019 9:35 AM | Last reply by ziembol1977 - 22 hours 15 minutes ago -
0 Votes
SSAS Dimension is taking way too long to process, and never finishing!
Keyword: using a "NameColumn" of type string and of size NVARCHAR(125)). the "KeyColumns" is an INT (KeywordID). > IsBrand: using a "KeyColumns" of type ...Answered | 9 Replies | 9856 Views | Created by ToO_sIK - Thursday, May 31, 2012 11:17 AM | Last reply by Shivendoo Kumar Dubey - Monday, October 21, 2019 6:47 AM -
0 Votes
Two mdx measures depending of each other
100 , avg ( [Date].[Calendar].PrevMember.Lag(99) : [Date].[Calendar].PrevMember, [Measures].[EBT] ), NULL ) The second is also depending of ...Proposed | 2 Replies | 193 Views | Created by SniperPro - Tuesday, October 15, 2019 9:21 AM | Last reply by Will_Kong - Monday, October 21, 2019 6:42 AM -
0 Votes
ssas tabular model probleam
how to create many to many relation ship in tabular modelProposed | 4 Replies | 199 Views | Created by balu9309 - Monday, October 14, 2019 8:03 AM | Last reply by Will_Kong - Monday, October 21, 2019 6:38 AM -
0 Votes
ssas tabular model
how many types of cubes in ssas tabular modelProposed | 2 Replies | 187 Views | Created by balu9309 - Monday, October 14, 2019 8:37 AM | Last reply by Will_Kong - Monday, October 21, 2019 6:37 AM -
0 Votes
ssas tabular model
IN a cube 10 tables i want refresh only 5 tables its possible? if possible how to processProposed | 2 Replies | 171 Views | Created by balu9309 - Monday, October 14, 2019 8:39 AM | Last reply by Will_Kong - Monday, October 21, 2019 6:36 AM -
0 Votes
Executing multiple procedures in sequence with batch process
Currently, the batch below is using the parallel process to execute the procedures. I am trying to find a way to process them sequentially - one after the other - and not ...Proposed | 3 Replies | 206 Views | Created by Sreeprasad K S - Monday, October 14, 2019 11:01 AM | Last reply by Will_Kong - Monday, October 21, 2019 6:33 AM -
0 Votes
dax find previous round value
hello... I have a ...Proposed | 2 Replies | 222 Views | Created by radissoufan - Sunday, October 13, 2019 5:47 PM | Last reply by Will_Kong - Monday, October 21, 2019 6:28 AM -
0 Votes
How to create a new calculated column in Excel - Getting data from SSAS model into an excel tabular form
0,PO[Record Date] ) Question about amendment date: What is the best way for doing this kind of calculations? Notice that ...Proposed | 2 Replies | 456 Views | Created by ssas_learning - Thursday, October 10, 2019 5:43 PM | Last reply by Will_Kong - Monday, October 21, 2019 6:26 AM -
0 Votes
How to use OR filters for getting data from an SSAS model into an excel tabular form
We are loading data from an SSAS model into an excel tabular form. The data within the spreadsheet needs to be shown using 2 conditions in OR way, I mean, I have 2 fields coming from the ...Proposed | 2 Replies | 262 Views | Created by ssas_learning - Thursday, October 10, 2019 6:32 PM | Last reply by Will_Kong - Monday, October 21, 2019 6:24 AM -
0 Votes
xmla to add <orderbyattributeid> for an attribute
Hello, I've imported PowerPivot db with model using ssms and want to create and test xmla query to set column sort by other column. When succeed I plan to apply that in Excel ...Unanswered | 3 Replies | 160 Views | Created by Alexander Israel - Thursday, October 17, 2019 1:10 PM | Last reply by Will_Kong - Monday, October 21, 2019 6:08 AM -
0 Votes
Table-level security in a relationship chain
Hi According to the documentation "Table-level security cannot be set for a model if it breaks a relationship chain. An error is generated at design time. For ...Proposed | 2 Replies | 148 Views | Created by Cisab - Friday, October 18, 2019 1:15 PM | Last reply by Will_Kong - Monday, October 21, 2019 2:36 AM - Items 1 to 20 of 42673 Next ›
