SQL Server Analysis Services announcement
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesAre you a technology guru? Show us your solutions and become the Analysis Services Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert or authority on SQL Server Analysis ...
-
Answered0VotesSlow SSRS Query when Aggregates are Added
We use SSRS against SSAS heavily and I try to keep all SSRS datasets using the graphical query designer to keep the technical bar low for power users. I am well versed in MDX and have been ... -
Unanswered0VotesCalculate Running Total (showing wrong value when selecting only 2 month in excel)
Hello, I'm trying to calculate a running total with the following statement: WITH MEMBER [Measures].[Sum from ... -
Answered2VotesDoes Slowly Changing Dimension Wizard in SSIS 2008 work with SSAS 2008?
So I am working on my second cube. In the first I used a naturally occuring key to link my dimensions and fact tables together. For my second cube, I am trying to develop more ... -
Unanswered0VotesHelp with custom MDX query in Report Builder
Im trying to create a simple report that will display sales for the previous day in one column and YTD sales in the other column. Seems like a very simple concept. Yesterday the report ... -
Unanswered0VotesParent-child duplicate rows
Hi All. As you can see in the picture red boxes, those values are duplicated. It should only show in the level. for example: "b-resultado ordinario" is ... -
Answered1VotesCount Customers by Sales
=250000,1,0)) If I pull in the customer ID into the rows of the pivot table, the calculated member will correctly flag any customer IDs that have sales in excess of $250,000. However, ... -
Unanswered0VotesAnalysis Services Security / Limit Access
Hi! I have 1 cube with a security role allowing Active Directory group "my group". Users usually access data through ... -
Proposed0VotesMax Memory for Sql Server 2012 ( Standard ) + Analysis on same server
I know the maximum memory for SQL Server database Standard is 64 GB RAM. I have a Standard Version (2012), What is the maximum memory I can use for Both SQL Server Analysis and SQL ... -
Unanswered0VotesUsage Based Optimization-Aggregations
Hello Friends, Why we go for Usage Based Optimization Wizard while we have Normal Aggregation Design? What is the main advantage of UBO ... -
Unanswered0VotesBI Environment Considerations
Hi! I currently having my entire Bi stack (SSIS, SSRS, SSAS and DW) on one server. I´m looking into setting up a new environment and have a couple of ... -
Unanswered0VotesOn random day processing is taking long to complete
Hi, I'm facing a weired issue on production server where on some random day processing takes long to complete the processing. Usually cube processing takes 10 mints, but on some ... -
Unanswered0VotesWhy doesn't SSAS store intermediate aggregates of parent-child hierarchies
I am probably just missing something here, but I've read a couple places now that SSAS does not store aggregates except for the leaf level and the All level of parent-child hierarchies and that they ... -
Answered0VotesMDX Script
Hi I am trying to get an MDX script. when [Count] < 2 then ... -
Answered0VotesFinding foreign key relationships via AMO
a.Type = Type.Granularity) .Single() from this, I can find the columns via keyAttrib.Attribute.KeyColumns which have TableID and ... -
Unanswered0VotesDistinct count measure Funny output
I created a measure with distinct count on one of the column of fact table. I get count as 776 whereas it should be in millions. Can someone ... -
Answered0VotesReferenced Dimension, Many-to-Many Relationship, or something else?
My question would be easily understood if there was an accompanying diagram, but unfortunately I don’t know how to upload pictures here. Well – I will try my best to explain my ... -
Unanswered0VotesMDX filter empty date value
Hi all, I hope you can help. I have a dim.date and fact.sales table. the link field in the fact table it´s creation ... -
Unanswered0VotesPublishing an Excel workbook connected to a SSAS Tabular model
Hi, I need to know if it is enough to have SharePoint Server 2010 + Excel Services to publish an Excel workbook that points to Tabular model, without installing PowerPivot for ... -
Unanswered0VotesMDX Query for Min,Max and Median
Hi BI Gurus, Just Now Stepping in to the unknown world of SSAS and just 30 days of theoritical training.I had build a Cube which holds metrics values as measures(SUM) linked to ... -
Unanswered0VotesSSAS With ASP.Net Application
Hi, I created a SSAS project....it is deployed and processed successfully, then i browsed it every thing is successful....End user checked the reports by ... - Items 1 to 20 of 31312 Next ›


