.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

SSAS - Partition Slice not working

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

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

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

Member_Caption property not working in SSAS 2000

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  

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



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


Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Working with DropDownList and ListBox Controls in ASP.NET

"In my application i am using dropdownlist to display all categories from a table. When the user clicks this control I display all records in that category. Category table also contains column called color.

I wanted display some categories in dropdown list different color and others in different color using ASP.NET."-Anonymous

Server side validation of Fileupload control not working



I've tried this method in my code behind to try and validate that the Fileupload control has a file or not. I get the error message the the event "Server Validate" cannot be found. Can anyone tell why? Thanks.

Public Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate

' Get file name

        Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload)

        Dim UploadFileName As String = uploadAvatar.PostedFile.FileName

        If UploadFileName = "" Then
            ' There is no file selected
            args.IsValid = False
            Dim Extension As String = UploadFileName.Substring(UploadFileName.L

Row command working on all rows not selected one?



I have this code that hides a column in a gridview.  (The column houses another nested gridview).

    Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
        If e.CommandName = "Select" Then
            If GridView1.Columns(0).Visible = False Then
                GridView1.Columns(0).Visible = True
                GridView1.Columns(0).Visible = False
            End If
        End If
    End Sub

The trouble is that if I click the select link on one row that action to hide is carried out on all rows.  How can I set this up so that it only hides the row that is selected?


upload file not working



iam using masterpage and ajax update panel, i have child page called  fileupload.aspx,i try to upload the file

but its not working , can i use updatepanel in child page , pls very urgent

looking forward for answer.

JQuery Treeview plugin is not working with Ajax page load in ie8


Hi there,

I developed a page where i m using jquery treeview plugin to generate tree. It worked fine on FF, IE8 with out ajax.

But when my page loads thro' ajax call in IE8, it is not collapsing or expanding tree.

Any idea?

Thanks in advance.

jquery confirm windows isn't working


Hi, i am using jquery to implement a modal confirm windows but it not working

i have a template field button with ajax confirm using jquery but i have a problem. Apper the confirm windows but when i click on "yes" doesn't execute the delete command. without ajax (using template field button and simple confirm windows javascript) works so well.

Can you give me a hand with this?

thx in advance!

<link href="_assets/css/StyleSheet.css" rel="stylesheet" type="text/css" />
<link href="_assets/css/confirm.css" rel="stylesheet" type="text/css" />
<script src="_assets/js/jquery-1.2.6.min.js" type="text/javascript"></script>
<script src="_assets/js/jquery.simplemodal-1.1.1.js" type="text/javascript"></script>

<script type="text/javascript">
$(document).ready(function() {
       $(".deleteCustomer").click(function(ev) {
                var msg = $(this).attr("title");
                confirm(msg + "?");

Keyboard shortcuts stops working in WebMatrix


I'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I was wondering if someone knows a quick-fix?

update/delete not working on server only


my aspx page works in VWD, and everything works on the server EXCEPT update and delete sql functions. any ideas?


New off line application working with sdf file. Need advice


Hey Folks

I am working on a project currently where I need to get data out of a 3rd party vendor's software that uses a .sdf file I looked this up and its a SQL CE file. I was hoping to just link to with with access but thats apparently not going to happen. I need to link to the database extract data from it to a csv file for later use. I also and most important I need to get the data from it and create a report that can be printed while on a customers site that my or may not have web access so I need for this program to be on and off line. I had my webapplication that I have been working on open and was able to bring up the sdf file under the server exploere however I can't seem to get anything out of it when I try to do grid views or detail views errors out.

Can I use one of Visual Studio projects to create this sort of applicaiton if so what would be the best approach. I would love to get an access odbc driver since office is allready installed on the employee's laptop's



Logging to database is not working



Am using Enterprise library 4.0 for logging exceptions to SQL server database. The code is working fine if I run my asp.net application from the Visual studio IDE.However if I publish the site and host it on IIS, then my application is not logging the errors to database.Here is the page load event of my application.Kindly help me in finding out the error.

Thanks in advance


 protected void Page_Load(object sender, EventArgs e)
                //If exception occurs due to unauthorized access
                if ((Request.QueryString["Unauthorized"] != null) && (Request.QueryString["Unauthorized"].Equals("Y")))
                        lblErrorMessage.Text = "You are not authorized to view this page";
                        //Get the user and machine names                       
                        string strUserName = User.Identity.Name;
                        string strMachineName = System.Environment.MachineName;
                        //Raise Error
                        throw new System.UnauthorizedAccessException("Unauthorized access--User Name:" + strUserName + "--Machine Name:" + 

URL Rewriter.net - not working



I have a website that uses Querystrings to determine what content to show on a page. I would like to be able rewrite these URL's to become Search Engine Friendly URLs. So for example I would like to change http://www.website.co.uk/Company/Company/Conference.aspx?WebPage=ImportantDates to http://www.website.co.uk/Company/Company/Conference.aspx/ImportantDates.

I have been reading the following article by Scott Gu - http://weblogs.asp.net/scottgu/archive/2007/02/26/tip-trick-url-rewriting-with-asp-net.aspx - who suggested using a HTTPModule such as URL Rewriter.net (http://urlrewriter.net/).

So I have done this and added the URLRewriter.dll file in my bin directory and altered the web.config (following Scott Gu's approach #2). However my URL's are not changing and I don't know what I am doing wrong. I have added the following in the web.config to try and change the URL's.


    <rewrite url="~/UKAIS/ConferenceWebPage.aspx?WebPage=(.+)$" to="~/UKAIS/ConferenceWebPage.aspx/$1" />

However my webpage URL remains with the ?WebPage querystring.

I am really stuck and any help would be very much 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