Viewing 10 posts - 331 through 340 (of 340 total)
Items like semi-additive measures, perspectives, partitioning, proactive caching, and write back are a few. For more information and details go to the following link and scroll down to the...
October 4, 2008 at 11:43 pm
Take a look at the BOL material http://msdn.microsoft.com/library/ms145989.aspx and you can take a look at downloading the Analysis Service sample database, Adventure Works, here http://www.codeplex.com/SqlServerSamples. They have some examples...
October 3, 2008 at 9:15 am
Don't see anything wrong with your query. I modified it to work against the Adventure Works and it runs without any issues.
WITH SET [OrderedSet] AS
ORDER...
October 2, 2008 at 11:02 pm
If you only have one fact table and both dimensions are related to the fact table then I see no reason why you couldn't do this. Sounds like you...
October 2, 2008 at 10:43 pm
I would recommend checking out all of the content on the Kimball Group's site and also their book The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft...
September 26, 2008 at 6:30 am
You should be able to use the list report item and then drag the chart into the list item. The parameters would be feeding a dataset that would then...
September 24, 2008 at 7:51 pm
There is lots of content all over the Internet in regards to SSAS tutorials and overviews. Here are a few for you to checkout - http://www.accelebrate.com/sql_training/ssas_tutorial.htm or you...
September 24, 2008 at 7:44 pm
It appears that you are missing some curly braces within your crossjoin:
change this section:
non empty({
[first twelve], [Accounting Date].[Month].[Remaining Months]
--* [Procedures].[Billing Groups].[Billing Groups].ALLMEMBERS
}) on rows
to this:
non...
July 3, 2008 at 7:57 am
First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your measure groups,...
June 27, 2008 at 12:50 pm
If I am following what you are getting at then you want to display the first twelve months of data broken out by each month and then the remaining months....
June 27, 2008 at 12:36 pm
Viewing 10 posts - 331 through 340 (of 340 total)