.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 Time Dimension (academic years, quarters) change over time

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Apologies if I don't state teh question properly or am overlooking obvious answers - just started working with SSAS and barely beginner level.

I'm working on a cube to show student enrollments in different subject areas over time - for this purpose I'm only concerned about academic years and semesters.  In the underlying dimension table I have data like

1 2006          SUMMER  SUMMER 2006
2 2006          FALL  FALL 2006
3 2006          SPRING  SPRING 2007 (note that spring 2007 is part of the 2006 academic year)
4 2007          SUMMER  SUMMER 2007
5 2007          FALL  FALL 2007
6 2007          SPRING  SPRING 2008
and so on

I've set up a simple hierarchy with only two levels - ACAD YEAR->DESCR

For the cube I have one measure: 'Enrollments' which shows the sum of students who have enrolled

What I'd like to be able to do is show the f

View Complete Post

More Related Resource Links

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 adding a time dimension and using it



(Using SQL Server 2008 R2)

Im rather new to SQL Server and certainly to SSAS. AT the moment I am working on a project in which I need to implement SSAS on a SQL Server. The database originates from UniVerse and it does not have a time table I can use as a dimension.


I have found a script that will be able to set up the time dimension table, but:

-how do I add it to the database


-how do I make it available to be chosen as a dimension?





Correct Time Dimension Settings to Hide Extra Years in Drop List


This is going to be easy for the experts to answer (I hope). Here is my problem:

1) I have a Fact table that is linked via a TimeKey (Not date, it is a number) to the Time Dimension table. (I want to build a cube in SSAS)

2) The Fact table contains data from 2008 to 2010 (YTD)

3) The Time Dimension Table includes years  between 2005 to 2015

My problem is:

When I drop years into a column (in the browser) I get the correct year range between 2008 and 2010 (which is correct)


At the same time, when I use the drop down list of the column I can see all the years from 2005 to 2015. (Which is included in the Time Dimension Table)

How can I make those "extra" years disappear from the drop down list? How can those years appear in the browser even though there is no matching "TimeKey" in the fact sheet that would link them.

I know this maybe a simple setting in the Time Dimension but I cannot find it.

Your help is greatly appreciated.


SqlDataSource how to change the stored procedures at run time



Is it possible to change the select, insert and update stored procedure of an SqlDataSource at run time. I don't mean to change the definition of the stored procedure, but I mean to change the assignment, i.e. To change the select stored procedure from "selectSP1" to "selectSP2" at run time. Is it possible?



Time Dimension Enhancement with Business intelligence Issue

Hi all, I want to add a year over year growth using the BI wizard (Time diemsion enhancement) but when I try to add this enhancement via the wizard then this last one has the button next disabled with a waning that says   A time dimension is required to enable this functionality. Ensure that you have a dimension of type Time, that contains at least one hierarchy with a level flagged as a time period. Inspite of the fact that I added that time dimsension with one hierarchy Time hierarchy Calendar Year Calendar Semester Calendar Quarter Time Key(With namecolumn defined as a named calculation that repsents the day with this format  yyyy, dd mm ) Me personaly I have a doubt about the last condition of the warning (with a level flagged as a time period) but I dont know exactly 1. If my doubt is right 2. What shoud I do to enhance the cube in this context using the time dimension enhancement The complexity resides in the simplicity

how to change dynamically [Bbrowsable] attribute for a property at design time c#

hi,   how to change dynamically  [Browsable] attribute for a property  at design time c#

Should time date stamp on .Asmx file change when project is rebuilt?

I have a web service project. The web service is named Recalc.asmx and it has a code behind file namedRecalc.asmx.vb Now if I make a change to my web service .vb code and then recompile the project, should my Recalc.asmx filebe updated as well? In windows explorer I see that the time date stamp of my Racalc.asmx.vb file changes to the date of the last change.But the time date stamp of the Recalc.asmx file does not change? Why is that? My original thinking was that I would simply need to copy the Recalc.asmx file to the test server. But the date stillshows it's original creation date of 7/1/2010 and not the date of the last rebuild as I was hoping it would do?

Time dimension not grouping correctly

Hello, I'm new to SSAS but I did some reading and some training already. This is my third cube and I'm having trouble with my time dimension.. - first I browse the cube and drag the year and month to the columns section and it correctly renders only the times to which I have data - then I drag my workstation dimention to the rows section and it's also shows the wks fine. - Then I add my counter dimention to the rows section and it correctly shows up as a sub set of workstations. - The problem: When I drop my value fact it renders different value to each counter but show the same value for ANY time, including future dates. (time dimension generated with SSAS) Let me explain the cube, maybe you have seen something similar or could have some insight. Fact: A hourly based table with counters for my workstations. Columns: Datetime, wksid, counterName, and value (value aggregated by max()) Dimention Workstation: id, name Dimension Time: timeid, date, year, month, semester, etc. Dimension counter: id, countername All columns were connected to the correct related columns in the data source view. Why would the cube fail to correctly aggregate my facts by different dates? Any clue? Please let me know if you need any clarification.. Thanks in advance!

OnWorkflowItemChanged fired more than one time for each change

I have a state machine workflow that runs without problem in SharePoint 2007. I wanted to have this in SharePoint 2010. I have created the same workflow using Visual Studio 2010, State Machine Workflow for SharePoint 2010 template. It runs ok, except that the OnWorkflowItemChanged is firing more than one time for each change. It is the same funtionality... same definition.  The only difference is the workflow is for SharePoint 2010. I created another state machine workflow, a simple one with two or more states that contain an EventDriven( with OnWorkflowItemChanged) and setState activities. No other activities are defined.  No tasks are created. I have associated this workflow to a Custom List that I created for this test. The workflow starts when an item is created (or manually), then I modify the item from the list and the OnWorkflowItemChanged is firing more than one time. The same situation ... the same problem. I realized that the event is triggered so many times the OnWorkflowItemChanged activity is defined in the workflow. i.e. If the workflow has defined three OnWorkflowItemChanged, the OnWorkflowItemChanged will be fired three times when an item is modified. Anyone have an idea how can I fix this problem? I would appreciate any suggestions to resolve this.  

