Viewing 15 posts - 136 through 150 (of 341 total)
I would recommend taking a look at the SSRS Scripter tool - Reporting Services Scripter.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 10, 2009 at 7:56 pm
Then you might want to check out this documentation from BOL:
SQL Server 2008 Books Online (April 2009)
How to: Configure a Report Server on a Network Load Balancing Cluster
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 8, 2009 at 5:54 am
I would recommend checking out these resources if you have not looked at them already:
SQL Server 2008 Upgrade Technical Reference Guide - This 490-page document covers the essential phases and...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 7, 2009 at 7:55 pm
There is no express edition of SSAS, just standard or enterprise. If you are just evaluating it might as well go with 2008 release.
Features Supported by the Editions of...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 7, 2009 at 7:41 pm
Simply copy and move your solutions to the new environment and redeploy. If you are running the packages through Visual Studio (or BIDS) it sounds like you are not...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 6, 2009 at 7:24 pm
How are you trying to execute the package? If you are doing this from the command line are you specifying the switch for the config file reference and specifying...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 6, 2009 at 7:18 pm
Take a look at the properties on the measure that you defined in the cube. If you look at the source and expand that, what do you have the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 6, 2009 at 7:10 pm
You can also use this syntax - (Except) (MDX).
Which would look like this from BOL:
// This query shows the quantity of orders for all product categories
// with the exception of...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 3, 2009 at 7:49 pm
Is everything being installed standalone on the XP workstation? Are you trying to install SSRS 2005? Is there a reason why you just wouldn't go with SSRS 2008...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 3, 2009 at 7:43 pm
Not sure if this is what is causing the issue or what order you installed and setup IIS and .NET, but you might want to make sure that you have...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 3, 2009 at 4:24 am
I would go with a side-by-side install if you are able to do this. You can backup and restore your databases to the new server to reference for your...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 3, 2009 at 4:18 am
You can look at utilizing the Except (MDX) function. It will look like this:
select
{} on 0,
Except([Product].[Product Categories].members,
{[Product].[Product Categories].[Gloves]}) on 1
from [adventure works]
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 3, 2009 at 4:10 am
Your images did not come through. When you execute the query in the dataset does it return the results as expected? If that does then you probably need...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
May 1, 2009 at 5:19 am
It appears that you should be able to return all of your data in a single query. Trying to understand group and package. Is group actually a hierarchy...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 30, 2009 at 8:56 pm
can you provide more information as to what you are seeing? if you run the query in the dataset is the data returned as you would expect it? ...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
April 30, 2009 at 8:38 pm
Viewing 15 posts - 136 through 150 (of 341 total)