.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

SSAS C# Amomd Dimension Data

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
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

View Complete Post

More Related Resource Links

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?


Getting filtered data from Role based SSAS security

Hi everyone,I've got a heap of reports that are based on various SSAS cubes. I have roles defined on these cubes that restrict data via certain dimensions. Question is, will these restrictions filter through to the report...ie, if I have a sales person restricted in the SSAS cube to only see sales against their territory (restricted in the Territory dimension), when they run the report will it filter the result based on their SSAS credentials and only show the data they have access to (even though the SSRS report has no direct filters or parameters applied)?Cheers for any help!!

Browse SSAS Cube Data From Your iPhone

Does the world want an iPhone app that allows you to connect, browse and pivot SSAS cube data?  What features would that app have?  Is there existing apps that are close?  Looking for others thoughts on this concept.  Thanks in advance!

SSAS 2008 Dimension root values changes after incrementally loading the dimension with 'process_up

The Dimension root  members (below 'ALL') changes after incrementally loading the dimension with 'process_update'.  How do I prevent that from happening ? There was no changes to data of the underlying table of the dimension.   

SSAS 2008 Metadata Repository data - User Knowledge base

Hello, We have the SQL Server 2008 Analysis services instance with some databases, cubes, Dimensions, Measure groups, partitions, etc. The business users are find difficulty to search for a particular measure. I mean, it is difficult for them locate a measure from the available cubes; again finding the respective Measure Group/ Folder is not an easy task for them. Also, they need to know the source system of a particular attribute in a dimension, formula for the calculated measure and etc. So, we have planned to develop a knowledge repository, which needs to store the business metadata for the SSAS databases. The user needs to be access this information using the SharePoint site and should help them locate and understand the data. The User Interface needs to be user friendly too. I need your valuable suggestions for the design of this system. Note: I have referenced the below articles http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/ http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/c610850f-16b4-4eaf-9b91-a2d32816f40e

SSAS - How to get other members from dimension that has Parent Child hierarchy?

I have a Sales Territory dimension that has employee and parent employee attribute on which parent child hierarchy is defined and it gives below hierarchy while browsing - - Mark Rolls --- Lumin Jacs ----- Larry Gomes ------- Messica Owens ------- Tom Ted ----------- Jackson Lopez ----- Matthew Ron --- Fred jacob - Jason Ron --- Jecy Pedro   But beside this parent-child hierarchy I have other attributes like employee address, email and telephone. My facts related sales transaction is tagged to lowest level. For example here facts are available only for Jackson Lopez (being Field Executive). When use below query I get complete sales reporting hierarchy result with some measures like sales amount, sales volume. But while accesing other attributes like address or email, it's repeating address/email/telephone of jackson Lopes everywhere to whom fact record is linked, Actually I want address/email/telephone of each sales employee from that dimension within hierarchy. How do I get it? The query I used is: Here Parent Terr ID is parent child hierachy. SELECT ( Descendants( { [Dim SalesRegion].[Parent Terr ID].[Employee Level 01].&[538018] /* here Mark Rolls is 538018 */ }, 0,AFTER), NONEMPTY([Dim SalesRegion].[Emp Address].[Emp Address].Members), NONEMPTY([Dim SalesRegion].[Emp Email].[Emp Email].Members) ) ON ROWS , { ([Dim Date].[The Year].[The Year].[CY-2010], [Dim

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.

I need a grouping and cumulative sum of data(TFS SSAS Report)

It is a MDX query (TFS Warehouse)     WITH MEMBER [Measures].[Date Value] AS     [Date].[Date].CurrentMember.Member_Value     MEMBER [Measures].[CalculatedRoughOrderOfMagnitude] AS Iif(     [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER IS [Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].[All].UNKNOWNMEMBER,     2,     2^([Work Item].[Microsoft_VSTS_Common_RoughOrderOfMagnitude].CURRENTMEMBER.MEMBER_VALUE+1)     )   MEMBER [Measures].[ActiveRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Active + "]") , [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ResolvedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Resolved + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )   MEMBER [Measures].[ClosedRoughOrderOfMagnitude] AS Iif( [Work Item].[System_State].CURRENTMEMBER IS StrToMember("[Work Item].[System_State].[System_State].[" + @Closed + "]"), [Measures].[CalculatedRoughOrderOfMagnitude] ,0 )           SELECT {  &nbs

SSAS 2K5 - Server time dimension

Hi, I'm building a cube and I want to add a time dimension. I don't have any time table in my OLTP (Source) database. So I tried to use the wizards from SSAS to create a time (date) dimension. I have choosed the "Server time dimension" one. It did create all what I need with all the hierarchies. But when I tried to add time business intelligence with the wizard, it doesnt see my new time dimension. I have checked if the type was "time" for the dimension and It was ok. So I don't know why the Time intelligence can't see my time table .... btw, I start the Business Intelligence wizard from the cube.   Thanks

SSAS 2K5 - Name of the dimension included in attributes

Hi I have a fact table with 2 field using the same dimension table. So, in SSAS 2005, The dimension is added (Lets say dimXYZ). So the dimYXY is used for 2 field in my fact table. When I go in my "dimension usage" tab ... i'm adding the 2 dimension that are bind to 1 physical dimension wich is dimXYZ. So I rename (in the dimension usage tab) the dimension freshly added. ("Dimension AB" and "Dimension CD"). But when I browse the cube, the attributes are displayed like Dimension AB.NameOfAttributes and Dimension CD.NameOfAttributes) Is there a way to hide the name of the dimension in the attributes ? Thanks * Sorry for the bad english ... I speak french ;-)--------------------- Richard Martin

Avoiding a SELECT distinct query generated by SSAS when using dimension derived from fact table

Hi, I am using a dimension derived out ot a fact table and the factt able primary key is dimension key. Issue is, there are large number of rows and so many attributes. SSAS issues distinct query and it takes large amount of time. Without the distinct statement, query takes only 3 min for 4 million rows. With the distinct, it takes 20 min. Becuase the fact primary key is the dimension key there is no need of a distinct statement. I know there is a option in the dimension to say "By Table" to avoid this. But unfortuantely, i breach the 4 GB limit for strings. Any suggestions for optimization? Thanks,  Sambath

How to enable caching on SSRS that using SSAS cube to bind data


Hi All 

 How to set Cach refersh option for a SSRS report that using SSAS cube to bind data 

when i tried to store credential in data source getting error as show below 

"Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https."





SSAS Data Member Issue


Hi all,

I am using SQL 2005 - SSAS- Calculations tab to create data member. I am using two numeric columns from the fact table to create a data member, after that I use calculation properties "associated measure group' to link with the fact table. Now it is showing in perspective tab at the bottom.

But for some reason it's NOT SHOWING IN THE FACT TABLE in  browser tab where I am viewing some resutls.

Please let me know what I did wrong? Or if I missed something?




SSAS - performance penalty standard dimension without custom member formulas VS standard dimension w


Hi all

I was wondering if there is a big performance penalty if one introduces custom member formulas to a standard dimension.


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,


SSAS - Use simultaneously unary operator and custom member formula in a PC (Parent-Child) dimension


Hi all

I was wondering (even this might a very bad idea from a logical and performance perspective) if it is possible to use unary operator and custom member formula simultaneously? Until now I have used unary operator but now some new calculation can't be expressed using unary operator. The idea is just to add the new members calculation to custom member formulas. Is it possible to make cohabitate both. If I had to switch all unary operators to customer member formulas what would be the equivalent expression for +, - , ~?

thanks for your answer


SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider



I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

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