.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

Trying to find out how data from warehouse is loaded into a dimension

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server

(SQL Server 2005)

I have a customer data warehouse table that I am loading into a customer dimension.  Each row in the warehouse has a unique integer key.  It is possible to have multiple rows with the same customer name.  Each row will have an account code and an alternate account code.  Besides the key field, Name + Account + Alternate is what makes a row unique.

Once I process the table into the warehouse it looks like I am only getting one entry in the dimension based on customer name.  It is difficult to browse dimensions and tell exactly what is there.  I've tried setting up a plain demision and also adding  Account code and Alternate account codes as attribute relations under Name.  I've also tried a hierarchy with Name -> Account -> Alt Account.

I have a customer with 2 account codes and multiple Alternate codes - 29 rows in the warehouse.  When I browse I only get one result for name - I want to see 29 names all the same.  Do I need to set up the dimension somehow to use Name+Account+Alternate as the key?  Currently I am using the warehouse key field as the key. 



View Complete Post

More Related Resource Links

Flex Your Data: Teach Old Data New Tricks with the Fully Loaded Advances in ADO.NET 2.0


ADO.NET 2.0 will streamline your data access development efforts. Its new features let you work better with XML and SQL Server, and they offer lots of other improvements as well. This article takes a detailed look at some of the more interesting enhancements and focuses on performance and flexibility.

Julia Lerman

MSDN Magazine April 2005

How to process data AFTER page is completely loaded for the user?


I have some logging that has to be done, which are some database update or inserts.

However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.
As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.

So I want this code only executed after that the page is complete.

I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.

I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.

Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.
However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr

wss2.0 Infopath 2007 'This form requires connections to data sources when it is loaded. At least on


Hi all

I have a user who receives the error 'This form requires connections to data sources when it is loaded. At least one of these connections is not available. As specified by the form designer, this form will not open' when trying to Submit an infopath form located on a WSS2.0 site.

The user has been having this issue since upgrading to Office 2007 and IE7. I have had the user run an Office Diagnostics but this has not resolved the issue.

I am not aware of any other users experiencing this issue.

Any ideas please?

MVC view displays Preveously loaded data only



1. May be it loading page either from History or Chache memory.

2. When anonymous user open about-us page or Home page then we display only 4 menus. And immediatly Normal user logs in and

open about-us page or Home page it again display only 4 menus instead displaying all menus available for registered user. I

have used the PartialView and render it in Master page(use the code Html.RenderPartial("Menus")) see the following code...

<%@ Control Language="VB" Inherits="System.Web.Mvc.ViewUserControl" %>
<%: ""%>
<div id="menucontainer">
    <ul id="menu">       
            <%  If Request.IsAuthenticated = False Then%>
                <li><%= Html.ActionLink("Home", "Index", "Home")%></li>
                <li><%= Html.ActionLink("Register", "Register", "Account")%></li>

System.Data.OleDb.OleDbException: Could not find installable ISAM.


Hi, i got the following error while i am trying to get my web application to run on windows server 2003. I've installed 2007 data access components on windows server 2003 but the web application does not seem to work. The codes that i use is as follows:

string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + address + ";Extended Properties=Excel 12.0;"; OleDbConnection objConn = new OleDbConnection(strConn); string strSQL = "SELECT * FROM [Sheet 1$]"; OleDbCommand objCmd = new OleDbCommand(strSQL, objConn);

OleDbDataReader oddReader = null;


oddReader = objCmd.ExecuteReader();







I've read a lot of forum posts and almost all of them mentioned ab out the connectionstring being wrong. However, when i ran the codes on my local machine, there were no errors. The error only show when i was running on windows server 2003.

I've underlined where the error is pointing to. Please advise. Thanks

SSAS C# Amomd Dimension Data

Hi, i have the following problem. I'm able to connect to the cube, get the Meassure Names, Dimension Names and Dimension Attribute Names. But how can i get the Dimension Attribute Data (MEMBERS) in a List or Array. I mean how can i acces the data of an Dimension Attribute like in MDX: Dimension -> Attribute -> Attribute Data [Dim Customer].[First Name].&[Frank] I would be great to get/recive all Data an put them in a Table(List/Array/DataTable/...). Thx for your time and your help

Framework 4.0 dll loaded by a 2.0 executable cannot find "xxxx.resources.dll"

 Hello, I have an interesting situation here that I was hoping someone may be able to give some pointers on.  First my application is all provided within a class library assembly so that it can be loaded by multiple hosts.  We are investigating moving to Visual Studio 2010 and the .Net Framework 4.0 for some of the new features.  However, one of our hosts is a 2.0 click once application that we do not have the source to.  I've tried modifying the config file for the executable to add the useLegacyV2RuntimeActivationPolicy with the 4.0 as the supported runtime and setting loadFromRemoteSources as suggested by a Google search and that came close to working.  However, depending on the workflow through our client code is giving a System.IO.FileNotFoundException for various references. The message associated with the exception is Could not load file or assembly 'file:///XXXXXX.resources.dll' or one of its dependencies. The system cannot find the file specified."  Were the XXXXX changes and the .dll may or may not be present depending on whether Assembly.Load or Assembly.LoadFrom was used to perform the load.  Any thoughts would be greatly appreciated. [Addition: I forgot to mention that our app originally targeted Framework 3.5SP1] Michael Fischer

How to find a rownumber in a matrix in SSRS and use it to manipulate data

