.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

Member_Caption property not working in SSAS 2000

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hi, I need to pass a parameter to my SSRS report which is based on an Analysis services cube (AS 2000). I have created a query which will return me the members of a hierarchy that I can pas as a perameter. Interestingly the Member_Caption property is not working. In MDX Sample application it is returing "#err" in the column and when I run the same command in my SSRS MDX editor ( I am using OLEDB connection alongwith analysis services 9.0 client) I get empty space. My query is, WITH     Member [Measures].[ParameterCaption] as '[PRODUCT].CurrentMember.Member_caption' MEMBER   [Measures].[ParameterValue] AS '[PRODUCT].CurrentMember.UniqueName' MEMBER   [Measures].[ParameterLevel] AS '[PRODUCT].CURRENTMEMBER.LEVEL.ORDINAL' SELECT   {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , { Descendants([PRODUCT].Currentmember,1,leaves)+(Descendants([PRODUCT].Currentmember,2,leaves))} ON ROWS from   [My_Cube] Am I making any obvious mistake here ? I have used similar queries before and they have always worked (With SSAS 2005) Thanks in advance, Suman  

View Complete Post

More Related Resource Links

SSAS URL Action not working

Hi, I have a simple URL action in SSAS defined as below.  "http://website/Default.aspx?contentpage=attach.aspx?doc=" + [Customer].[Customer].CurrentMember.Name + "&cc=" + [Company].[Company].CurrentMember.Name + "&yr=" + [Time].[Fiscal Year Number].CurrentMember.Name When I right click on customer field and click on the Action, it opens up IT with "http://website/Default.aspx?contentpage=attach.aspx?doc=Customer1&cc=ALL&yr=ALL So instead of passing the correct company name, All member is passed. How do i fix this issue? Thanks, Sambath

SSAS DB migation issue from SQL 2000 to SQL 2008

While  running migration wizard  to migrate sql 2000 Analysys service DB from 2000 to  2008  Validation step  failing with  datatype mismatch.Please assist me here

<%# eval> not working for a simple property

<form id="form1" runat="server"> <div> <table> <tr> <td>Name: <%#customer%> </td> </tr> </table> </div> </form>        Partial Class ScorePage Inherits System.Web.UI.Page Private _customer As String = "Sachin" Public Property customer() As String Get Return _customer End Get Set(ByVal value As String) _customer = value End Set End Property End Class   The expected result in html page is Name: Sachin But i am getting Name: property is not getting displayed. I thought instead of creating a label control, we can use this method, but it is not working  

SSAS 2000 - YTD for Fiscal and General Period


Hello Experts,

In SSAS 2000, I have 2 time dimensions;

  • Financial Period (Time type) = Year --> Month (with no "All Member")
  • General Period (Time type) = Month (with "All Member" being captioned as "Year Total")

YTD Actual = SUM(YTD(), Measures.Actual)

The idea is to have all years on row and all general months on column for YTD measures. The above YTD calculation is only working for Financial Period and not for General Period .

Pretty easy to do it in SSAS2008 with scoping but how do I do this in SSAS2000 environment?

Can you please help?

Thasnks in advance.


property setting in report server (2008) config file is not working as expected.



I have set the <WorkingSetMinimum> property to 2.4GB in my reportserver 2008 config file.

By defintion, <WorkingSetMinimum> setting means,

  1. Lower limit of service memory consumption; memory will not be released if the consumption is below this amount, though the service will not reserve the designated amount of memory when it starts.
  2. If service uses more than the designated amout of memory, it will release back the memory only till this declared value and not beyond that, which means it should keep 2.4GB as designated.

See this link for definition: http://books.google.com/books?id=mzY_Xo_9J-gC&pg=PA589&lpg=PA589&dq=What+is+%3Cworkingsetminimum%3E+in+report+server+configuration+file&source=bl&ots=r_xhRp8erj&sig=E_o0-Dh2SXOgMNrW3sptt5oZrYI&hl=en&ei=f5mjTNeNM5O8ccmErJMI&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCAQ6AEwAw#

DataTrigger bound to a datebound property using a converter not working.


Hi all, this will sound like a simple problem but I am really stumped!

I'm trying to create a TextBlock with a style that collapses when the text is "" or null. So in the style there's a DataTrigger bound to Text using a Converter that provide a boolean test for "" or null.

The problem is that the triggers never seem to fire. Debugging the converter suggests it never gets used. The debug output also doesn't warn me of failed bindings so I have no idea what is going wrong!


			<GlacialControls:IsNullOrEmptyStringConverter x:Key="isNullOrEmptyStringConverter"/>
			<Style x:Key="Co

SSAS Calculated Member not working as expected in a SSRS report


Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchys) and a couple measures (sales and purchase amounts).


I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.


I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).


Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.


When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.


I've tried both Matrix and Table reports.


Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.


Best regards



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?


Isenabled property in WPF not working on mouse right click



   I set Isenabled =false on a paticular condition using trigger evry thing got disabled but mouse right click is working and Getting selected,can any one let me know how to resolve this issue.


Thanks in Advance

Custom checkbox control 'checked' property is not working .


Hello ,


Iam developing a custom checkbox control deriving from the 'compositecontrol' which i need to use it for a composite control purpose.



public class TngCheckBox : CompositeControl


i have written the required properties which are working fine except the "checked" property. he

SSRS 2000 report not able to show any data in ie6 and ie7 although found working in ie8 and firefox


we have a SSRS report which was working till few weeks backs on all the ie and started to show Diagnose the Internet connection error on ie6 and permission denied on ie7. although the report is running fine on ie8 and firefox with same security settings. There has been no recent changes done to the report. tried it through fiddler but gives a 200 status for http. IS also connecting to URL and is making connect to the DB. HAve tried to check the script and activex settings also and found nothing absurd which can stop the functionality.I have tried reducing the security to low also but with success. Can someone please help.

asp.net Radio button grouping property is not working



Iam developing a custom server control  of radiobuttton. it is working fine with the all the properties i wrapped  except the grouping . somehow the grouping is not working .

  // this is my class.
 public class TngRadioButton : CompositeControl


// this is my groupname property

[ DefaultValue(""), Themeable(false) ]
        public virtual string GroupName
                string str = (string)this.ViewState["GroupName"];
                if (str != null)
                    return str;
                return string.Empty;
                this.ViewState["GroupName"] = value;


Please  help me in this resolution.




SSAS - Partition Slice not working


Hi all

I have a cube with a date dimension. The date dimension does only contain one year => 12 Period (months)

Since each Period contains millions of rows, I created one partition per period. The periods are:

- [Date].[FiscalPeriod].&[201101]

- [Date].[FiscalPeriod].&[201102]


- [Date].[FiscalPeriod].&[201112]

In the slice property of the partition I added the following expression:

[Date].[FiscalPeriod].&[201101] for the fist period

[Date].[FiscalPeriod].&[201102] for the second period


I then used profiler to check if only one partition is hit when I use for example the following query:












on axis

SSIS job to check if SSAS cubes are working


Hi all,

I am having some management problems and need to prove that the cubes are available for browsing.

I have had a look at SSIS to see if there is a task but I suspect I need to script something out.

Can anyone give me any pointers ?

Many thanks.

Adding user to SSAS server role not working


I have SQL Server 2005 SP3 installed on  Windows 7


 I’m trying to deploy a SSAS project and get the message


“Either the user, Ron-laptop\ron, does not have access to the analysis services Project2 database, or the database does not exist”


Following recommendations in the forum I’ve used SSMS to view the properties > security of the SSAS connection and am trying to add myself to “The server role is used to grant server-wide security privileges to a user” role


SSRS 2000 to SSRS 2005 Recursive Sum in Group Sorting not working anymore


We are trying to migrate reports (.rdl) made with SSRS2000 into a SSRS2005 server.  Almost all goes well but we had Recursive Sums into Groups and it doesn't seem to work anymore.  Here is the Sort Expression of a group which doesn't work anymore.

 (Parameters!SortDir.Value="Asc" AND Parameters!Sort.Value="Revenue"),
  Sum(Fields!RBOTotal.Value, "CustomerGroup", Recursive),

Any idea about how we should do it in SSRS2005?


Daniel Siconnelli There is neither good nor evil... only mogwais and gremlins

SSAS 2008 - Date Member Property gets converted from NULL to (Blank)


Hello everyone,

I have this cube with a dimension of investment deals.  The "Deal" member has a attribute named "Latest Acquisition Date" where this date can be null for some deals.  Once the cube is processed, the null dates always get converted to "(blank)" either in BIDS cube browser or in Excel.  This happens no matter what I do to the NullProcessing property of this date attribute.

Is there any way to have SSAS display [NULL] (as in nothing at all) instead of "(blank)" ?

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