.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

incorrect attribute member names

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

i'm seeing incorrect attribute member names in my degenerate dimensions.

the dsv looks like this:


SO records, AR records, and Customer records are all associated with a Location.  SO and AR records are also associated with a Customer.  in some cases, the SO or AR record LocationKey is different from the LocationKey of the customer record that a SO or AR record is associated with.

when i create a cube and dimensions based on this dsv, it seems like initially everything is fine.  however, inevitably i eventually see the following:

the AR and SO degenerate dimensions each have a Location attribute, with the fact table LocationKey column as the key, and the Location table LocationName column as the Name.  at some point, the attribute member names will begin to appear as the Location name that is associated with the LocationKey from the Customer table, rather than the appropriate fact table (AR or SO).  it seems that this begins to happen after the relational database is updated. that process generally consists of deleting all fact table rows and repopulating.  when this problem appears, "Process full" on dimensions, partitions, measure groups, or the cube does not seem to resolve the problem.

i witness this error

View Complete Post

More Related Resource Links

Documents linking to physical cluster member names

I have a WSS 3.0 SP2 environment with two front-end servers behind a load balancer.  For some reason, when a user tries to open a document, they get routed directly to one of the cluster member servers using their physical name, instead of the DNS entry hosted on the load balancer.  I believe this is the cause of a second login prompt each time a user attempts to open a document.  Any ideas?

Unrecognized attribute RequirePermission, not because of incorrect framework version in IIS...

So I have been struggling with this error for a while and normally i get around it by removing the attribute and all is good, not quite simple this time. Based on my research on this error, this is usually caused by incorrect .net version selected in IIS but for me this is usually not the case.  For the app i am working on, it is a 4.0 app, the asp.net version in IIS is set to 4.0, and the error is caused by the RequirePermission attribute in the 4.0 machine.config.  Since it is calling the 4.0 machine.config, that only tells me the version is set correctly.  So what is wrong, why is it not recognized? I have tried removing all the requirePermission attributes in the machine.config, then something else is not recognized, I believe it was the configProtectedData section.  Endless error messages.  It seems to be happening only on one machine.  I did try uninstalling and reinstalling 4.0 and it didnt help, very frustrated!!! Suggestion any one? Thanks in advance!

Ignoring Blank member names in SSAS

Hi all, I was wondering if there is a quick and easy way to ignore any member name that has a blank name?  Currently I have a cube where I get (Blank) as the member name which has a value associated to it and I need to hide/delete these. I didnt design the underlying fact and dimension tables so wanted to know if there is a quick way within SSAS/MDX to say something like "If member name is (Blank) then ignore. Thanks in advance for you help.

Set default member based on an attribute



I have a time dimension which is based on a time_dimension table. This has a column called current period which can be set to 0 or 1. My requirement is that I want to set the default member of my Year attribute (which is also part of the time hierarchy) to that value in my dimension table that has current period set to 1. How do i do this?


Unable to obtain the current member because a non-aggregatable attribute has a calculated member coo

Hi All,

I am getting this error with following mdx:

SELECT {[Measures].[Sent],[Measures].[Bounced]} ON columns,
Order(Hierarchize(Union({[Account].[Account Name].[All]},
[Account].[Account Name].[All].Children)), [Measures].[Bounced], ASC) ON rows
FROM [MyCube]

Please note that this error occurs on an empty db but not on a db with data.

Please help me to understand why this is so and what/where exactly is the error.

Thanks in advance.   .

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Creating A Stored Procedure Which Searches Team Names



I'm have on my web page a text search box which I want users to type in there favourite football team and this will display a gridview of the teams with the replica shirts I offer.

This is where I thought about creating a stored procedure to carry out this task.

I looked online for ideas but I not found anything as yet.

If anyone done anything similar to my request please let me know.

I am not able to read xml file with XDocument if its Descendants has Attribute xmlns="http://abc.co


I am not able to read xml file with XDocument if its Descendants has  Attribute like:-

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
  <row ID="1" xmlns="http://www.opentravela.org/OTA/2003/05">
    <var country_name="Caribbean and Rest of the world" city_name="Kingston" flight_category="Economy Class" via="Atlanta" flight_departure="London Heathrow" airline_logo="Delta" adult_fare="Delta" child_fare="660" infant_fare="561" date1="132" date2="2010-08-15" />


I don't know what to do ?

Looking for some help..

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Get Member from LDAP using C# 2.0


I'm currently writing a process where I need to determine if an User on my LDAP string is an Admin.

How can I accomplish this?  What would be the easy and quickest way?

I've been trying to use the code below..... Any feedback is greately appreciated. Tks



dynamically change column names in Crystal reports


I need to develop 3 pages.

On the first page user defines atmost 7 column names to be displayed on the report. I'm saving these names in a Sql DB table 'Columns' with Column_Nm and Column_ID as Table columns.

On the second page I'm retrieving column_Nm from the table and displaying them on the page so that the user enters the data. This data is saved in another table 'Summary' with the Columns column1 through column7.

on the 3rd page I need to show a report of 'Summary' table.

How do I dynamically replace column1 through column7 names with that of 'Column_Nm' on the report?

Any help/suggestions would be appreciated.


Make sure that the class defined in this code file matches the 'inherits' attribute, and that it e


Here is the page directive for the page that throws the error:

@ Page language="c#" Inherits="University.AspNet.Index" CodeFile="Index.aspx.cs" %>

The code behind file Index.aspx.cs starts like this:

using University.Framework.UI;

namespace University.AspNet

public partial class Index : University.Framework.UI.HomePage

The code behind is extending this HomePage class, which is in turn an extenstion of another class University.Framework.UI.Page, which extends the System.Web.UI.Page class.

Am I misusing the I

Security Briefs: Hashing Passwords, The AllowPartiallyTrustedCallers Attribute


Keith Brown describes how yo can hash passwords when you want to store them in your own custom database, and when to use the AllowPartiallyTrustedCallers attribure on your assembly.

Keith Brown

MSDN Magazine August 2003

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