.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

Adding one to may dimension into existing cube

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server
Now We used to have a one to one relationship between our Sales team managers and each customer (See Customer and Responsibility below), but now as we have split our business up into different business areas, effectively treating them as different business'. We might sell different products to the same customer, and therefore each Business Area will have a different account manager for the same customer.

Here was the original structure
Now We used to have a one to one relationship between our Sales team managers and each customer (See Customer and Responsibility above), but now as we have split our business up into different business areas, effectively treating them as different business'. We might sell different products to the same customer, and therefore each Business Area will have a different account manager for the same customer.

Here was the original structure

Fact table





View Complete Post

More Related Resource Links

web.config - adding css friendly adapters to existing website

Hi Forum,  Please help me with the major headache I've wasted hours trying to figure out!  I have done everything explained in the tuturial to add css friendly adaters to an existing site and still no luck.  I am thinking that it has to do with modifying my current web.config file to use the css adapters.  Problem is, I can't find any specific instructions as to what I have to do to the current web.config file to make the site compatible with the css adapters!  I tried to modify the config file based on what on the example, but nothing seems to work.  Any help would be greatly appreciated!  Thanks, D

Adding a footer to a pre-existing row group

Hi, I want to add a group footer to my report which includes the individual provider name for each page. I have already added a parent row group for details relating to each provider without specifying to include a footer to the row group. When I now add a footer using the insert footer path this places the footer below my row grouping, when I then add the provider field to the footer every page returns the first provider in the list. How do I include the footer to the grouping so ever footer relates to the individual provider type in the main body of the report? Thanks James

Adding a full node to an existing XML document on a by xpath specified location

