.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Need to Automate in SSIS Cube Drop and Recreate of Dimensions: Had to do on the Solution Explorer Ma

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hi SSAS Engineers: This question is in the context of a complete refresh of the SSAS cube. I'm OK on the SSIS approach thanks to TMcD and past successes (also thanks to him). The question is why did I have to manually drop/delete the dimensions in BIDS SSAS, then readd them with the cube wizard to pull in the dimensions with the same names, but new surrogate key relationships and more surrogate keys in total? We need to Automate in SSIS Cube Drop and Recreate of Dimensions. I originally had to perform this function on the Solution Explorer Manually in SSAS UDM, since the names are the same, but the structures and the data are changing for the dimensions on the refresh (and the fact table is subsequently increasing). Herein lies the problem. We had a keynotfound error in the cube processing, since the old keys were being kept. I had run Full processing on the dimensions, but since the dimensions have the same name (no drop old names and add new names), the old surrogate keys remained. The fact table had the old row count as well, since the surrogate key pipeline to look up the surrogate keys for the new dimensions only had the old dimensions, even though I truncated the fact table. Yes--I had already rebuilt the dimensions in SQL Server and the row counts were the new refresh row counts. The dimension counts were right according to refresh numbers after

View Complete Post

More Related Resource Links

Who can come up with a good SSIS solution to this problem?

Test your SSIS optimization skills on this problem: http://ask.sqlservercentral.com/questions/17499/phil-factor-speed-phreak-challenge-6-the-stock-exchange-order-book-state-problem Johan Åhlén http://blogical.se/blogs/jahlen  

daily complete cube rebuild four dimensions and fact table including remapping of all surrogate keys

Hi SSIS Engineers: Forgive me if this is a multi-forum question. Our primary activity in the next week is to automate the processing in SSIS, where I led the team to create complete processing flows for Full and Add in the order of Dimension, Measure Group, Partition, Cube, Database. These work. The problem occurs in a complete refresh of the ERP database that caused me manual effort inside SSAS, which I plan to find a way to automate in SSIS. I performed a complete refresh of our cube from the ERP source from a time perspective. We are automating this process in SSIS. In SSAS, I had to manually delete the four dimensions from the UDM view via the Solution Explorer. Since the complete refresh increased the surrogate keys in the dimensions and since the names were the same, I couldn't just drop the partition and reprocess the dimensions, since, in effect, new fact rows would have to be mapped to the new keys. SSAS held on to the old keys even with Full Processing of the Dimensions first, then the Cube. Until I dropped--deleted-- the dimensional tables from the Solution Explorer and the UDM then later readded the dimensions with the new surrogate keys (both add, update and delete dimensional attribute changes in full refresh) via the Add Dimension wizard, the cube kept the old surrogate keys and failed in measure group, fact, database and partition processing.

How to process just one cube in a solution of three cubes inside BIDS SSAS

Hi, I have a BIDS Solution with three cubes...I want to make a full process of just one of the cubes, but If am doing just one, the other cubes comes unavailable... How can I process just one without affecting the other ones? Thanks!

solution explorer not showing solution name - VS 2008

Dear All, I am  stumped by a serious issue in Vs 2008. I created a Blank solution called HelloWorld.Then I added a new Class Library project by the name of HelloWorldService.After creation of the Class Library project the Solution name disappeared from Solution Explorer.  As a result of which I can now only add new items into the Class Library project but cannot add new item to the solution. This appears to be a pretty old problem as I found it in another link on the internet. http://stackoverflow.com/questions/2580046/vs-2008-solution-explorer-not-showing-solution It seems to be a bug.Has MS released a patch or a fix for this. If so pls post the links. Thanks for your efforts

SharePoint upload files from windows explorer and emails from outlook by drag and drop

Guys, I need to have this functionality to upload files and mails by drag and drop, now sharepoint allows it by having that folderview in IFrame which takes the dropped item, but this does not allow files with spcial characters due to http URL related issue. How can I customize or program this to allow files with special chars in name, if not possible then how can I rename before the drop is over ? thanks, ram    

Re-processing Dimensions with a ROLAP cube


Hi all.

I have set up a ROLAP Cube because of the advantage that you do not need to re-process the cube.  AS will always go to the underlying data source for the most up to date data.  Unlike MOLAP you do not need to re-process your cube to refresh the data.

BUT.  I find this is only true for my FACT data (or for my measures).  Say for instance my dimension changes - I add the member "Australia" to the country dimension.  This new data is NOT filtering down to AS automatically, I need to re-process my dimensions for the cube to be valid again.

So my question is this.  If you have dimensions changing with each datawarehouse load, what is the advantage of ROLAP?  Is there a way for ROLAP to figure out that a dimension has changed and re-process it automatically?



Drag and drop to windows explorer of SharePoint site leads to 0KB file


I believe this issue got by so many people already.

We have a sharepoint site running on HTTPS protocol. There are some scenarios we get multiple documents from customers and need to move them to SharePoint to share them across organization. For this, what we are doing is, we are opening the library and from Actions menu -> Open in Windows Explorer.

The windows explorer is opening fine and when we tried to move the files from local system to windows explorer of the SharePoint site, it is failing to copy data and showing 0KB moved. And at the windows taskbar it is giving notification like "Got network delayed write fail message." when we are doing this on XP. On any other OS, there is no notification and not moving the file.

We are not able to understand the problem. Why it is not able to move, everytime it is copying 0KB.

We can do using upload multiple files feature, but we have to go back and forth between folders and it will slow down the process.

Please help me out, why it is happening... It is not network issue at all for sure.


ASP.NET and SharePoint developer
Company: http://www.rampgroup.com/
Blog: http://praveenbattula.blogspot.com

