Hello, Instead of synchronize the entire database, can we specifically synchronize partition? We want to process cube in one server and...

lbling@yahoo.com

03-23-2009 01:13 PM
lbling@yahoo.com

We have a DTS package (running as a legacy SQL 2000 migrated to SQL 2005 package) that's failing. The installation is a SQL 2005 server. It is a...

Simon Watkins

03-23-2009 09:46 AM
Simon Watkins

Hello, I want to use cube calculations for replacing the empty cells with zero. In the default MDX script I’ve added/tested few statements...

dagriq via SQLMonster.com

03-20-2009 09:24 AM
dagriq via SQLMonster.com

Hi, We have a 'Geography' dimension. Region ==> State. I need help in displaying States by Region. Then display Sub Totals by Region & then a Grand...

Prasad

03-19-2009 10:54 PM
Prasad

I'm trying to build a dimensional model where the fact table will consist of data from a header and detail table. There are measures in both the...

Mardy

03-18-2009 12:26 AM
MC

I have two cube dimensions that are both based on the same database time dimension. The dimensions are related to a single fact table based on...

Scott Munro

03-17-2009 08:20 AM
Scott Munro

Hi, I got the Top 5 performing states by Sales. select . on columns, TopCount (..children, 5, .) on rows from where ..&

Prasad

03-16-2009 10:11 PM
Ohjoo Kwon

Hi, I got the Top 5 performing states by Sales. select . on columns, TopCount (..children, 5, .) on rows from where ..&

Prasad

03-16-2009 06:50 PM
Prasad

I'm testing DMV of SSAS2008. Next query returns "MDSCHEMA_ACTIONS" Select * from Discover_Schema_Rowsets However, next query does not identify...

Ohjoo Kwon

03-16-2009 05:50 AM
Ohjoo Kwon

Hello, I can't find information about the Edition of SSAS which is installed: Standard , Enterprise or Developper. Where can I find it, please?? I...

FB

03-16-2009 04:29 AM
FB

Hi there, Does anyone have any experience using a decent front end component similar in functionality to OWC? The core features we were looking for...

JPO

03-15-2009 08:09 PM
dpuri

After making reports for a long time, I found something strange recently. Various reporting software vendors advertise by all means to attract users'...

natalie

03-15-2009 08:29 AM
natalie

