Search results for query: *

I need to upgrade my client tools to SQL 2008 R2 for SSRS purposes. However, I still need to deploy SSIS to SQL 2008. I cannot find anything to do with target version in BIDS. Does anyone know if this is possible? Thanks

The is a property called AutoRefresh under Report in SSRS.

You shouldn't need to be altering the tables in the backend of SSIS. Just use the Report Manager web application to set your permissions.

I assume System and SubSystem are in a single dimension called System. For each System, add a dimension member for "No SubSystem." Connect your facts at the System level to these.

Try this for the expression: ="Global_HeadCount: " & FORMAT(Parameters!YourDateParameter.Value, "M yyyy")

Lonnie, ETL is not a magic wand to create a data warehouse ready to be analyzed. You have to determine the business processes you want to model and model them. You have to gather requirements, and identify source systems as well as other one-off systems or small systems which will need to be...

I don't understand what you mean. Using NON EMPTY will result in less data in your resultset. If you DO NOT use NON EMPTY, you'll get something like this: MEMBER 1 $100 MEMBER 2 NULL MEMBER 3 $200 MEMBER 4 NULL If you use NON EMPTY, you'll get this: MEMBER 1 $100 MEMBER...

You edit the text of your MDX query to include something like: WHERE ( StrToMember(@rpDateParameter) ) You then map a parameter called rpDateParameter to an SSRS parameter called @rpDateParameter.

Don't use NON EMPTY in your MDX query?

The SQL Server installation media allows you to install Business Intelligence Development Studio, which comes with SSIS and SSRS designers, but without any .Net development languages like VB/C#/C++. So you do not need to buy anything. Just install it from the SQL DVD.

Well, Business Intelligence/Data Analysis is a broad category. Within that category, you have people who specialize in data modeling, people who specialize in ETL, and people who specialize in report writing. Then there are associated roles such as project managers, B.I. support staff, and...

Try something like this, obviously you will need to modify the where clause SELECT d.[MonthName], a.* FROM dim_Date d LEFT OUTER JOIN (SELECT Test_Admin_Assessment.ShortName, Test_Results.SchoolYear, Test_Results.TestAdministrationDate, Test_Results_Trait.Score...

If you outer join your main table to your date table, but put a where clause against your main table, you may as well have an inner join, because you are going to filter out what you are doing today. A workaround would be to alter your where clause like the following: WHERE (...

You usually handle this in the query. You take a date table, or a derived or table variable that has a row for each date or month, and outer join your transactions to that date table. You put the where clause against the dates against the date table.

On the series, you can change the color of the Fill or Border. You can use an expression like: =iif(SUM(Fields!SomeField.Value) < 100, "Red", "#00000000").

If you already go through the hassle of deploying table schema changes to fifteen databases, why not add stored procedure deployments as well? I'd hate to use dynamic sql in every stored procedure just to save the little bit of time a single deployment provides.

Bear with me, I'm a long time Windows developer, I'm looking for a layman's explanation. I need to have the ability to assign directory permissions to multiple users. Is this the correct approach? 1. Create Linux groups, assign various users to the various groups. 2. Change the directory...

The only way to reliably order results in SQL Server is to use an ORDER BY clause. SELECT * FROM Assets ORDER BY AssetNo

Sorry, I don't use TableAdapters or other heavy abstractions of ADO.Net, so I'm not sure.

VB.Net is not a 4GL language. So your application is not going to create a form on the fly, display it to the user and prompt for a parameter. You have to code to ask for the parameter and you have to code to supply the query with the parameter. Secondly, you don't need those single quotes...