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

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

Personalization Extensions and Attribute / Dimension visibility

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

Does anyone know if it is possible to hide / show Dimensions, Measure groups, or Attributes via MDX?  I am using personalization extensions (which is awesome) to create "things" on the fly keeping them separate for each client who uses our cubes.  But now we are entering the realm of "we don't want to see that, as it doesn't apply to us" [they came into the picture after so much was already built].  It would be great if I could use some MDX to hide entire things at a pop, and it is already built in.

Does anyone know if this is possible?  Or would I have to use XMLA to accomplish this?  Or would it be better to use the .Net classes (as they provide a safety layer between my code and future changes)?

Thank you in advance,

View Complete Post

More Related Resource Links

Getting counts by 2nd Date Dimension Attribute with Snapshot Style Fact Table

  I have an MDX question finding hard to solve.  I have a Snapshot Fact Table with a snapshot of the records in the source system for each batch date.  All records in the fact table are assigned the batch date with the batch date key.  There are many records for each day and each batch date is an entire copy of the source records.  So, the grain of the fact table is one record for each batch date that exists in the source system.  These facts rows have another date in them for when the record was entered.  This date is different from the batch date in that the batch date is based on the day the batch was processed and the entered date is based on when the record was entered.  If a record was entered many days before, its batch date will be today but its entered date will be several days ago.  Therefore each day a copy of all the records entered the previous batch date and all the records added on today's batch date are present. Fact Table : FactSnaphshotKey (surrogate for easier administration) BatchDateKey (link to batch date dimension – date dimension, first in dimension list so it is used for semi aggregate measures) EnteredDateKey (link to entered date dimension – date dimension) Facts Count – measure for fact table - default measure from Analysis Services cube 2 Dim

Dimension apperance personalization

Hi All, I have a time dimension that is organized like this Calendar year Calendar semester Calendar quarter If you browse it you will have for example 2001         1              3              4 What I want is that I modifiy the herarchy appearance so that it will be like this 2001         First semester                 Thrid quarter                 Fourth quarter Is this possible ? If yes then how do I? Thanks The complexity resides in the simplicity  

Different attribute name in each dimension for a role playing dimension

Is it possible to name the attribute differently in a role playing dimension. For example I use the Date dimension as the role playing dimension for Ship Date and Order Date. When I use these attributes on the report, both of them show as 'Date' which is the name of the attribute in the Date dimension. Is there any work around to implement these names differently?

Dimension design: Key column of non-key Dimension Attribute

Assume I have a product dimension where key dimension attribute is product code - this is a very large dimension with more than 1 million members, the key column for this attribute is productID (integer). There will be other attributes in this dimension related to key attribute.   My question is about the key columns to be defined for these other attributes. As it is related to key attribute, it has to include ProductID as part of key and hence forming a composite key - e.g. Product inception date - the key column for this has to be ProductID + date as many products can have same date. This design will violate the best practice recommendation from MS to have only numeric key columns for very large dimension attributes. But I can't find a way around this and assume this will be case for all non-key attributes in very large dimension. Is my understanding right? I assume this will be an issue for everyone? Any standard way to get around this? Or best to leave it as such? Thanks in advance.

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.

Dimension key attribute changes in fact table



How do I need to handle a case in which the fields in a fact table that represent the foreign keys to the dimension tables might change? What kind of process do I have to do to the cube?



Get SSAS Dimension Attribute SQL Column Name using C#



I am trying to determine what the real SQL Server Column name is for a Dimension Attribute using ADOMD.net, however all I am able to find is the the TABLE_NAME and COLUMN_NAME Columns using the GetSchemaDataSet("DBSCHEMA_COLUMNS", null) function.

Does anyone have any suggestions?



key not found for the attribute in dimension


Hi experts,

i have this problem: I have a fact table for sales analysis and i have a dimension for article of sale. The problem is that in the fact table i can find multiple records that not is present in  the table of articles. This condition not is an error because the software for the sales permit to do a sale without an article codified.

How can i solve this problem?

Can i force this error? If i set custom error on dimension with ignore key error enabled, the cube process however go in error

Dimension Attribute Reserve Word in AMO



I am using SQL 2008 R2 Standard SSAS. Has anyone tried creating a dimension attribute with the name "Name" using AMO.

AMODimensionAttribute = AMODimension.Attributes.Add("Name") - This does'nt work.