We have a kick butt SQL box with 8gb of ram. When processing one of our dimensions (which by all standards is micro small - the whole source DB...

Joe H

03-13-2009 01:13 PM
fimiani@exologic.com

Hi, I am looking for a reporting tool with following functionality: any suggestion will be very much appreciated. 1. Connects to SQL Server...

Mahesh

03-13-2009 10:45 AM
Mahesh

Hello, We have a problem with a size of file ...agg.rigid.map in cube partition folder. For process cube we use program which calls ProcessAdd on...

Ondra

03-13-2009 02:09 AM
Ondra

Hello NG, I'm looking for a solution to create a Dimension looks like that. Month-Dimension: January February March April

Mathias Mink

03-12-2009 09:44 AM
amish

Hi everyone, we are about to upgrade our data warehouse to SQL Server 2008 and I also wanted to buy 'the Kimball book', but didn't realise there...

Daniel Doyle

03-12-2009 09:28 AM
Daniel Doyle

Hello There, I am fairly new to OLAP technology thats why i have some basic questions. I would be glad if anyone can help me with those : , Lets say...

Koray Atsan

03-12-2009 08:40 AM
Joe H

hello I searched on google about 'first cell in a tuple +MDX' and I did not find any link. Is it valid, to work with the first cell from a tuple? A...

dagriq via SQLMonster.com

03-11-2009 11:49 PM
dagriq via SQLMonster.com

Hello, I know that Microsoft has OWC to present a cube on the web but is there anything newer other than Sharepoint? Thanks, Clem

clemts

03-11-2009 04:22 PM
RichardLees

I'm a DBA who has only provided support for SQL Server Databases Services and have not had any exposure to SSAS. My question is that, in a situation...

Rob

03-11-2009 04:09 PM
RichardLees

Hi, I have a SQL Server 2005 deployement, a cube, some ETLs and some reports built with SQL Server Reporting Services. I would like the users to...

arielqs

03-11-2009 04:05 PM
RichardLees

Get your Server 2008 training from the best at excelnet4u.com Get your MCITP: SERVER ADMINISTRATOR and MCITP: ENTERPRISE ADMINISTRATOR MCSE...

excelnet4u

03-11-2009 05:26 AM
excelnet4u

Let us look at the following MDX: WITH MEMBER . AS 'null' MEMBER .. AS '0' MEMBER ... AS '0' SELECT {} ON...

Ihor Bobak

03-10-2009 06:58 AM
Charles Wang [MSFT]

Another silly question.. Is it possible to find out what MDX statements Visual Studio or Management Studio executes when you perform a query in a...

budokaguy@gmail.com

03-10-2009 01:00 AM
amish

Report development is only a part of application program, therefore, the integration of Web reporting tool is of great importance. All the...

natalie

03-09-2009 10:21 PM
natalie

I'm somewhat new to SQL Analysis and setting up cube analysis from various SQL data tables. My client is interested in being to display a graphic...

Rosman Computing

03-09-2009 11:11 AM
John Hennesey

My apologies, I'm new to OLAP and have a problem I can't seem to figure out and was hoping someone can help. My scenario is simple. I have a...

budokaguy@gmail.com

03-08-2009 09:57 PM
budokaguy@gmail.com

Report development is only a part of application program, therefore, the integration of Web reporting tool is of great importance. All the...

natalie

03-07-2009 08:05 AM
natalie

Hi there, to make it simple I have a member . as . / . and another member . as ({.CurrentMember.lag(2): .CurrentMember},.) Unfortuantely I habe no...

Matthias.Bonn@msg.de

03-06-2009 08:48 PM
Matthias.Bonn@msg.de

Hi. We are looking at using cube writeback for a budgeting application. Users will change certain measures in an Excel 2007 pivot table. An Excel...

Candy

03-06-2009 07:15 PM
Hitachi Reed

While trying to connect via Management Studio or Excel 2003 from test workstation to an instance of Analysis Services 2005 databases...

Steven Wong

03-06-2009 06:54 PM
Hitachi Reed

Hi. We are looking at using cube writeback for a budgeting application. Users will change certain measures in an Excel 2007 pivot table. An Excel...

Candy

03-06-2009 07:06 AM
Candy

Hello to everybody, I am studying how to produce the optimal aggregation design for a query. It is not an easy task ! Because I am working on a...

dagriq via SQLMonster.com

03-04-2009 03:51 PM
dagriq via SQLMonster.com

Hello, The AdventureWorksDW defines in the Customer dimension a hierachy called 'Customer Geography' and the levels are from two different...

dagriq via SQLMonster.com

03-03-2009 03:21 PM
dagriq via SQLMonster.com

Hi Please find below MDX SELECT { . } ON COLUMNS , {Filter( ..members,PRODUCT.CURRENTMEMBER.NAME = " A")} ON ROWS FROM WHERE ( ...&.&.&, . )

Usha

03-03-2009 12:18 AM
MC

Hi, I have a table which lokks like this -------------------- ID (PK) TreeID (PK) ParentID (FK) ParentTreeID (FK)

hal9000

03-02-2009 12:22 AM
MC

Hi, I’ve got an dimension and need to create another dimension containing . Do I need to create a fact for the without any measures, just keys? I...

Polzovatel

03-01-2009 12:30 AM
dpuri

I'm trying to implement one to many relationship. I have Main Dim -DIM Main Fact - FACT Multiple Dim -MDIM ( contains multiple values for each key...

Polzovatel

02-28-2009 03:22 AM
Marco Russo

Hi there, We are using OWC in an ASP page as a front end to a SSAS 2005 cube. We have several attribute hierarchies in a dimension, and one natural...

JPO

02-27-2009 05:41 AM
Colbert Zhou [MSFT]

Hi, I have a AccountPayableFact table that has all the payments that we've made. Vendor is one of the dimensions table and that table has a...

Ed

02-26-2009 08:30 AM
Charles Wang [MSFT]

Just downloaded the CellSetGrid project today - *very* cool stuff. Nicely done! Stupid question - I couldn't find anyone else who asked this (and...

John Hennesey

02-24-2009 08:11 AM
John Hennesey

Hi I have SQL 2005 Servers in two Locations , On each server I have a cube that has the same structure on both servers with different data as these...

Que

02-23-2009 01:24 PM
Jesse O

Have a cube with the following structure Dimension: Geography Level: Country Dimension: Time Level: Year Level: Month Dimension: Bank

Roger C

02-20-2009 08:13 AM
Roger C

Hello, I'm using this MDX expression to get a Calculated member for sales rank: RANK ( ( .CurrentMember ), ORDER( .CurrentMember.Siblings, ., BDESC )

Roger C

02-18-2009 03:58 PM
Roger C

In SQL 2000 I set an advance dimension property "Skipped Levels Column" with a perticular column. The dimension is parent-child ragged. Now...

Sam

02-17-2009 05:31 PM
Sam

Hello All: I have noticed a difference between how SSMS and Excel browse a cube. I have a Dimension with about 80K Members. In one cube with only...

Todd C

02-14-2009 01:20 PM
MC

Hi All, I have a cube with an dimension, which has many-to-many relationship with the dimension. For example, Valentines (event) corresponds to...

Pasha

02-14-2009 03:14 AM
info@eventhandler.it

Hi All, I have a cube with an dimension, which has many-to-many relationship with the dimension. For example, Valentines (event) corresponds to...

Pasha

02-13-2009 01:44 PM
Pasha

Hi, We have a parent-child dimension in the cube . In the fact table there is data for both leaf and no-leaf members. So I set the...

Truc H.

02-13-2009 01:01 PM
Truc H.