Viewing 15 posts - 91 through 105 (of 340 total)
You can reference the member properties by doing a CurrentMember.Properties(" [Property Name] ") = " [Your Value] " reference, but why not simply reference the key values instead of the...
September 10, 2009 at 11:32 am
If you want some hand-on lab experience check out Microsoft's Virtual Labs area - http://www.microsoft.com/events/vlabs/default.mspx
Also take a look at William Pearson, III who has a ton of excellent tutorials on...
September 3, 2009 at 5:23 am
The undocumented stored procedure is sp_MSforeachtable, not sp_foreachtable.
So you could do something like the following to return the results quickly:
sp_MSforeachtable 'sp_spaceused ''?'''
There is also the undocumented stored procedure...
September 2, 2009 at 7:42 am
What OS are you running? If you are running Vista or Win 7 you might want to run SSMS as administrator or go into the Compatibility tab of the...
August 28, 2009 at 6:50 am
Besides what is stated here for deployment you will need to see if you are part of the SSAS Server Administrators. When you installed SSAS 2005 there was an...
August 28, 2009 at 5:31 am
You can download and setup the sample reports that will allow you to create a reporting repository based off the execution log. This is part of the sample reports...
August 26, 2009 at 2:29 pm
You need to go into the data source view and define the relationship between the two columns within the table. Once you do this the wizard will pickup on...
August 4, 2009 at 11:23 am
Take a look at these postings:
Loading and Running a Local Package Programmatically
http://msdn.microsoft.com/en-us/library/ms136090.aspx
Running SSIS package programmatically
http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
July 31, 2009 at 9:10 pm
For information about SSAS check out this site - http://ssas-info.com
There is a good list of books listed here - http://ssas-info.com/analysis-services-books
July 25, 2009 at 8:09 am
If you are using the RDLC and the Microsoft Report Viewer control then you should check out this site - http://gotreportviewer.com. This site has lots of useful information, FAQs,...
July 25, 2009 at 8:03 am
Can you possibly provide an example of what you are looking to get at for the results?
I am thinking, but not certain, that you will want to put the sort...
July 17, 2009 at 12:02 pm
My bad, thought you were just trying to add some additional calculations from your fact table that you might have added or did not include originally.
Yeah, this can be done...
July 13, 2009 at 11:31 am
Use the option in the cube structure tab of the desired cube to add 'New Measure'. This is available in the toolbar or by right-clicking in the Measures...
July 13, 2009 at 10:58 am
With Excel 2007 and RB 2.0 going directly against the cube that would allow for a little more flexibilty with the end-users since they could define their own calculations and...
July 12, 2009 at 6:57 am
That is why requirements gathering is extremely critical in the creation of any solution. Without the proper requirements how can you just try and build a solution unless you...
July 11, 2009 at 3:23 pm
Viewing 15 posts - 91 through 105 (of 340 total)