I would like to understand what are the main difference between runnin Analysis Services on LOCAL SYSTEM, LOCAL service and NETWORK SERVICE. I think...

MIB

02-13-2009 09:50 AM
MIB

Hello, I am trying to create a new measure in my SSAS 2005 Cube, here is the situation assume I have two dimension Product Dim Business Commodity

erdal akbulut

02-13-2009 09:48 AM
erdal akbulut

Hi there, We have built a cube using SSAS 2005 and have a customer natural dimension that has eight attribute dimesion levels. The seventh level has...

jpo

02-13-2009 06:25 AM
jpo

How do I write an MDX query to select distinct count of all order numbers where 'source' = 0 SQL equialent : SELECT DISTINCT COUNT(ORDER_NUMER))...

Polzovatel

02-13-2009 05:29 AM
Polzovatel

hello all, I need your help for an MDX issue that I have. Any help is appreciated. In an MDX query that uses Non Empty keyword for columns and rows...

dagriq via SQLMonster.com

02-11-2009 10:43 PM
dagriq via SQLMonster.com

Hi all, we're using Analysis services 2000 SP4 and have set up a dynamic security system as follows: 1. MOAP cube C1 holds the data 2. ROLAP (+real...

Igor

02-11-2009 09:59 AM
Igor

I am sure this question (and answer) is so basic, but I need to know how I can bring my project (created in Visual Studio) into the MS Analysis...

denwill via SQLMonster.com

02-10-2009 09:59 AM
Todd C

Hello, I have a problem with the scope statement in a cube on SSAS 2005. Here is the code of my calculs code: ********** Scope ( ..&,..&

olap user

02-09-2009 09:35 AM
olap user

I have several SQL 2005 servers all in domain environment most using sql and windows authentication. I also have a couple of SQL and Analysis...

Dave Patrick

02-08-2009 03:05 PM
Sylvain Lafontaine

I have few questions about designing a multi-dimensional cube. At the moment we are using SSRS 2005. The problem is that report building lasts to...

MB

02-07-2009 06:04 PM
MB

Guys, I am trying to show Totals in my result set at the Group level only, like this: Program Theme Product ...

sitexcite@hotmail.com

02-05-2009 10:51 PM
sitexcite@hotmail.com

Basically i am trying to run an MDX query that can aggregate on a custom date range. I need to know the number of days in the custom period. WITH...

cobr94@gmail.com

02-05-2009 02:35 PM
cobr94@gmail.com

Hi, I keeping getting error trying to deploy the cube to Analysis Service Server 2005. I read some help from internet and some one recomended to...

Han

02-04-2009 09:38 PM
Roman Yusfin

hi, in my project there are calendar and product dimensions and sales measure group. and product dimension has a hierarchy such that: . what i want...

Abdullah AKOGLU

02-03-2009 12:12 PM
fimiani@exologic.com

Hi All, We are using Excel 2007 for connecting Analysis services cube and it become very slow after selecting columns from dimensions. Can someone...

Herbert R

02-03-2009 12:08 PM
fimiani@exologic.com

Hi, How I can deploy AS 2005 project/solution to new environment?The files I are all xml files like dimension ,cubes file. Also database,dwproj...

PSO BI Team

01-31-2009 08:11 AM
João Reis

Hi anyone (especially those called Mosha or Deepak) I am getting very frustrated with the NON EMPTY BEHAVIOUR on my year to date calculated...

Trevor Howe

01-29-2009 03:42 PM
fimiani@exologic.com

Hello all: I have a simple dimension with a numeric Business Key and textual description. I have created a concatenated field in the DSV as + '-' +...

Todd C

01-29-2009 01:58 PM
Todd C

Can you change the text for the slicer? I have a scenario where the member name is not enough.

db2nd

01-28-2009 12:12 PM
fimiani@exologic.com

In our DW we have contracts and they benefit across 1 to many jurisdictions. Contracts can be serviced by many contractors. So our Contractor tables...

Joe H

01-28-2009 11:51 AM
Joe H

Trying to access remote SQL 2005 cubes from Excel 2003... 0. I installed Excel 2003 Manage Connections add-in, etc. 1. Everything seems to work via ...

morlin

01-28-2009 07:07 AM
morlin

Do local cubes work well? What's a good way to create them? I have build regular server based cubes in AS 2000 but it's been a while since I'v...

Mark Andrews

01-28-2009 03:01 AM
Aleksandra MSFT

Executive Summary After generating a report model from a database schema that has tables related 3 or more deep… Report builder does not allow you...

Anthony.Schleh@gmail.com

01-27-2009 11:20 AM
Anthony.Schleh@gmail.com

My Environment OS: Windows 2003 SP2 64 bit SQL: 2005 SP3 64 bit Enterprise Issue Service: Reporting Services Module: Report Models

Anthony.Schleh@gmail.com

01-27-2009 08:50 AM
Anthony.Schleh@gmail.com

Hello, I need to display a list of first day and last day from the Time dimension for many years. I have started by building a named set but I am...

DG via SQLMonster.com

01-27-2009 04:25 AM
amish

Anyone know where these can get downloaded? We're upgrading a bunch of users from 5.3 and these plugin's were a necessary for their tasks. Thanks!

Jesse O

01-26-2009 02:01 PM
Jesse O

Hi, I have a table of sales data in various currencies and I need write a view that will show all of the transactions in a common currency but at...

Darren

01-26-2009 10:24 AM
Darren

Hi All, An ideas here? I have a MDX query like Select . ON COLUMNS, .. * .. * ..& ON Rows FROM

Mark Hayes

01-26-2009 08:20 AM
amish

Hi, I'm writing a client application that connects to analysis services 2000 and higher. Is there a generic way of extraction Date/Time information...

Johnny

01-26-2009 03:52 AM
Johnny

Hi Folks, Can we restore 64 bit SSAS 2005 database (windows 64bit, sql 64bit) to 32 bit SSAS 2005 database using that *.abf xml file? Do I...

Kumar

01-24-2009 06:08 AM
Gerald Aichholzer

can some one tell me that how much security constraints (checks) would be applied to a user/role on a cube. Posted via DevelopmentNow.com...

khaled

01-23-2009 06:29 AM
khaled

hi, can some one tell me that how much security constraints (checks) would be applied to a user/role on a cube.

khaledh

01-23-2009 06:20 AM
khaledh

Hi All I have a problem that i am trying to display a calculated measure with format = Currency Also i want that the currency will be as the locale...

eyalso@gmail.com

01-22-2009 04:30 PM
fimiani@exologic.com

Hi, The following is the MDX which I am using it from SSRS, some of the parameters are substitued at run time from asp.net parameter page. The...

Amarnath

01-22-2009 07:56 AM
Amarnath

All Having browsed a number of threads asking the same question and not seeing any replies, I wondered if I could ask again is there a way...

JMTWelford@googlemail.com

01-22-2009 03:17 AM
JMTWelford@googlemail.com

With DSO it was possible to setup security so that user's wouldn't have access to certain measures of a cube. We were using AS 2000 when we did this...

Daryl Creed

01-21-2009 04:54 PM
Daryl

Hi, We have several SSIS packages that update cubes in SSAS. Up until this last week, this processing had been working just fine. Then we noticed...

Brian Hman

01-21-2009 10:05 AM
Charles Wang [MSFT]

Hi I have a measure called . (that is Amount in danish exchange) I have a dimension called Finanskonto. On the dimension is a...

jazpar

01-21-2009 08:55 AM
jazpar

Hi, I would like to ask for your assistance with an issue I have: I need to write some web services, which perform the follows: 1) Get a list of...

