Viewing 15 posts - 106 through 120 (of 340 total)
There are all sorts of resources available, just depends on your preference (book, classroom, hands-on labs, videos, etc.). Here are a few resources to get started with:
Microsoft Virtual Labs...
July 11, 2009 at 9:09 am
So far the only thing that has been announced is H1 of 2010. Nothing more beyond that has been released so far. Don't forget that the next release...
July 11, 2009 at 8:55 am
Robert Bruckner has some examples of how to go about this:
July 11, 2009 at 8:52 am
While Report Builder 2.0 is a great front-end reporting tool for end-users, you might need to explore other tools that will allow end users to create these types of reports...
July 11, 2009 at 8:46 am
Instead of trying to setup filters this would be more optimal to setup in the cube to return your results. This is exactly the types of questions that SSAS...
July 11, 2009 at 8:41 am
Excel 2007 is a good tool if that is all you can use for the time being.
Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
Here...
July 9, 2009 at 5:38 am
How are you doing your ETL? Are you using SSIS? If so, take a look at this thread in the Microsoft forums - ssis package documentation
July 9, 2009 at 5:34 am
You need to set a property on the attribute within the dimension in the SSAS database. The property that you will need to set is 'InstanceSelection' this defaults...
June 30, 2009 at 6:12 pm
Yeah, you can use Except or - (minus).
June 30, 2009 at 5:59 pm
Then you will need to use the convert(varchar(10), , 101) and you would get a result in the format of mm/dd/yyyy.
You will just need to specify the style code for...
June 30, 2009 at 4:25 am
In the named query or in a database view you can use the following to return just the date portion:
dateadd(dd,datediff(dd,0,),0)
June 29, 2009 at 1:50 pm
With the missing dimension key it would basically mean that there is no match for the fact record in your dimension table. Are you certain that the dimension tables...
June 29, 2009 at 1:46 pm
If you have SSAS 2008 you can utilize Dynamic Sets now.
Take a look at this posting and this might help you in resolving this issue - http://www.setfocus.com/technicalarticles/kgoff/mdxnamedsets.aspx
June 29, 2009 at 1:44 pm
Haven't taken the actual upgrade exam, but I did take both of the beta 2008 tests. Here is the feedback on the MCITP exam for 2008 - Quick Feedback...
June 5, 2009 at 5:05 am
If you take a look at the Adventure Works DW sample (2005 version) on CodePlex you should be able to take a look at some examples of Actions.
Here is there...
June 1, 2009 at 8:24 pm
Viewing 15 posts - 106 through 120 (of 340 total)