Search results for query: *

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...

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 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...

We have Windows 2003 server with SQL server Enterprise with sp3a installed on it. It also has IIS and ASP.Net installed and configured. When we try to install Reporting Services (doesn't matter what edition) we don't get any options to select the parts that we want. The installation skips all...

Hi all, I have a cube that has some hidden measure and I would like to get a list of them with ADOMD. However I can only get the visible ones. Any ideas? Do you know an API that would do that? Here is my code: Set iCubeD = mCatalog.CubeDefs.Item(mCubeName) For i = 0 To...

Are there any wild card characters in MDX like there are in SQL? For example I can do this in SQL: Select * from Employees where name like 'abc%' Can you do that with MDX? Thanks, Shab

Hi all, I have a VB program that connects to a cube and fetches data using ADOMD.Cellset. This program is installed on a Citrix machine, so different users use the Citrix client to ge t to it. When logging you can chose to log to workstation only.This means you will not see the mapped...

Hi All, I have a file that has fixed row size of 148 and fixed column size, but the file has no end of line character. I know it is wierd but a client has made the file and refuses to change the format. So I am stuck with reading it the way it is. In Enterprise Manager, I used the...

Hi All, I have a table with 3 columns. Product, Location and Value. The data looks like this: NULL NULL 100 Atlanta NULL 50 Atlanta Cookie1 30 Atlanta Cookie2 20 Dallas NULL 120 Dallas Cookie1 80 Dallas...

FoodMart2000, this query returns 0 months for my predefined quarters, where as the way I define them, there are only one month in each. Any idea? WITH MEMBER [Measures].[Count] AS 'Count(Descendants( [Time].currentmember ,[Time].[Month],SELF))' SET [Month7_Set] AS...

FoodMart2000, this query returns 0 months for my predefined quarters, where as the way I define them, there are only one month in each. Any idea? WITH MEMBER [Measures].[Count] AS 'Count(Descendants( [Time].currentmember ,[Time].[Month],SELF))' SET [Month7_Set] AS...

I have a cube similar to Sales in FoodMart_2000 and I have an interface that I let users make selections on Time, for example select a few months and then they go to another tab, where they can look at the results from the cube for their selection. My problem began when I let them select at a...

Hi all, Using FoodMart 2000, I have a calculated set formed of two quarters in 1997 and I put that on rows. For each row I want to calculate how months are in that row. (In this example I know the answer is 3, because all quarters have all months, but my other cube does not have all months in...

Hi all, Using FoodMart 2000, I have a calculated set formed of two quarters in 1997 and I put that on rows. For each row I want to calculate how months are in that row. (In this example I know the answer is 3, because all quarters have all months, but my other cube does not have all months in...

Hi All, I have an Analysis Server 2000 with SP3 in our domain. I have created a role for the OLAP database using &quot;Everyone&quot; as user. And I have enabled this for my cubes. All users can access the cubes and browse using couple of client tools including Microsoft Excel pivot table, but...

Has anyone seen this message before: &quot;Server is either not started or too busy&quot;. I just installed service pack 3 on our Analyisi Server and now the service works on and off. If I try to open the server from Analysis Services, sometimes it works, sometimes not. The same happen while...