BI Developer Network Community

Hungry for information about business intelligence? The BI Developer Network (BIDN) contains the best information about bringing business intelligence into your company. Every resource in BIDN is free.

Featured Articles

MDX Scripting with SCOPE Statement
3/15/2010 9:57:26 AM - In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.
Everything you need to know to develop your first SSIS package
3/1/2010 12:52:25 AM - This arcticle covers all of the basics that one should know before developing an SSIS package.
Using SSIS to Automate the Creation of Cube Partitions
2/2/2010 6:01:42 PM - This article will show you a method for using SSIS to create SSAS partitions in and automated process. No longer will you have to create partition in the designer. Create an SSIS package to do all the work for you the schedule it to run when needed.
Setting up Many to Many in SSAS 2008 Cube
1/26/2010 2:23:44 PM - Learn how to set up a many to many relationship in SSAS 2008.
Developing an End to End Data Mining Report
1/24/2010 5:25:59 PM - In this article you will learn how to develop an End to End Reporting Services report using a Data Mining dataset. The article assumes you already have a data mining model created but if you do not a sample is provided.

bdouglass has joined the community

8 minutes ago
cagyeman24 has joined the community

12 minutes ago
Christian created a new post Conditional formatting based on the Hidden property of a row group

46 minutes ago
Christian has joined the community

59 minutes ago
DustinRyan updated an article MDX Scripting with SCOPE Statement

1 hours, 21 minutes ago
rlharmon has joined the community

1 hours, 26 minutes ago
SimonaP has joined the community

1 hours, 26 minutes ago
mexis has joined the community

1 hours, 26 minutes ago
chkicks has joined the community

1 hours, 26 minutes ago
niktrs has joined the community

1 hours, 26 minutes ago
kkideckel has joined the community

1 hours, 26 minutes ago
cskanth20 has joined the community

1 hours, 26 minutes ago
BICzar has joined the community

1 hours, 26 minutes ago
DWCzar has joined the community

1 hours, 26 minutes ago
mcatoe has joined the community

1 hours, 26 minutes ago
Carmos has joined the community

1 hours, 26 minutes ago
RoadToad has joined the community

1 hours, 26 minutes ago
suehart has joined the community

1 hours, 26 minutes ago
RandiB has joined the community

1 hours, 26 minutes ago
DPrather has joined the community

1 hours, 26 minutes ago

More Activity

Free and Discounted Microsoft Learning Resources

3/15/2010 11:06:43 AM by BillBrannen - Views: 99 - Comments: 0

I was browsing the Microsoft Learning portal over the weekend and came across the following free or dicounted learning resources for SQL Server. Free Resources: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform (1 hour) Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence (1 hour) Clinic 6190: What's New in Microsoft SQL Server 2008 for Database Development (1 hour) Clinic 6258: New Features Of Microsoft SQL ...
SQL Agent jobs

3/14/2010 2:46:26 PM by TonjaB - Views: 73 - Comments: 0

Recently I was asked to provide a list of all sql jobs on a certain server running between 2 and 3 in the morning. We have quite a few jobs and it would be time consuming to look through each to determine the time of day each runs. So I used the sysjobs, sysjobsschedules tables to return the job name and times the jobs run. There are several jobs related tables in the msdb database: sysjobs sysschedules sysjobhistory sysjobsteps syscategories The table names are pretty self explanatory. The...
Solving All Versus (Select All) SSRS End User Confusion

3/12/2010 11:11:39 PM by DevinKnight - Views: 123 - Comments: 0

When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters. Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown. If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...
DTS Runtime Required

3/12/2010 10:49:40 AM by ShawnHarrison - Views: 75 - Comments: 0

Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error : Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed d...
Missing AdventureWorks2008 Found

3/12/2010 7:08:28 AM by timmurphy - Views: 64 - Comments: 0

So I finally got through all the SSIS Class Labs including the Group Labs and decided to figure out why I didn't have AdventureWorks2008. I had previously tried to enable FILESTREAM according to some blogs I had read about it but had no success. Maybe I just understand all this a little better now but when I exactly followed these steps right out of the help file it worked for me: 1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and t...
Using Temp Tables in Data Flow Source Stored Procedure

3/11/2010 5:51:52 PM by MikeMollenhour - Views: 78 - Comments: 0

Many times while working with SSIS I have had issues where I would like to add a temp table to a stored procedure that is a source for my SSIS dataflow. One work around for this is create a temp table variable instead. The issue with this is if many rows are in this temp variable the performance can be severely degraded. So the other day I was searching for workarounds and found this link http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/ . Here Michael Cape gives a Wack...
SQL REPLACE for editing Configuration Tables

