.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

Creating aggregations in SSAS 2005

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


I'm beginning to use the SSAS aggregations. I have created the aggregations for a cube after I have specified the estimated count and I have saved them without deploy them. Is it possible to see the aggregations without the deploy?

Any helps to me, please? Thanks

View Complete Post

More Related Resource Links

Kerberos between MOSS 2007 and SSAS 2005


I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.

We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail.  We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work.  We've used other materials we have on kerberos here.  But the end result is that the double hop is not happening.  We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services).  In every case the connection is not happening.

Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message).  Excel services works fine if I use the unattended service account, but when I switch the odc file to windows (should cause kerberos to kick in) it fails.  When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.

In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer.  I have no problems connecting to the cube directly through excel, so the security at that end passes t

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

SSAS 2008 and SSAS 2005

Olap cube created in SSAS 2008 and processed in SSAS 2008 gets same result of measure as the result counted by hand. However, the same cube processed in SSAS   2005 shows incorrect value. What can be the reason?

Excel 2007 connectivity to SSAS 2005 cube

Hello - I am using an excel 2007 odc file to connect to an analysis services 2005 cube (on windows server 2003 R2 OS). I receive the following error message   "Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server" Have already attempted the following fixes but running out of ideas now 1. Added localeIdentifier to ODC file    <odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=bisql;Initial Catalog=SLAM ACT BUD; LocaleIdentifier = 1033 </odc:ConnectionString> 2. Ensured that all dimensional attributes which are used in MDX calculations (named sets, calculated members) are set to "AttributeHierarchyEnabled  = True" Running out of steam so any help is greatly appreciated.

SSRS 2005 with SSAS Parameter is not declared

Hello, I'm builind a mdx query to my report in ssrs 2005 with ssas 2005 all on SP3. I'm having the hardest time to add a custom parameter to the query, I add it to the dataser parameters tab ("..." button). Then when I try to use it in my query I get an error: The query uses a parameter, which is not declared. I've seen some examples on the goo.. internet but none seems to work. My query runs fine like this STRTOMEMBER("[dimension].[entity].&[16]") but it fails if I try to do this.. STRTOMEMBER("[dimension].[entity].&[" + @entityid + "]") Am I trying to do impossible? :) Any idea on how to get such filter to work? My filters are a bit complex that's why I can't simply use the "Parameter" checkbox in the query designer mode. Thanks!

Trouble to connect report on SSAS 2005

Hello! I have deployed my first report (ssrs2008) using a ssas (2005) cube as data source but I can't get it to work. I setup the credentials to use Windows Authentication in the SSAS data source and when I open the report from the rs server it renders fine, however when I try it from a workstation I get the error below: The SSRS instance is not on the same server as SSAS. Any Clue? Thanks! Cannot create a connection to data source 'TestCube'. The connection either timed out or was lost. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host

Creating DSN for local machine in SQL Server Express 2005


Good evening,

This is my first time with SQL Server, so please forgive me if this is a ridiculous question:

I'm trying to create a DSN so I can connect up to SQL Server Express 2005 on my laptop/local machine. I'm attempting to connect via Windows NT authentication. I've tried 'Named Pipes' and TCP/IP settings but am not able to connect. I keep getting an error that states:

SQLState: '01000'

SQL Server Error: 2

Connection failed

SQLState: '08001'

SQL Server Error: 17

SQL Server does not exist or access denied

Is the server created by just installing SQL Server 2005, or is there something additional I need to do? Any help would be much appreciated.




SSAS 2005 - All Member


Hi All,

I've 2 product hierarchies and sales volume should be calculated differently for both the hierarchies.

e.g H1 : Sales volume = vol and H2 : Sales volume = vol * 2.5.

SCOPE ( DESCENDANTS([Product].[H1].[All Product]),
        [MEASURES].[*Sales Volume]);  
    THIS = [MEASURES].[*Sales Volume];

SCOPE ( DESCENDANTS([Product].[H2].[All Product]),
        [MEASURES].[*Sales Volume]);  
    THIS = [MEASURES].[*Sales Volume] * 2.5;

Except for "All" level everything else works fine. How do I make "All member show the correct agg value?

Any help is appreciated.

Thanks very much,


How to create Fact Table and Dimention Table in SSAS 2005 ?


Hi friends,

I am very new to SSAS world.

My question, can any one guide me , how to create Fact Table and Dimention Table ?


creating SSAS cube and dimentions from OLTP

I have an interesting case. I need to create a dw solution for an OLTP schema. Is it possible to create a dw solution using SSAS while being sourced using an OLTP? Thanks.

How to customize column names in Drill through action of SSAS 2005?

Hi Everyone,

Can somebody tell me about:How to customize column names in Drill through action of SSAS 2005?

I have defined drillthrough actions in SSAS 2005 cube. Drillthrough action is working very fine.

But while browsing the cube when i drillthrugh the data, my column names are shown as [$Employee Details].[Employee No], [$Employee Details].[Employee Name] etc.

I want to depict it only as Employee No, Employee Name etc.

Please help...


IN SSAS 2005, total count is incorrect for a partial month



IN SSAS 2005, when I navigate Cube->browser and I drag my fields "Day of week" to rows and couple of measures namely "M1" and "M2" to columns

and applied a filter "hierarchydate" in the filter section(eg partial month Jan 10 to Jan31), I get the total count incorrect. I also have the following observations

1) for example "Instead of giving Sunday "Sub total" for that partial month i.e "Jan 10 to Jan31", it is displayed with all the Total Sunday's count for all the years

2) IN Cube-> browser , it is working fine, if I apply the filter in "select dimesion" section instead of applying filter in "drop filter fields section"

Is there any such kind of issue in SSAS 2005?

Please reply me ASAP if you have any information

How to create a specific aggregation in SSAS 2005



I have created a SSAS 2005 prj and the related cube. I have created a SSRS report to query the cube, but the execution take more time. I think to create some aggregations related to one-two MDX queries. I have tried to build aggregation in BIDS but this feature seems authomatic. Is it possible to create aggregations based only on one or two MDX queries, please?

Any suggests to me, please? Thanks

Attach Database in Analysis Services 2005 (SSAS 2005)


Hi Guys,

I have some problem here..

I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..

does anybody have the script to attach the database?


Many thanks and regards...

Roland Andreas

SSAS - Aggregation wizard not finding anly suitable aggregations


Hi all

I am currently working on a financial reporting project. We created a cube that contains general ledger data. At the begining of the development phase, I run the aggregation wizard and SSAS was able to create aggregations. Yesterday I retried to run the wizard and to my surprise SSAS was not able to find any suitable aggregation. I searched on the internet to find out if someone experienced the same behavior and found the following link:

We have several defined hiearchies on the [Organization] dimension that can benefit from aggregations.

I looked at the design of the cube and could not find any reason that could explain the behavior of SSAS (not finding any aggreg.)

In the end I took the solution from the point where it was still able to create aggregations and started to redo all the modifications (one after the other) always running the aggregation wizard in-between. I was hoping that at some point aggregations would not work anymore and that I could identify which modification is guilty. 

Strangely I was able to perform all the modifications and the wizard was still able to build aggregations.

I the scripted the corrupt database and the non-corrupt database and compared them (using a text comparison tool). I was not able to find any significant difference.

Did someone exprience similar problems? :-) I kn

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