I want to add a complete node to an existing XML document.So:1. get the XML document from the session2. create a new node3. pass the node and the session to a function, that adds the node on the location of the xpath4. return the new session, updated with the node in the specified locationBelow my code, which DOESNT work.I've had some other advices, but nothing seems to work. What am i doing wrong?!?!Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load    Dim doc As XmlDocument = New XmlDocument()    Dim xmldoc As XmlDocument = Session("XML") 'get XMLdocument from session    Dim locationNode As XmlNode = doc.CreateElement("location")    Dim locationAttribute As XmlAttribute = doc.CreateAttribute("id")    locationAttribute.Value = "3"    locationNode.Attributes.Append(locationAttribute)    Dim titleNode As XmlNode = doc.CreateElement("title")    titleNode.AppendChild(doc.CreateTextNode("Empire State Building"))    locationNode.AppendChild(titleNode)    doc.AppendChild(locationNode)    Dim newNode As XmlNode = doc.ImportNode(locationNode, True)    AddOrUpdateNodeInSession(Session, "//root/dat

Issue Adding a new Lookup Field to an existing List Instance

I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

Adding New Column to XSD File Without Remapping existing Transformations

Hello, I am loading XML file using SQL 2005 SSIS and using XSD file for XML Schema defination. Now I have a requirement where I should add couple of new columns in XSD as the XML (MAY) have extra columns for few of its tables. Is it safe to add new columns to XSD and the Map only new columns in Data Flow and all will work? or after I add new columns I need to redesign all mappings as Column order will change. (I think SSIS refere a numeric value for each column, if Yes how can I add new column with less impact)? Thanks, Prabhat Nath

Key Dimension attribute not visible in cube browser

When browsing the cube either through managemnet studio the key dimension attribute is not visible . However when I browse just the dimension, I'm able to see this attribute. Is this the default behaviour ?. Is there any property I need to set to make it visble ?. The AttributeHierarchyVisible property is already set to true.

Cannot see the Dimension description while using Local Cube with Excel

Hi everyone, I'm new to the world of Analysis Services, so I might make a stupid question.
I searched over the web, but I haven't found an answer.

I'm using:
- Microsoft SQL Server Analysis Server 9.00.4035.00
- Microsoft Office Excel 2003 Sp3 (i have the Excel Add-in for SQL Analysis Services version 1.5.0166.0)

I created a cube in Microsoft Visual Studio 2005 with a fact table and only one dimension.
In the 'KeyColumns' DimensionAttribute properties i have the Dimension key and in 'NameColumn' the description.

When I browse the cube with Excel (olap driver 9.0) I can see the description of the Dimension without problem.

The problem starts when I create the local cube with the excel procedure (create offline cube) and I connect to It using Excel; in this case, the description ('NameColumn') disappears and i can see only the Dimension code ('KeyColumns').
When I connect again to the server Cube, leaving the local cube connection, i can see again the description.
It seems that the Local cube does not contain the description of the Dimension, but only the key.

I did the same thing using Microsoft SQL Server Analysis Server 2000, and when I connect to the local cube created with Excel I have no problem viewing the description of the Dimension.

Where am I doing wrong? Am i fo

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?

Adding existing user to existing group - Unknown error (0x80005000)


I am getting an unknown error 0x80005000.  Please help!

I am using impersonation of an admin account. Here's what I have in my web.config:

<identity impersonate="true" userName="mydomain\user" password="pwd"/>

<authentication mode="Windows" />


Here's my code:

Private Sub Page_Load(ByVal sender As System.Object, <

Creating Local cube on Cube using Many-to-Many dimension relationship


Hi All,

I have got a cube that uses many-to-many dimensions relationship. I also have a calculated measure (A*B) in the measure group using a unary operator.

I tried creating the local cube by using CREATE GLOBAL CUBE statement and included the intermediate measure group and one measure from the group. I have also included all the dimensions that are linked to the intermediate measure group.

The local cube is being created but I don't see the correct values of the measures. I just get the value of A coming for the value of the calculated measures. There are also some performance issues while browsing the local cube which I assumed should be very fast.

I am not sure if this is a known issue and there's a solution available for this but I tried and didn't find anything on the forum. 

Please help me with this. Thanks in Advance.


Adding .aspx page to existing web site



I have a running ASP.NET web site. There is following problem with one of the forms:

One part of submitted data is added to database after "submit" is clicked. (to "table1")

Another part is lost (not added to "table2", and no files uploaded)

I have no source code of that project.

So, because I cant edit existing page, I came to a decision to add new .aspx page to a running application with same functions as existing one.

How can I do that? Or maybe you can recommend some other solution.

Thanks, Alex. 

dimension's incremental process generates processing on all partitions in cube


Hey eb

Have any one noticed this behavior??

Incremental process (process update) of dimension generates reprocessing of indexes on all cube's partitions,even when no change has occured in that dimension.

I am using SSAS 2005 sp2.

This is disturbing because my cube holds some 700 daily partitions so processing indexes on all of them - on an hourly basis - is very time consuming.

Also it flashes that cube's cache!


I did noticed that changing heirarchies memberskeysunique property to True + changing the toppest attribute in this heirarchy mambernamesunique to true solves this problem.

Is this a must then to prevent recalculating indexes on partitions every process update of dimension??



Adding Items to existing list using CAML

Does anyone know how to add list items (not files) to a SharePoint list using CAML?  I know how to do this in code but I was curious if it was possible in CAML. We can add files using the Module element quite easily and so I thought, why not list items?  It is possible to add list items to a new list using the Data element, but I am trying to add items to a list created earlier by another feature.

SSAS adding a time dimension and using it



(Using SQL Server 2008 R2)

Im rather new to SQL Server and certainly to SSAS. AT the moment I am working on a project in which I need to implement SSAS on a SQL Server. The database originates from UniVerse and it does not have a time table I can use as a dimension.


I have found a script that will be able to set up the time dimension table, but:

-how do I add it to the database


-how do I make it available to be chosen as a dimension?





Adding XML doc template to existing code

Hi Everyone,
    I would like to know if there is any tool that can add XML documentation templates to a source code.  Basically, I want to add XML documents to new source code. The existing source does not have XML documentation for existing classes, so when I add XML documentation to new class, I get compilation error indicating no XML documentation for old classes.  Is there a tool that is available that can parse the source code and then add XML doc templates ?

For example,
If I have the following code:

class TypeByName




automatic adding new article to existing publication



I have two servers with SQL Server 2005 Enterprise Edition. There are several databases on it. I implement snapshot replication (every hour) and everything works fine. But developers are creating new tables, views and etc every day. How i can automaticaly add it (tables, colums, views etc) in existing publication (i need to replicate all data in database). Or i need to use another solution like database mirroring?

Best regards

Adding Current Windows User to Database Encounters Existing User with Same Login


In VS2008 in debug mode, I am using SMO to programatically change the users and permissions on a database. Windows authentication alone is being used. I need to limit access to a administrators group and the current user for whom the database has been dynamically created during the first run of the application within their current Windows environment on the machine. I have no problems creating and assigning the administrators group, but when I try to create the user using the environment's UserDomainName and UserName variables (which would be my creditals) I encounter an inner exception "The login already has an account under a different user name". Before doing running the app, I manually have checked the local server for user and logins with my credentials and programatically looked at each login but have not found any matching credentials. 

Insights and suggestions appreciated.


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