Tal Shachar

01-21-2009 08:28 AM
Tal Shachar

Hi! I´m getting an error while processing a ssas 2005 cube: 2007-11-08 14:27:58: Memory error: Allocation failure : Not enough storage is available...

Stefan

01-20-2009 08:52 AM
Shakir Bohari

I created some calculated measures using Ytd() function.They are set to be visible and when i connect to the cube itself I can see them in Excel...

PSO BI Team

01-19-2009 04:27 PM
fimiani@exologic.com

I have an item dimenstion with an attribute of Discontinue Date that is a date in the database. I have set the valuecolumn to a date data type. I...

Dan

01-18-2009 07:44 AM
Dan

Community for IT Professionals only. All colleagues are welcome. http://itpros.forumotion.com

TAW

01-18-2009 04:50 AM
TAW

I've noticed that within my .cub file folders I have several thousand empty folders with a .dim extension. They're also all empty. What are the...

Jesse O

01-16-2009 01:53 PM
Jesse O

Hello there. I have a server with Windows 2000 SP4 and there with have SQL 7 instaled for Olap, in which we have some cubes and that stuff, So I...

Nehemoth

01-16-2009 08:40 AM
Nehemoth

Hi I have a field in the database that stores seconds (int data type), what im trying to do is display it as hh:mm:ss format . I tried alot of things...

Borz

01-15-2009 09:10 AM
Ohjoo Kwon

using sql server 2008 MDX i have a column in the fact table called WorkOrdersCompleted whichthe data equal 'I' which means invoiced or 'N'...

negrooo

01-15-2009 05:06 AM
negrooo

Hi, I have SSAS 2005 Cube that is currently under development. Occasionally, when I make a change (add a new dimension, etc) and process the cube,...

leroysalih@googlemail.com

01-13-2009 11:56 PM
leroysalih@googlemail.com

Hello, Is there a way to export cellSEtGrid to excell?

briantonthat@gmail.com

01-13-2009 08:12 AM
fimiani@exologic.com

I'm trying to create a 2 level hierarchy from a dimension table that has a composite key. I process the cube then browse and the first level values...

Mardy

01-12-2009 12:16 PM
fimiani@exologic.com