3/10/2010 1:48:38 PM by BradSchacht - Views: 80 - Comments: 0

Package Configurations in SSIS are key to making your packaged portable across the entire development process. The problem you being to face with configuration files is the quantity that you collect. Recently I was working on a project where we had pacakge level configurations as well as a configuration for each connection. In order to to updates on this would have taken a very large amount of time, especially since I had to make configuration files for dev and production. I opted to go with...
Calculate the Date of the Previous Sunday

3/10/2010 1:48:35 PM by BradSchacht - Views: 65 - Comments: 0

There are a number of ways that you can calculate dates using T-SQL. A common practice is to find the first day of the week which can be accomplished easily by using the following function.select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)However, you will notice that this returns the date for Monday as SQL Server uses Monday for the start of the week. If your week starts on Sunday or you need to get the date for the previous Sunday you can simply modify the DATEADD part of the query from adding z...
Back to Basics

3/10/2010 10:05:38 AM by Bevans - Views: 105 - Comments: 1

Today I figured I go back to basics with this blog since a majority of the visitors to this site are primarily DBA's and Database Guru's. This may turn into a series but for now we will discuss a bit of a feared power of sql server, and that is the fact that sql server in fact sits on top of the .net framework. This allows it to access its immense power and array of options that one just couldn’t do efficiently using traditional tools, in both the BI Stack and SQL’s T-SQL function library. This ...
Using a CTE with a T-SQL Pivot Statement

3/9/2010 9:22:27 PM by PatrickLeBlanc - Views: 130 - Comments: 0

During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE). In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the derived table with a CTE. I have never attempted this approach, but I was confident that it could be done. Using the AdventureWorks database I initially wrote a T-SQL PIVOT statement that uses a derived table, which is as follows: USE AdventureWor...

More Blog Entries

Conditional formatti...

46 minutes ago by Christian - Views: 4 - Replies: 0

I'm trying to format the background color of some cells/text boxes in a report based on the current Hidden (Visible? Toggle? I'm not sure the right term) property/status of a Row Group (or it could be some other object--e.g., text box--in the report). I put a document with screenshots and annotations at http://www.christianbahnsen.com/ssrs_conditional_formatting.pdf The document may help better explain what I'm trying to accomplish.Essentially it boils down to being able to determine whether a g ...
Re: Report si...

1 hours, 44 minutes ago by DevinKnight - Views: 108 - Replies: 12

Trying using netstat -ano on the command line to see what all is trying to use port 80. You may have other applications that you don't know about that are using the default port. You could also just quickly change the port to something like 8080 in the report configuration to test.
Re: SSIS - Import te...

3/15/2010 by MikeDavis - Views: 17 - Replies: 1

You can do one of two things. You can do this with a script task and read in each line. Or you can set up a data flow and read in the entire line as one column. Then use a derived column transform to do the find replace on the entire line. Write this data to a staging flat file and read that in your regular data flow.
Re: Show Me The Requ...

3/15/2010 by CurrentMember - Views: 128 - Replies: 2

Hi Ed and Adam, Adam, I'm very interested to see your article when it is available. Ed, Here is my two cents. We use an Agile methodology that iteratively gathers requirements as the the system is developed and users understand the the capabilities of the system. The Agile SDLC diagram in this link does a pretty good job of describing the project flow. http://www.agiledata.org/essays/dataWarehousingBestPractices.html As you know a traditional waterfall model doesn't work well for BI because it d ...
Re: Count Fact R...

3/12/2010 by CurrentMember - Views: 91 - Replies: 5

Hi Scott, I think you were right to start with but are unsatisfied that the Phone intersection shows a value. Your expression is dead on but may need a little tweaking. - In your example the All member if using ([DimOrderType].[OrderTypeDesc].currentmember,[Measures].[FactOrder Count]) will be 15 and this is not what you want- Your original solution is correct for [DimOrderType].[OrderTypeDesc].&[Internet] and is 5- Your want [DimOrderType].[OrderTypeDesc].&[All] to be 5 for this calculated meas ...
Re: Solution Deploy...

3/11/2010 by CurrentMember - Views: 79 - Replies: 2

Hi, Have you checked the CPU, memory, and Disk I/O Metrics on the server using Task Manager or Performance Monitor? You may override the default member with NULL and see if that speeds up your initial connection CREATE MEMBER CurrentCube.[MEASURES].NullMember AS null, VISIBLE = 0; ALTER CUBE CurrentCube UPDATE DIMENSION Measures, DEFAULT_MEMBER=[MEASURES].NullMember; Then run the Profiler to see what its do in SSAS A good resource is http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-442 ...
Re: MDX very slow ...

3/11/2010 by CurrentMember - Views: 107 - Replies: 4

Hi Patrick, Not sure of the specifics of your user-defined Products hierarchy but you might be able to do something like this in your cube's MDX script. CREATE MEMBER CurrentCube.[Measures].[Level Specific Calculated Member] AS NULL; //Overwrite SKU level SCOPE([Measures].[Level Specific Calculated Member] , Descendants ([Product Dim].[Product Hierarchy] ,[Product Dim].[Product Hierarchy].[SKU] ,SELF)); this = iif([Measures].[QoH]-[Measures].[arws]<0,([Measures].[QoH]-[Measures].[arws]),NULL) ...
Re: Conditional C...

3/11/2010 by CurrentMember - Views: 87 - Replies: 4

One more thing Dustin, I was assuming in my post that you created a grade dimension (0-100). Typical I would think of a grade as a measure Regards, Luke
Re: PowerPivot?

3/9/2010 by MattSmith - Views: 154 - Replies: 1

My impression is that its self service optimized for large data sets. In the past we have found limitations with Excel's ability to handle this (around 1 million records). PowerPivot exceeds this significantly. It also allows the ability create calculated columns and so on. The true value I see is integrating it into a collaborative tool such as SharePoint where the users do not have to have excel installed locally to do analysis on data allowing you to govern your solution and minimizing suppor ...
Re: Database Source...

3/5/2010 by TonjaB - Views: 267 - Replies: 4

nitya said: Check into SVN using Tortoise Client from Explorer each time we make a change. My IT team uses SVN as well. I only wish it could work with VS2005 like Source Safe. Tonja B
Re: Script destinati...

3/3/2010 by MikeDavis - Views: 48 - Replies: 1

The 171 is the lineage id of one of the columns. One of the columns may have changed during the building process. Try remapping the columns in the input columns. But why are you using a script task? Why not use the OLEDB command transform?
Re: File System Ta...

3/3/2010 by gharwood - Views: 78 - Replies: 3

I was able to get it working by changing the variable "TgtPath" from \\dbserver\c$\staging to \\dbserver\staging . Since my SQL Agent runs under a plain vanilla domain account which is not in the Administrator's group, the agent can't use the Administrative share "C$". However, I can't explain why when I am signed in as the sql agent account on the db server, I can use C$ both in windows explorer and in batch files (e.g this works: "move \\ftpserver\FTP\file.txt \\dbserver\c$\staging\file.txt ") ...
Re: Provider not r...

3/2/2010 by MikeDavis - Views: 79 - Replies: 3

The OLE DB provider may have extra registery entries that exist for the users profile. If you install the full application as the MSRS user and configuerd the applications DB connection, it should validate the connection and the report should work.
Re: Naming Conventio...

3/2/2010 by DevinKnight - Views: 66 - Replies: 1

Was it SSIS naming conventions? He was probably refering to Jamie Thomson's blog here http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx .
Re: Can we have ...

3/2/2010 by srinivasa - Views: 89 - Replies: 7

I will be trying my scenario based on the below url: http://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx I think this solution will work for me, I will have to test this though... :)
Re: Creating Monthly...

2/28/2010 by MikeMollenhour - Views: 155 - Replies: 1

If you create a subscription you will then find a job on the SQL Server Agent of the reporting services box... While the RS Interface doesn't seem to have the ability for last day of month the sql server agent schedule does so you can just try changing it in the job after it is created in the web inteface... Hope this works for you.
Re: MS Cube Browser

2/28/2010 by MikeDavis - Views: 62 - Replies: 2

The Bids browser is only in BIDS. The browser is just for testing. Excel is much more powerful. You can create charts also.
Re: Tips for Integra...

2/27/2010 by AdamJorgensen - Views: 179 - Replies: 1

Amy - do you still need this question answered ?
Re: Many to Many Dim...

2/25/2010 by MikeDavis - Views: 74 - Replies: 2

Thanks for clarifing your question. Maybe I can answer it better now. On the fact table you have an order id of say 1234, on the bridge table you have 2 rows with the order id of 1234 that map to the sales people Jim and John and there sales rep ids are on the bridge table, which map to a sales rep dim table. Correct? Where are you storing the sales amounts for each sales rep, on the bridge table? If so then you are going to need other rows on the bridge tables to map to the same order id. So yo ...
Re: "My Account" ...

2/25/2010 by sqlscottgleason - Views: 146 - Replies: 4

Marocadf, I supplied my crenditals to the Bidn support team and they were able to duplicate my issue tonight, I think they are well underway into fixing this tricky issue. :-) Scott

BI Developer Network Community

Featured Articles

What's New

Quick Vote

Top Contributors

BI Developer Network Community

Featured Articles

What's New

My Spaces

Quick Vote

Top Contributors