Shell Dimension - Not Time based

Hi   I am creating a shell dimension to create a hierarchy.  The idea is we want to know how much revenue we make from new accounts.  So I have created an account dimension and linked that to the Revenue fact.  I also created a Fact linked to the Date and User dims that will show the date the user was created.  By doing this, I was able to create a calculated measure that will show me total revenue, plus the revenue that is only for new players for a specific month: with member NewRev as aggregate( exists(DESCENDANTS([User Account].[User Account].[All], [User Account].[User Account].[User Account Key]) , [Date].[Date - Calendar Month].currentmember , "User Registration") , [Measures].[Revenue])   select {[Measures].[Revenue]  , NewRev} on columns , [Date].[Date - Calendar Month].[Calendar Month].&[201008] on rows from [Revenue] Sorry it is a bit messy, testing at the moment. What I would like to do is create a shell dimensions so I can create a hierarchy that will show new and returning players as members.  It would have an all level, or the user could split the revenue by this dim.  I set things up like the Time calculations shell dim, but am a bit stuck with how to create the mdx so that it will work with any measure. What would I change to do this? Regards Michael

Getting Query Time Out Problem in Particular Dimension?

We are getting query time out problem in particular dimension in SSAS. can any one help on this?  

How big is your time dimension ?

Hi, We have a time dimension which is used by around 90 columns out of 20 tables. We have a fixed time table which started in 1800-01-01 and ends in 2199-12-31. This gives around 150000 members in that dimension. That does hurt the performances and the users complain like why does the time start in 1800 ?. So we created a view a which says give the last 5 years and coming 2 years. Users are happy and the performance is fine. Until one day we added another system. That system has some "strange" dates in it. They are dates like 1900-01-01 ,1901-01-01,1966-02-23, 1995-04-31 but also 2017-01-01, 2019-01-01 or 2022-05-01 or even 2098-03-04. The guy who build the export says : I am not validating but only exporting what the user has entered. The guy who build the import says : I am only importing data and I validate only the type (dates like 2020-03-35 are rejected) So what should I do, make time big again and have angry users and bad performance ? I can make filters so that they won't show up but I don't like losing data and the check reports will fail. I can replace them with another date but I don't like that since I am manipulating data. I can convert them to unknown but I don't like that too. Any other suggestions ? And is a time dimension with 400 x 365 members big ? Constantijn    

Dimension Range over time

Is there a method for categorizing measures into ranged dimension attributes over time.  Consider the SQL:       SELECT date, sales = SUM(sales), segment = CASE WHEN SUM(sales) BETWEEN 0 AND 99 THEN 0 WHEN SUM(sales) BETWEEN 100 AND 199 THEN 100 ELSE 300 END      FROM tabl1      WHERE date BETWEEN '01/01/1900' AND '12/31/1900'   Date Sales Segment 1/1/1900 100 100 1/2/1900 150 100 1/3/1900 49 0 1/4/1900 175 100 1/5/1900 99 2 … … … Is it possible to apply this logic across a time range?  For example, this is on a daily basis, is it possible to do this on a monthly, yearly basis or for a range like '01/02/1900' - '05/25/1900' at monthly rollup? Month Sales Segment January 999 300 February 1 0 March 500 300 April 199 100 May 99 0 … … … I've done this using keys on the fact table; they aren't dynamic, but aggregate the measures into defined buckets January 1900, February 1900, etc.  My keys on the fact table are at the monthly level.

Slow BinaryReader Position Change Time


Hello, I have a question about basically a laggy position change time with a large file (actually, in this case I'm using a 20GB or so disk drive).  Basically what I'm doing is writing my own class that uses the CreateFile function to read raw data from a local disk drive, and then have an extract file class that allows me to seek to blocks (the file system is FAT) that the file occupies, then read the data, piece it together, etc.  I noticed though, that when extracting an 800KB file, it took about 10 seconds to do the process, and the main cause was that changing my reader's position took anywhere from 250 milliseconds to one complete second.

The short version: When extracting a file using my own classes, it took way longer than it should have, and the cause is changing the IO's position.


The code is exactly as you'd probably imagine:

for (int i = 0; i < f.BlocksOccupied.Length - 1; i++)
          br.BaseStream.Position = m.GetBlockOffset(f.BlocksOccupied[i], f.PartInfo);
So what I am asking is if there is any way to speed up the process of moving my posit

Change value of particular cell in Grid view at run time.



I need to know that how i can edit the particular cell value in grid view at run time just by clicking it(value) then it shows text box and after enter any value, it then save in database.

Waiting for response.

Thanks in advance.

Time Dimension


HI All,


I have seen that in on our cubes, the time dimension is setup as a regular type dimension instead of time. How would it affect the users? What's the process to change it back to time dimension? Please advise..


Thanks in advance.

DBType change from compile time to run time. I am not using a view, it is against the oracle db I do


The OLE DB provider "OraOLEDB.Oracle" for linked server "SOMESERVER" supplied inconsistent metadata for a column. The column "ACTIONITEMID" (compile-time ordinal 1) of object ""SOMESERVER_Action"."AI_ACTIONITEM"" was reported to have a "DBTYPE" of 130 at compile time and 131 at run time.

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