Please help me understand... I am using Radatsoft cube browser control in an ASP.net web application, my web server is in the DMZ and my SQL(OLAP)...

steve kennedy

11-29-2009 06:24 PM
Will Alber

We have a server with Analysis Services 2005 SP2 and the SQL Server 2005 SP2 Enterprise. AS processing is failing and performance counters point...

Handyman

11-29-2009 02:37 PM
Will Alber

Hi , I have cube with four dimensions: (levels:, ,), (level ), ( levels: ,,,), (level .) I have to aggregate data from lowest level. I have...

Dorota

11-29-2009 10:33 AM
Dorota

Hi all, I've found some posts that this feature is not working (unless applied onto leaf levels) in 2005, and now I'm trying to get it working on...

Igor

11-24-2009 04:21 AM
Igor

SELECT NON EMPTY {TopCount({Crossjoin({.},{...AllMembers})},20,.)} ON COLUMNS, NON EMPTY {hierarchize(TopCount({.. .AllMembers},20,.))} ON ROWS FROM...

rupniceguy@gmail.com

11-19-2009 02:30 AM
rupniceguy@gmail.com

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 07:26 AM
Mia

Hi, I am Trying to connect to the SSAS from my PC, But i was able to connect to the port of SSAS and the Port number named 2383 is listening to the...

anandsrn

11-17-2009 06:30 AM
anandsrn

Hi all I have 6 years of finance data that relates to a project, the fin data contains future years forecasts ie. Year 1 to 6 I want to calculate...

Scotchy

11-17-2009 03:24 AM
Scotchy

I have a financial cube with 6 dimensions: Date, Account, Version, Database, Department and Branch. Before I add a unary operator to the Account...

Craig Booth

11-15-2009 11:28 PM
Craig Booth

I need help on a simple MDX query. It is to find 1) the latest HeadCount or 2) the HeadCount of today. Say, if today is aug 15, 2009. the basic...

light_wt

11-15-2009 05:34 AM
amish

Hi, I want to use properties as tooltips in Excel2007/SSAS2005 sp3. I try "Pivot Table Options/Display/Show properties in tooltips" in Excel but the...

Jerome

11-13-2009 03:52 AM
Jerome

We have olap users accessing olap cube using excel 2007 and ProClarity. All users are able to access without any issue in office from both excel 2007...

Kris

11-12-2009 06:19 PM
Kris

We're going to be taking on about 50 Linux desktops that will need to query SSAS2008. We currently use Proclarity Desktop (windows XP) so we're...

Jesse O

11-12-2009 03:54 PM
Jesse O

Hi, I have a question based on the need to use OR operator in a MDX query. How can I filter a query using something like this conceptual...

. .Ronen

11-11-2009 12:52 AM
. .Ronen

Hi all, I’m working on a conversion from SSAS 2005 to 2008. I'm getting extremely poor performance when processing multiple partitions...

Joe Sampino

11-10-2009 01:07 PM
Classiarius

With sql server 2000 Personal edition I was able to load the Olap server on my workstation on practice some mdx queries on a cube with the sample...

Rich

11-09-2009 03:31 PM
Rich

Sql server 2008, AS question: Have a cube with 5 partitions Using SSIS to build & deploy cube Each partition represents a day of data. Each day the...

Tim

11-09-2009 02:20 PM
Tim

Hi, Can any one help me with sorting the data year wise for below MDX without much changing the MDX means that data should be displayed...

rupniceguy@gmail.com

11-09-2009 07:01 AM
amish

Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term...

nimesh

11-09-2009 03:15 AM
nimesh

Hello Everyone I have a dimension called DIM_REFERER_MASTER with following columns referer_id bigint referer nvarchar(2048) referring_term...

nimesh

11-09-2009 03:06 AM
nimesh

I am seeing an error in my Application log at various times with the following: Log Windows NT...

Andy Thissen

11-06-2009 02:40 PM
Andy Thissen

We at, Nob Hill Software, are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx You can read all about it on the above web...

Itamar

11-06-2009 05:15 AM
Itamar

Using a Dynamic Named Set won't help here, because it isn't re-evaluated for every cell in the result set. Directly evaluating the Top 2...

dpuri

11-02-2009 03:12 PM
Json

I have created a PivotTable that queries a local cube file. This .cub file (Analysis Services 2008) is updated every week The structure remains the...

Minas Papageorgiou

10-31-2009 04:33 PM
Minas Papageorgiou

Hi, I'm trying to hide a dimension (in all cubes) for a role but there are no alternative for the Access property like "none" in the Dimension tab...

Jerome

10-28-2009 05:04 PM
dpuri

this is my case... i have a measure called Rank with this value: 3 2 4 1 ad a dimension OPTION with the members OPTION - Percentage

Carnefrisca

10-28-2009 04:30 PM
dpuri

How do I recieve and implement user input for (measure) cube writeback on analysis service 2008?

Newbe

10-28-2009 04:48 AM
Retha via SQLMonster.com

How do I recieve and implement user input for (measure) cube input on analysis service 2008?

Newbe

10-26-2009 05:45 AM
Newbe

Hi, does anyone know how to get a list of availabe AS-Servers in the network programmatically using either AMO or ADOMD.NET? Regards -- Dipl.-Ing....

Ralf Steinstraesser

10-23-2009 07:29 AM
Ralf Steinstraesser

Hi, with ssis I can create a OLE-DB Datasource to access the dimensional tables in an cube. The only think I have to do is to choose the MSOLAP. 4...

eljay

10-23-2009 02:07 AM
eljay

Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that...

Thomas

10-22-2009 07:23 AM
Thomas

Warning: I suspect it'll take a hotshot SSAS guru to sort this out. As noted in the title of this question, my basic problem is that I'm getting...

LawnMowerHater

10-22-2009 02:48 AM
Marco Russo

Hi, Just wonder how am going to filter member by using the following command. ..ExcludedMember = (" ") --> if i want to filter customer Last...

Lester Lim

10-21-2009 09:16 PM
SQLKID

Hi I have do to a distinct count of employee id based on whether the sum of their hours worked is greater than 0 at the various intersections of...

SQLKID

10-21-2009 09:12 PM
SQLKID

We have MicroSoft Office Excel 2003 and PerformancePoint Server 2007. We have several Analytic Charts with the legend on the right hand side. Often...

MervynScarlett

10-20-2009 03:35 AM
MervynScarlett

Hi there, I am new to SSAS, and I was wondering wether the following was possible : - One fact table : myTable myTable contains many codes...

Stefan[www.itsconsulting.fr]

10-16-2009 06:37 PM
dpuri

My time dimension is Year-Month-Week-Day, but I want to query the total week, not the week from that month. Below is a sample query where I get 2...

CIndy Lee

10-16-2009 06:21 PM
dpuri

Hi, I would like to know is there a simple way to export the configuration of the Cube from one SSAS to another SSAS that could be on another...

Stefan[www.itsconsulting.fr]

10-16-2009 12:54 PM
LawnMowerHater

Hi, I will construct AS cubes on a server I must not be server "administrator" on , so we added my user in Analysis server Properties /...

Jerome

10-16-2009 03:32 AM
Jerome

Hi, has anyone tried above and want to share some insights? I would be interested in trying it with a relational datasource. Regards -- Dipl.-Ing....

Ralf Steinstraesser

10-16-2009 03:30 AM
Ralf Steinstraesser

Hi, my cube has an drillthrough action. When I drill (in BIDS) on one month = one transaction things work, when I drill on a quarter with 3 months =...

Jerome

10-16-2009 01:52 AM
Jerome

Hi, since I have installed Windows 7 I have a problem to connect to my SSAS Server Cubes. When I connect local on the server everything is working...

hal9000

10-15-2009 02:42 PM
hal9000

HI Just wondering anyone out there who've had success in implementing security on measures i SSAS2005 I've tried to deny access to...

fsk@platon.net

10-15-2009 07:15 AM
fsk@platon.net

I've been getting this error: XmlaError: Errors in the OLAP storage engine: An error occurred while processing the indexes for the X...

Jesse O

10-13-2009 04:54 PM
Jesse O

Hi - we have a cube that we are using to do some business scenarios. We have a collection of businesses that contribute to a particular account. We...

kristl

10-13-2009 08:03 AM
kristl

Hi All, I've installed BI portal in version 4.0 regarding SSAS2005 but I want to have possibility to access to cubes from SSAS2000 from this portal....

adam

10-13-2009 06:32 AM
adam

Hello, Is it possible to analyze (sniffing?) the data transfer between the OLAP server(Analysis Service) e my application pool on IIS? (actually i...

Carnefrisca

10-13-2009 03:40 AM
Carnefrisca

Los Angeles Carpet Cleaning also provides Carpet Steam Cleaning, Upholstery Cleaning and customer service and quality assurance throughout your...

emil

10-12-2009 11:27 AM
emil

Hi, I have fact table containing a column , and there are measures for example totalsales ,averagesales . I would like to calculate the median...

John Jayaseelan

10-08-2009 06:17 AM
John Jayaseelan

Install the hotfix from microsoft and should work. worked fine for me. http://support.microsoft.com/KB/947648 Panos From...

Panos

10-08-2009 04:50 AM
Panos