How to connect SAS OLAP Cube using SSIS


Hello Everybody, I am using SAS Olap cubes, i would like to connect those OLAP Cubes using SSIS and need to perform some ETL process, could you guys please let me know the solution,thank you.

Kind Regards


Data Flow Task failing to drag-and-drop onto SSIS Control Flow

This morning, I started having problems with Visual Studio 2005 on XP when I tried to create an SSIS project; I was getting an error message about the failure to create an SSIS runtime object, with the reference "Unable to cast COM of type 'Microsoft.SqlServer.DTS.Runtime.Wrapper.PackageNeutralClass' to interface type". Digging here and elsewhere on the Net, I used regsvr32 to re-register msxml3.dll, msxml6.dll, and dts.dll. This allowed me to create a new SSIS project, but I was unable to add a data flow task to the Control Flow pane -- when I dragged the control onto the pane, nothing happened, and when opened the Data Flow pane and clicked on the 'No data flow task has been defined. Click here to create a data flow task" link, I got a 'Failed to create the task. The designer could not be initialized." error. Searching here and on the Net, I uninstalled and reinstalled the SQL Server 2005 workstation tools.

After doing this, I am still unable to create a data flow task by dragging the task out of the toolbox; the pointer assumes the right form for the drag-and-drop, as it does for other tasks, but when I release the mouse button, nothing happens. However, when I go to the Data Flow pane and click on the 'click here to create a new data flow task', it creates the task, and I am able to use copy-and-paste to make copies of the data flow task

New DSV named query or copy and reuse an existing cube dimensions (is the latter valid) - SSAS 2008


I have a [DateAsAt] table in the DSV. This is linked to 3 fact tables to analyse and slice them from an as at date perspective (lets call them FactA, FactB and FactC). But I want to reuse this dimensions (almost like an alias) and although I have tried this and it seems to work, I just want to follow some due dilligence to make sure what I am doing is valid.

I have not created a new Named Calculation for a new date dimension that will be used in a Transactional way (not an as at way), and in stead simply copied the [DateAsAt] dimension, and pasted it back into the dimensions section of the cube (the default name it was given was [DateAsAt 1], but I changed it to [DateTransaction].

Although the relationship between the [DateTransaction] dimenion's source in the DSV (I.e. [DateAsAt]) is linked to FactA, FactB and FactC, I set a new dimension relationship between [DateTransaction] and FactTransactionD in the Dimension Usage area of the cube.

Is this valid? or MUST I create a seperate source for [DateTransaction] in the DSV and set its relationships there?

Modify a table name without drop it and recreate it using T SQL



How to modify a table name without drop it and recreate it using T SQL. Suppose the SSMS is not installed or reachable.

Thank you


The complexity resides in the simplicity

SQL Server 2008 Express - No Solution Explorer


I installed Sql Server 2008 Express and there is not a Solution Explorer. I go to Microsoft SQL Server Management Studio -> FIle -> New and my only options are (1) Query with Current Connection (2) Database Engine Query (3) SQL Server Compact Query (4) Policy. I have tried CTL-ALT-L. VIEW does not have a Solution Explorer. And when I got to TOOLS -> Customize, there is no Solution Explorer.

What do I have to install to get Solution Explorer? Would I have to uninstall my current SQL Server or will it just overlay or co-exist?


Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Exit message:                  Passed
  Start time:                    2009-02-28 20:08:46
  End time:                      2009-02-28 20:09:33
  Requested action:      &n

drag and drop windows explorer view in moss


For uploading or copying large number of documents i can use windows explorer view in moss.

Is this view requires administrative permission.

Suppose i have a workflow for each document in the library,If i copy in bulk documents to the library.will the workflow be attached by default.

Any suggestions..

automate SSIS package




             i created few SSIS packages , now we want to automate the packages based on file update in a folder. actual requirement  is ,, when we add a fine in a folder immediately the proper package should execute .end of the package i used a task to delete the file , so when ever the file adds in the folder the package should execute immediately , how i can automate this thing

Dynamically created directories not displaying in solution explorer


I have noticed today that when you create a directory in code in a web application the resulting folder structure is not created in the solution explorer (It is fine on disk and app can still access all the files)

I am not sure if there is a setting that I am missing or is this a bug?

Steps to reproduce

Create a new C# web application in VS 2010.

Create a new web page (Default.aspx) and add a file upload control and a button.

on the click event on the button add the following code

String ImageUrlPath = "/Media/Photo/";
Directory.CreateDirectory(Request.PhysicalApplicationPath + ImageUrlPath);
string FileName = FileUpload1.FileName.ToString().Replace(" ", "");
FileUpload1.SaveAs(Request.PhysicalApplicationPath + ImageUrlPath + FileName);

When the form posts back refresh the solution explorer and the new directory does not appear.

Check your file system and the file will be there.

Not a massive issue but frustrating. Any guidance would be appreciated

Two versions of company_name.master showing up in solution explorer

If I look at the solution explorer I have two files named company_name.master. One is is a folder named GLOBAL and the other is in a folder named company_MasterPage. They are not the same file as they are in different locations but I wanted to know if I could exclude one or the other from the solution and why it may have happened that there are two.

Solution Explorer in SQL Server Management Studio

Am I just out of my mind or does the solution explorer only list files in the order they were created? Is there any way to sort the list?  I'm trying to manage a database as a "solution".  It has over a hundred or so procs. If I can't alphabetize the list it is of no use to me since it's impossible to find a specific proc when they are not sorting in any logical way.  (Please keep in mind there are multiple developers working on this "solution" so the list if effected by all of them.)

I am trying to maintain some version control over the procs using VSS but it looks like I have to use a "solution" and "projects" to do that.

What kind of "solution" is this?

Is there any other way to do this?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend