One of my company's clients have a 2GB MS Analysis Services(AS 2005) Database with 3 cubes and 23 dimensions. Every day the entire DB is processed to...

swati

09-07-2010 11:43 AM
swati

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

08-31-2010 01:27 PM
nntp@microsoft.com

Hi ! I am running AS2008 on Windows7. Each time, when i execute an MDX query, my perfmon is always equal to 0. Any Idea ? Thanks

MIB

08-23-2010 10:00 AM
MIB

Hi all I am using the Microsoft.AnalysisServices DLL to access my Cubes KPIs. From here I can set a Value, Goal etc. What I am trying to do now is...

Graham Evans

08-23-2010 03:23 AM
Piotr Naszarkowski

Hai Learn TIBCO and via video tutorials,contact http://tibcovideotutorial.webs.com/ PLEASE PASS IT YOUR FRIENDS This site contains video tutorials...

Kiran java

08-22-2010 09:28 PM
Kiran java

Hello, after I formulate an mdx script that returns the results I want from the cube using the SSMS, what is the process for getting the results to...

Jason

08-20-2010 03:06 AM
Michael Tsai

Hii, I have an olap server which is having a olap log is about 4Gb .I am not able to open this log as it is having a huge size.I want to schedule...

karimullas

08-18-2010 02:18 AM
Piotr Naszarkowski

Hi, I faced the problem with SSAS 2008 that seems to be a bug. The problem occures on the production system, but I've managed to create simple case...

sierzant

08-17-2010 07:45 AM
sierzant

Hi, I faced the problem with SSAS 2008 that seems to be a bug. The problem occures on the production system, but I've managed to create simple case...

Piotr Naszarkowski

08-17-2010 07:23 AM
Piotr Naszarkowski

I would lik to create an action (target: cell) that returns a rowset from the current cube. I can't use drillthrough because I only want to use some...

Antoon

08-12-2010 05:32 AM
Antoon

Can you use SSAS to create your Data Warehouse and then use other OLAP programs to do your cubes and reports? For example, if I want to use Micro...

tshad

08-10-2010 03:16 AM
Marco Russo

Hi - When using linked SQL Server definitions, and using sp_addlinkedsrvlogin, is there any way to designate the remote user as a Windows Domain...

John Beatty

08-06-2010 02:28 AM
Prakash - Savvysoft technologies

Hello, I need some help to build an mdx query. the problem: I want count the number of costumers that have the age equal 20 (years old) in a specific...

cafc2010

07-22-2010 05:04 AM
david.alvarez@iccube.com

In the cube I can see the measure has a name (e.g. measure_1) and description (e.g. Longer Description of Measure 1) property. I would like the MDX...

Tyler Allbritton

07-20-2010 10:23 AM
BugEyes

Hi I have an mdx query that returns a result set of the top 10 items. I need to use the result set and update the the same items in the source SQL...

Que

07-09-2010 07:53 AM
grzegorz_s

Hi, I am getting the following error while processing full cube in production. It is a SQL Server 2008 Enterprise edition on Windows 2008 R2 with 64...

Neeraj

07-09-2010 07:41 AM
grzegorz_s

Is there have a way to find out how many records and file size for the given measures group or dimenision from the Analysis Services Cube.

kent kent

07-06-2010 05:55 PM
kent kent

Calculated Members do not seem to aggregate when a SCOPE is applied - is this fixed in R2 ? Sample data: select CONVERT(date, report_date)...

im

07-05-2010 10:01 AM
im

Hi All, I’m currently working at an Insurance company and need to provide following calculation: We have claims as follows: ClaimNumber ...

DominicB

07-01-2010 05:15 AM
DominicB

I'm trying to create a calculated member in my Analysis Services cube that returns a count of the number of members of a particular...

Tim

06-30-2010 02:20 PM
Tim

I need to rank a collection of members. The member set appears in the where clause so using the currentmember attribute doesn't work. ...

Mitch McBride

06-30-2010 02:22 AM
Mitch McBride

I enabled http access to my SSAS 2008 project. I am able to connect to the project and the cubes via http://servername/olap/msmdpump.dll I tried...

hummel

06-24-2010 10:29 AM
hummel

Hello all. I have a single flat table of stuff that I would like to "put a cube on top of", and was wondering if there is a way to programatically...

SnapDive

06-22-2010 06:30 PM
SnapDive

Recently we upgraded to SSAS2008 from SSAS2005, and since that upgrade we've been experiencing locked files while running a Process Update on a...

Jesse O

06-15-2010 11:12 AM
Epan

Hi, how can I use named sets in sql server roles. I've tried to use 'with set' but I don't get it to run. Regards Michael

Michael Kugler

06-14-2010 01:12 PM
Michael Kugler

How can I programmatically determine the exact location of the Analysis Services Deployment Wizard. I know that the default location is: "C:\Program...

tko

06-11-2010 04:02 PM
tko

I just posted a few basic questions about creating a cube. I also have a few questions about creating an easy to use cube especially for Excel...

Ben

06-08-2010 09:19 AM
Ben

I am learning Microsoft Analysis Services (is the standard MSAS or SSAS?) and I am a little confused about a few things: -Is it me or is loading a...

Ben

06-08-2010 09:16 AM
Ben

I have a boolean column that I would like to count the ones that are true and use the result as a measure. I thought I could use an expression...

Tom

05-31-2010 10:23 PM
Tom

Hi I have an financial cube where I want to make calculation for the accounts that are SUM accounts (that is account with no actual posting - only...

jazpar

05-31-2010 01:57 PM
jazpar

I am getting the message Dimension : Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration so that it is...

Tom

05-30-2010 05:22 PM
Tom

For some reason, when I add views to data source view in SSAS, some of them have completely incorrect logical primary key. But I cannot find a way...

Vimas

05-27-2010 07:06 PM
Mtimonera

I'm trying to choose only the Top 10 accounts based on the number of reviews. I've managed to do this using a filter outside of the query, but I want...

Bostock

05-27-2010 03:45 PM
Bostock

The Time Is Coming ! Prepared for about a month, our cheap ghd website has been on the market formally this week .The product series in our website...

ghdfans2010

05-27-2010 05:23 AM
ghdfans2010

What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft...

nntp@microsoft.com

05-21-2010 04:54 AM
nntp@microsoft.com

We have migrated AS 2005 to AS 2008. Majority of jobs worked fine. Few Admin related jobs, I am having problem. 1. I have job for AS 2005 which is...

Kris

05-20-2010 08:37 PM
epdAaronK

Hi, I have a data source in sql server database and use one query to update the data every night, just found my report won't update unless I open...

05-20-2010 07:23 PM
epdAaronK

Hello, I have a customer who is using Office web components 11.0 in this asp.net application. Earlier when they were accessing SQL Analysis Services...

Varadaraj Bhat

05-20-2010 07:21 PM
epdAaronK

I am building a cube using AMO and am processing it fairly regularly (several times a minute). I am doing this more to discover where my boundaries...

Ad

05-20-2010 07:20 PM
epdAaronK

Hi, I am running XMLA through a C # program (VS 2008) like this: try { adoConn = new AdomdConnection(...) adoConn.Open(); cmd =...

WEBF

05-20-2010 07:18 PM
epdAaronK

There is any way to call the SSAS COM from a VB application? I want a way to "masquerade" the Microsoft Visual Studio/File/Open/ Analysis Services...

Juliano

05-17-2010 07:00 PM
epdAaronK

I have a 1.8TB drive with 310GB free. I'm trying to overwrite an existing backup that has a size of 268GB compressed, with the data size of...

Jesse O

05-17-2010 10:34 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

I'm having trouble migrating a local cube from SSAS 2000 to SSAS 2008. Foodmart. Brand new install. SSAS 2000 SP4 SSAS 2008 SP0 I'll try...

epdAaronK

05-17-2010 10:31 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA]

Hi, I’m new to SSAS and I’m hitting a Security puzzle that I’m struggling to solve. Our simple cube contains IT Billing information for our...

Rich

05-17-2010 02:09 AM
Rich

Hi, I’m new to SSAS and I’m hitting a Security puzzle that I’m struggling to solve. Our simple cube contains IT Billing information for our...

Rich

05-16-2010 12:46 PM
Rich

Hi I have a Cube that consists of a Net Sales Value Measure , linked to a Company Dimension and a Salesperson Dimension. The same Salesperson could...

Que

05-14-2010 04:17 AM
Que

Hi all Just trying to get to grips with cubes and have setup a test server with SQLSVR2K and Analysis Services. Like a good boy I've installed SP4...

Nick Horrigan

05-13-2010 11:05 AM
Nick Horrigan

I am trying to deploy my cube on a new installation of SQL Server and Analysis Services 2008. When I try that it gives me the following error:...

AmirCharania

05-12-2010 01:59 PM
AmirCharania

Sorry, in the subject I meant SSAS 2008. AmirCharania wrote:

AmirCharania

05-12-2010 01:57 PM
AmirCharania

I wonder if anyone has run into this before. I'm trying to produce a report in which all rows are sorted by a specific column. For example the...

Stan Kondrat

05-10-2010 02:51 AM
amish