I am using Analysis Services 2005 and I need to create a new measure “y”, for which I have to take the logarithm of another calculated measure "x".i.e. y= ln (x) (where x is another calculated measure within the cube).In AS 2000, there is the function LOG available, and in AS 2005, it somehow ...

Here is the scenario: 3 different company dimensions, "Billing Country","Receiving Country","Main Country" There are three companies in these dimensions: Canada, USA, Denmark. Now, in actuality there are more countries, but we'll keep it simple in this example. This makes the possible ...

All I want to know is...Is it possible to have an ODBC data source in Analysis Services 2005?(I am using the June CTP of SQL 2005. I create a new Analysis Services Project using VS 2005. When I try to add a new data source, "ODBC" is not listed in the Provider list. What am I doing wrong?) ...

Our code is throwing an exception when we try to serialize a connection exception object. The error is show as: Invalid cast from Microsoft.AnalysisServices.AdomdClient.ConnectionExceptionCause to Microsoft.AnalysisServices.AdomdClient.AdomdErrorCollection. [InvalidCastException: Invalid cast ...

I get the following error when trying to build a cube when the measures are created from a data source view with two data sources both SQL Server 2000.There error is:Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being ...

Hi,I've started getting this error (Internal Error: Parameter is not Valid) when attempting to deploy my analysis services project. I get the same error whether I try to deploy from within the visual studio environment or try to build a deployment script and run it from within SQL Management ...

I have two SQL Server db's that I have to delete a bunch of old data from. What is the simplest and quickest way to accomplish this? Yes I'm new to DBA tasks. Any help will be greatly appreciated. Thanks

Hello, I am developing an application where I need to load custom data to Analysis Server (MS-OLAP) without going through any OLE DB Provider. I am able to load data into dimensions/cubes using Microsoft OLE DB provider for ODBC Drivers. But my requirement is loading data at runtime from a ...

"Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated."OK. I'm stumped.I already tried refreshing the data source view, I refreshed the cube (both times selecting refresh from the context menu). ...

Hi, I would like to compare current YTD (2005) with 2004 YTD, how do I do that using MDX? ParaLLELPERIOD (Year) and PERIODSTODATE(Year) ?

Hi guys,I'm using sql 2005(june ctp) and installed patches.When I try to browse my processed cube in either management studio or dev't studio, the analysis services stops.Below is the error message from the event log.The connection either timed out or was lost.Unable to read data from the ...

eyoo mates,i have installed SQL 2005 on Windows 2003 SP1 with sharepoint services 2.0 SP1 and .Net framwork 2.0...everything was just cool, but since that last report i can′t start the ANALYISIS Service anymore...I recieve the following in the eventlog:Soource: Schedule and Delivery ...

I have a developer that I am trying to get connected to an Analysis 2005 cuber from Excel. He is able to make the original connection, can see the database, etc. When it tries to fetch the data to the spreadsheet he receives the following err:Initialization of the data source failedAny ideas? ...

Is it possible to install and utilize AS2005 without SS2005 anywhere in the picture? We'd like to use our current Sql Server 2000 setup with AS2005 (preferable on the same machine). Any insights or links are appreciated. Thanks, JGP

Hi,I've created a cube and now i'm trying a add a time dimension, it gives me an error. the time dimension i've created is using server time dimensions which has year, quarter, month and date attributes, when browse the dimension it looks fine but i'm trying to add this to cube and try to ...

I'm trying to get the KPI's (Key Performance Indicators) from SQL Server 2005 - Analysis Services 9.0 by using VB6 and the OpenSchema method. According to SQL Server Books Online the MDSCHEMA_KPIS rowset should do it. Anyone know where to find MDSCHEMA_KPIS GUID? Rgds, Jan

Hello, I have a VS 2003 web application that access to SQL Server 2000 database. Now I created a cube on SQL server 2005. I have no problem to access to my cube by ADOMD.NET, but I can't process the cube. If I use DSO, I have an exception, and AMO doesn't work with VS 2003. It's impossible ...

We used profiler to see what the difference was between the Excel Add-in and the cube browser in Analysis Services 2000. We created the same reports in both, and the Excel Add-in did not pass the page filter parameter to the stored procedure that processes the drillthrough request. It works ...

I am having a Time dimensionTwo hierarchies - Calendar and Financial have been defined on itThe Time dimension is based on the view Time_vwAttributes are 1. TimeID2. Year3. Month4. Financial Year5. Financial MonthFinancial Year starts from Octoberi.e. if Calendar time is Year:2007, Month:12 (Dec), t...

I have a need to model an interesting M-N relationship within Analysis Services 2005. However, this M-N relationship is different from that given as the example in the AdventureWorksDW database. So, I'm wondering how best to go about it.In the AdventureWorkDW database, the FactInternetSales ...

When you use BI Dev Studio or SS Management Studio to process an Analysis Services database or object, there's a nice dialog box that shows very robust status and progress information.Is there any way to capture this information if you are processing something programmatically? Specifically ...

When creating a role in AS 2005 and specifying dimenison access (on the Dimensions tab of the role definition in BI Dev Studio), why do some dimensions have the option of "None" as access level while others only have "Read" and "Read/Write"?For example, in looking at the Adventure Works sample ...

In Analysis Services 2005, you can limit the number of records returned on a drillthrough action. It would be useful to be able to order the records before the number of records are truncated, how can you do this - in effect use an OrderBy function? Any help is appreciated, Dan

How do you slice a Cube Partition, if you want it to slice by "less than" instead of "equal to"? Analysis Services does not give you a choice. Example: Time.FiscalYear AllTime.FY2005

Hi, All, I posted this question on http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us and http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=211308, but only got 1 response so far. So I am trying here. Our IT department is ...

Can anyone provide an example of the right syntax for the CREATE SUBCUBE statement? And possibly discuss its use a bit? For example, from a client tool (like Excel), would there be any way to execute a CREATE SUBCUBE statement such that all browsing done within Excel was bound by the scope of ...

Anyone know how to configure this yet? Would like to be able to test client access to Analysis Services 2005 using an http connection instead of a direct connection. It doesn't look like this is documented in BOL yet (at least not in the June CTP build). Thanks, Dave Fackler

Hi friends I have a funny situation. I have a period dimension which contains Year, Qtr, Month. I also have another Time dimension which contains Mth1 .. Mth25. The 2nd Time dimension matches that of the 1st Time dimension ie. Mth25 is 2005.April. and Mth24 is 2005.March and so on... ...

I'm new to Analysis Services package in SQL2K. As data analyst I wanted to create a short presentation that would explore most advantages of using Analysis Services (Cube, datamart). Questions: 1.Does this tool (Analysis Services) come with SQL2K?2. Is there any light version (or client ...

HiI haven't done much with AS2005. Today I was trying to migrate an AS2000 cube to As2005 using Migration Wizard. Existing AS2000 cube is on Windows 2000 Server (SP4). Destination server has Windows 2003 Server with June CTP.Migration Wizard goes through the validating databases. During ...

Hi,I've got a dimension table with an Int32 primary key. I have a few fact tables that have an Int16 field, which is acting as a foreign key to the dimension table. I can't actually change the data types of these tables in the SQL database, but I'd still like to create a cube that uses those ...

<font size="1">Hi, I was wondering if anyone knew how to 'build' an 'analysis services' project (i.e - generate the .asdatabase file) from the command line, so that I could have it done automatically during a build process. Thanks, Kobi Reiter </font>

I get the following error when trying to process a cube on the server. Error 1 Memory error: The operation cannot be completed because the memory quota estimate exceeds the available system memory. 0 0 It runs on a Microsoft Windows NT 5.2 (3790) with the JUNE SQL 2005 Developer release. I has ...

In Analysis Services 2005, using the Business Intelligence Wizard in the BI Development Studio to add time calculations to a cube worked fine when only base measures are included in the scope. When a calculated measure is added to the scope of the Business Intelligence Wizard time calculation, ...

I have written some code to process partitions in parallel, but I'm not seeing the performance improvements I was expecting. Plus, perfmon indicates that only 1 partition is being processed at any given moment.Each thread is creating a separate connection to the cube. The object below is ...

Hi, I am observing a degradation in the CellSet.get_Item function times as I traverse through the Cellset return in response to a MDX query. The .NET (C#) application fires an MDX queries and traverses each Cell in the returned CellSet. The traversal is sequntial and in the order of the Cells ...

Hi,I'm having a bit of trouble with drillthrough, hope someone can help.When the user drills through, I would like them to retrieve some records that are located in another table - not in the fact table.E.g. if they drill down on one record of with a data value of 100, they should see 4 ...

I am using the July CTP of SQL Server 2005.Books Online indicates that the Business Intelligence Wizard in the BI Development Studio supports parallel period calculations. I did not see this class of calculations in the list. The available calculations were Year to Date, Quarter to Date, Month ...

In Analysis Services 2005, once you’ve used the Business Intelligence Wizard in the BI Development Studio to add time calculations to a cube, how do you come back later and add additional standard time calculations based on the named calculation that was already created in the cube’s data ...

Hi,I am trying to get Distinct Count of Users phone number. the Data type of the column is char.From that i have to take distinct count or disting phone number list using OLAP process. I wish to get Distinct count of the Phone number Column or Distinct phone number list.Expecting reply.Thanks...

Hi guys I have built several cubes. However I would need to create local cubes from the built cubes in Analysis Services. As a result I need to work out the DDL for my existing cubes. However the cube contains many mdx calculated members. I was wondering if it would be easier to simply ...

Using Developer 2005 The Analysis Server is Started The fact and dimension tables are in an Access DB locally on the machine. The cube builds fine but when I try to view it in the Brower tab (VS) I get the following error: Either the user, Dev3\User, Does not have access to the ASP1 ...

In SQL Server 2000 Analysis Services, we use the VBA IsError function to determine if a generated member name actually exists in the cube. See the following example... StrToMember (Iif (ISERROR(StrToValue("[Start Date].[Month].[" + Format(Now(),"mmm yyyy") + "]")), [Start ...

In asp.net 2.0 How can I use the KPIS and show the semaphores as the balanced scorecard?

I have backed up an AS database. Now I want to restore it to a new name so I have two copies to play with. How do I do this? Thanks, Chris

MS Excel XP on Windows 2000 fails to connect to OLAP 2005 Cube with the OLAP 9 Provider. Excel gives the error: <initialisering datasource failed>. The same error appears when I try to connect to OLAP 8 cubes. Before I could access OLap 8 cube, I had to reinstall Office XP.Windows XP with ...

I hope I described that right!I have a dimension attribute that describes a self referential hiearchy in the dimension. I have this setup and working with one exception. When I use this hierarchy I only want members which have children to be displayed at each level instead of all members ...

I have a dimension attribute called Month. It is sorting alphabetically instead of based on it's underlying key value. How do I change this? Thanks, Chris

I'm trying to create an automatic deployment for an analysis services project I've created.I've used the deployment wizard to generate an xmla file which can deploy my database. The file works great if I open it within the Management Studio and press the 'Execute' button.The question is ...

Much of what I am reading about the new BI functionality inAnalysis Services 2005 speaks as how the UDM "blurs theline" between Relational and Multidimensional data. Oneexample is how it is now easier to create a invoice or billof materials report in AS2005, something that has alwaysbeen simple ...