I get an error that, “dim_xxx” dimension contains a member property with invalid name “Name”. “Name is one of the Reserved Words”.    We can always make sure to check if the attribute name in the OLTP DB is "Name" and then prefix it with some additional characters.  But it restricts that, I can’t create an dimension attribute with the name “Name” using AMO.





After adding a new attribute to a dimension and saving, SSAS unprocessed partitions. Can anyone help



After adding a new attribute to a dimension and saving, SSAS unprocessed partitions. Can anyone help me understand why this happened and point to some reading materials for detail? (can't find any...)


Personalization Extensions on Server 2008 r2


I have personalizatioon extensions in a stored procedure and they work beautifully - locally until I put them on Server 2008 R2.  For some reason the Events (SessionOpened and SessionClosing) are not getting called.  I have the assembly registered as Unlimited, running under the service account [which is a local admin on the box].  To make sure the assembly is registered correctly, and has the proper rights I included a couple methods to test things out (pull the connection string from the file system, make a test insert into a database, etc).  Everything works just fine when I call it in MDX (calling the sproc method MakeDbCall() - data shows up on the table perfectly).

I narrowed it down to the SessionOpened and SessionClosing not getting invoked by running a trace to see if the database is called on the first line.(a Logging Method - which was proven out to work)  I am running this locally on Vista Enterprise and the events are called - with no problem.  It's when I deploy it out to the server that it doesn't work.  Has anyone else experienced this?  User Access Control is turned OFF on the server too.  Here is the code I am using:

SSAS 2008 - Dimension colmun/attribute not visible in cube browser?


Hi, I have one dimension and one fact table in SQL 2008 server...

i.e. DimEmployee (Columns : EmployeeID, FirstName, LastName, DateOfBirth, Addrss, PostCode, MobileNumber, Gender)
     FactEmployeePay ( Columns : EmployeeID, Amount)

When I create SSAS 2008 cube on those two tables (Relationship is EmployeID colmun) , deploy/process project/cube and then I go to "Cube Browser", but in dimension Employee table I can not see any columns other than EmployeeID. Why in this simple cube I can not view other dimension columns like FirstName, LastName,....

Any idea for SSAS 2008?


Need to access MemberValue of a dimension attribute regardless of level.


I have a Product dimension that has an attribute (Std Cycle Time) that is numeric. I need to use that value in a cube calculation.

How can I access the value regardless of how the data is cut?

I tried this method:

  [Dim Product].[Product - Std Cycle Time].CurrentMember.MemberValue
FORMAT_STRING = "#,0.000", 
VISIBLE = 1 ; 

But what I see in a Pivot Table when I pull this value in is 'ALL' unless I pull the Std Cycle Time attribute into the table.

I understand that behavior. If specific attribute is not pulled into the pivot table, SSAS defaults to the ALL member.

Question is I want to retrieve that Std Cycle Time to use it in another calculated member to compute a weighted average. Basically, I want to do this:

 //Compute the Weighted Average of the Std Cycle Time based on the runtime for the given product.

Format dimension attribute with leading zero


I have a attribute in a dimension that represents a hour. The value is an integer. How do I format this with leading zeros, as Excel will treat is as string while sorting (meaning 0,1,10,11,12,2,3,...). I tried the formating attribute in the key column in the dimension-attribute. But that has no effect.



WPF / Silverlight tutorial: Visibility property and binding

Visibility property is a very powerful and yet often overlooked property available in both WPF and Silverlight. It enables you to set Visibility of certain UIElement objects to different states like: Visible, Collapsed and Hidden (not supported by Silverlight). This tutorial shows you how to use it and how to bind to Visibility property

Tab container rendered with visibility:hidden - This was reported over three years ago.



Here is (more) code that demonstrates the issue.  If the control in the host page is removed the tab control renders correctly.  Otherwise it is rendered with the visibility attrubute set to hidden as reported in the above link.  Is this broken or am I doing something wrong?



<%@ Page Language="C#" AutoEventWireup="true" CodeFile="S2.aspx.cs" Inherits="S2" %>
<%@ Register Src="~/SelectorPatternControl.ascx" TagName="TestControl" TagPrefix="sam" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <form id="form1" runat="server">
        <cc1:ToolkitScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true"></cc1:ToolkitScriptManager>

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..

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