Hi, I have an MDX query which returns me a dataset. It is something like this. Country Measure 1 Measure 2 Country 1 99 100 City 1 45 50 City 2 40 30 City3 14 20 Now in the actual report I need to show the data for the City Rows using a logic like City.Measure - Country.Measure. This has to be dynamic as I dont know the number of rows in my report. I have taken a tablix and bound my cells to the appropriate measures. My problem is to write an expression for the cell such that if it is the 1st row (Country row), then it should directly take the value, else it should do a logic like City.Value- Country.Value (in ex. for City 1, Measure 1 data should be -44 ). Can someone help me in writing the expression. I checked on net and saw that we can use the RowNumber function, but I could not use it like =iif(Rownumber=1, "1st Condition", "2nd Condition"). Any help will be appreciated. Thanks, Suman

Non parent-child dimension with fact data at different levels... How!

Hi all, Quite new to SSAS, wondering if anyone could help with the following... I've got a dimension with attributes that indicate geographical location based upon UK postal boundaries - so ~1.8m Postcodes > ~10000 Postcode Sectors (PCDS) > ~3000 Postcode Districts (PCD) > ~100 Postcode Areas (PCA). The problem I have is that the address information is not of the highest quality. I have matched 50% of my facts to postcodes, of the remaining 50% i've mapped them to PCDS, PCD or PCA, where possible, leaving the lower-levels as NULL in those cases. My attribute hierarchy works fine where I have complete records all the way down the hierarchy, but I only have a single UNKNOWN member at the top (GOR) level. I want an UNKNOWN member at each level. It makes sense to me how to do this using a Parent-Child dimension, but i'm keen to avoid that as the performance is terrible. I'm hoping there's a method of configuring this. Any help massively appreciated.

What are the technical issues would you expect to face when building a centralised data warehouse fo

Hi, I am new to data warehousing and recently I was asked this question  which I did not know the answer. I would be grateful if someone kindly help me with the answer or direqt me to a link.   Q.  What are the technical issues would you expect to face when building a centralised data warehouse for reporting purposes?

How to find, where is data in a db?

Hi, User send me some data from troubleshooting. I want to find where is this data stored in db.   my db is called emp_db Got 104 tables. i want to find a data in this db, which table, which column. How i find it?

Iterate data row to find errors.


Hi, I have an asp website, and a dataset with a datatable. When I check I after configuring it it shows all the data. But when I run the code I got an exception

System.Data.ConstraintException was unhandled by user code
  Message="Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

I want to figure it out with iterating datarow.

Some codes are here but I need help to iterate datarow.

public partial class tabRegionExtremeList : System.Web.UI.Page
    DataSet1TableAdapters.droughtDataTableAdapter k1 = new DataSet1TableAdapters.droughtDataTableAdapter();
    DataSet1.droughtDataTableDataTable k2 = new DataSet1.droughtDataTableDataTable(); 
    String [][]ExtremeList;
    protected void Page_Load(object sender, EventArgs e)
    private void getRegionExtremeList()
            // How to catch error by iterating Datarow here
            // such as using 
          // foreach(...)



Failed to find or load the registered .Net Framework Data Provider.




I am using enterprise library 5.0,vs.net 2008,oracle 9i,odp.net version.

In machine.config I added the line below in

<add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory , Oracle.DataAccess, Version=, Culture=neutral, PublicKeyToken=89b483f429c47342"/>


DbProviderFactory pf = DbProviderFactories.GetFactory("Oracle.DataAcess.Client");

above line is throwing an error.

System.Configuration.ConfigurationErrorsException was unhandled by user code

Message="Failed to find or load the registered .Net Framework Data Provider."


BareMessage="Failed to find or load the registered .Net Framework Data Provider."



at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow)

at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)

at testweb2008.Classes.test..ctor(String strKey) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\testweb2008\testweb2008\Classes\test.cs:line 30

at testweb2008._Default.Page_Load(Object sender

Data in Physical table and not in Dimension


Hi All,

I have a strange problem. For Analysis services deployed in three environments. I have problem only with data in Production, one of the site is missing in Production, but the same site is present in Development and QA environment. I have already verified following things.

1) Site is present in Physical Table

2) Verified SQL Statement thats generated while processing dimension: Data is retrieved from physical table using this query.

3) Have already done full processing of Dimension.

4) I have even check DSV table and see data. 

5) Corresponding data is present in Fact

For Example if I am looking for Site Number: 123456, this site is present in Development and QA. But missing in Production. By the way, structure, and data of Development, QA and Production is same. It would have made sense for any issues or problem if this site is missing in all the environments, but thats not the fact.

Any help or suggestion is deeply appreciated.

Thanks in advance,


Find Scale and Precision in Float data type

Is there any way that i can find the scale and precision in float data type column. The table has around 1000 records and for each record, i need to find what is the scale and precision for the column which has float data type.

steps for loading data into a dimension table


Hi Experts,

Can anyone give me the steps for loading data into a dimension table from a SQL database table? An explanation as to why the objects are used will be very helpful.

Thanks in advance

SSAS 2008 - The OLAP data source has no property fields available for this dimension


Last week I was able to view member properties for my Product Dimension in Excel 2010 pivot tables. Suddenly, without having made any changes to the dimension (for example, in the Attribute Relationships window of the dimension), those member properties are no longer available in Excel. I get the error "The OLAP data source has no property fields available for this dimension" when I try to select "Show Properties in Report" or "Show Properties in Tooltips" in the Pivot Table. At the same time, member properties are available for all other dimensions. I have also not made any changes to the data source connection in Excel and in any event, there is no option in the data source connection to enable or disable member property visibility. I am using BIDS 2008 and SQL Server 2008 R2 (10.50.1600.1). Does anybody have an idea why this might be happening?


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