Recent content by Shab

Hi, What do you use to browse the cube? Do you use Visual Studio? Have you tried browsing it by using SQL Server Management Studio? or Excel? It sounds like you are missing a DLL or need an update on the software installed. Do you have the latest version of SPs installed? I also found...

Hi eo, I have a couple of suggestions. If your base physical measure is not visible to end users, then you don't have to set its aggregation to NONE. Set it to SUM and let the engine do its work. Then you only use its value when you want for your calculated measure. Since this is all users...

One way is to use SharePoint and Excel Services. SharePoint has a KPI Viewer part that can connect to SSAS and read the KPIs. You can also create an Excel book with Office 2007 and export it to SharePoint Excel Services. Look at ...

I found the answer to one of the questions I had. In order to get ranking with ties to sort the set in Ascending order, all you have to do is to specify the negative of the third paramter: For example Rank( Deimension.Currentmember, YourSet, - [Measures].[Sales])

The Rank function specifies an optional 3rd parameter for tied ranking. If you specify this parameter, the ranking ignores the sort order of the set (even if you sorted it before) and it sorts the set in descending order based on the third parameter value. Ties get the same rank but the next one...

In AdventureWorks database, I cretaed a calculated member as following: CREATE MEMBER CURRENTCUBE.[Product].[Product Categories].[Subcategory].&[26].Product1 AS [Product].[Product Categories].[Product].&[483], VISIBLE = 1 ; Product1 is equal to Accessories-->Bike Racks-->Hitch Rack -...

I followed the Time Intelligence Wizard in Adventureworks sample database to implement YTD,QTD and MTD for the Amount Measure in the Fiscal Hierarchy. When I use the BIDS browser to look at the data, I put Amount in the columns, Date.Fiscal hierarchy in the rows and then I filter on...

How do you turn automatic refresh warning off in the Excel Web Parts with an embedded external data source? I have created a SharePoint site where I have couple of Excel Pivot tables loaded in the Excel Web Services web parts. The Excel books get their data from SQL Server Analysis Services...

Yes, I had the same problem. You need to define a Trusted Location for Excel books. You can do this using the Central Administration site. Once you define a folder (for example a document library) you can put all your Excel books in there.

I am using Microsoft Reporting Services 2005 with SP1 on Windows 2003 server. I have also installed a HotFix that puts "Select All" back into the parameter option list. My report has 4 parameters, all of them have multi-select enabled. Sometimes when I run the report, if I choose every option...

Hi, If you have a monthly fact table that gives you the end of the month balances, and a change table that for each month gives you changes since the beginning of the month, how do you implement this in MSAS so that users can pick any day in the calendar and see the inventory levels for that...

I know it seems to be tough if not impossible. This article makes it sound like it is possible: http://www.windowsitpro.com/SQLServer/Article/ArticleID/6115/6115.html But of course it didn't work. Thanks for the reply anyways.

I have a dll file that I generated using VB 6.0. It has a user defined function in it. One I register the dll on my computer I can use the "USE LIBRARY <file Path> command in MDX Sample App to register it for the session and I can use the functions in the file in my MDX. Is there a way that I...

Hi Catadmin, Thanks for your reply. No I haven't been able to install reporting services on my server yet. I have the report designer on my computer (a client machine) and I can open the designer. On the server however, there is no need for the designer and I should be able to install the...

Hi Catadmin, Thanks for your reply, but I am not clear on what you suggested. What do you mean by Visual Studio 2004 edition? We have VS .NET 2003 and then I am not sure if we have an additional license of VS for the server. Do you mean I can get to the Reporting Services installation through...