Background Have you ever seen a reporting software which has a more suitable interface to design static reports than Excel? I believe that those who...

akar

05-03-2009 09:43 AM
akar

I have the following scenario: ASP.net Web App with DNS Record Joe.com (IIS6.0) on Server A (Windows 2003 SP2) Server B (Windows 2008) holds a Cube...

Dave

04-30-2009 08:14 AM
Reeves

Hello all, this will no doubt be basic for the most of you, yet not to yours truly: The below query returns internet sales amounts for all...

Morten

04-30-2009 05:59 AM
amish

Hello All, I have just joined this wonderful forum and I feel that the group I will interact with will provide a mutually fruitful relationship....

Deepak

04-30-2009 05:04 AM
Deepak

I have a rather complicated Dimension and Fact design (which may not be ideal, but I'll post about that separately). The question I have is should I...

cpnet

04-29-2009 07:00 AM
Charles Wang [MSFT]

I'd like to create a hierarchy for a dimension that is something like the following example: Let's say my facts are store sales (FactSales). I...

cpnet

04-29-2009 02:40 AM
Marco Russo

I'd like to create a hierarchy for a dimension that is something like the following example: Let's say my facts are store sales (FactSales). I...

cpnet

04-28-2009 08:08 PM
cpnet

I am migrating an AS2005 cube into AS 2008. The AS2005 resides on an dual CPU Opteron (dual core) with 7Gb Ram and Win2k3. The AS2008 resides on a...

Minas Papageorgiou

04-28-2009 02:26 AM
fimiani@exologic.com

Background Have you ever seen a reporting software which has a more suitable interface to design static reports than Excel? I believe that those who...

Compatible Mozilla/4.0EmbeddedWB-

04-27-2009 07:57 PM
Compatible Mozilla/4.0EmbeddedWB-

I have a BI application set up on two servers. Both are running Windows Server 2008. One server hosts the Analysis Services instance (SSAS 2008...

Rockabilly Jim

04-24-2009 06:28 AM
Rockabilly Jim

Hi gurus, I am new to SQL Server Analysis and have a naïve question here. How can I rename the dimension and dimension member name in MSAS 2000...

newbietoMSSAS

04-23-2009 12:47 PM
newbietoMSSAS

I am working on OLAP modeling for a change ticket (CT) system. The question I have related to dimension. Below are some of the tables we have in one...

Sam

04-23-2009 11:38 AM
Sam

Hello, I am using ADOMD.NET to request a OLAP cube and I wanted to know this : "Can we get the maximum value of the returned data ?" Maybe with...

jmix90

04-23-2009 06:06 AM
jmix90

I am using Excel 2007 for connecting to SSAS 2005 (AdventureWorksDW) cube and created a very simple report on perspective "Financial Reporting"...

Ajay Singh

04-23-2009 05:51 AM
Ajay Singh

i have a measure that is month to date ie we don't get all the transactions, every day we get the sum of all the transactions so far for the month,...

David F

04-22-2009 04:11 PM
David F

Hi everyone, I'm looking at all the project REAL documentation and blog posts regarding best practices for data warehousing with SQL Server but...

Daniel Doyle

04-22-2009 05:19 AM
Daniel Doyle

Background Most Java reporting tools, especially those have some BI characteristics, often claim to end users that their products are simple to use....

Compatible Mozilla/4.0EmbeddedWB-

04-22-2009 05:02 AM
Compatible Mozilla/4.0EmbeddedWB-

I'm trying to specify the collation on an Analysis Services 2008 project through the UI, just as you can for Database Projects. The MSDN...

The Man From SQL

04-21-2009 07:37 AM
The Man From SQL

What is the best practice for setting up role playing dimensions in SSAS? If you create multiple cube dimensions from the same table in the DSV,...

ponzie

04-21-2009 03:23 AM
ponzie

We have created a many to many dimension that works fine with normal mdx queries. The problem is that the drillthrough when using this dimension...

sarahabnett@gmail.com

04-20-2009 08:51 PM
fimiani@exologic.com

I have a clinical cube with a dimension that contains sensitive data. I have been asked to allow a few users to see all members of the dimensions,...

BJ

04-17-2009 02:19 PM
BJ

We have an SSAS 2005 OLAP solution that makes extensive use of Reference Dimensions to get round the limited support for Role Playing Dimensions. The...

ponzie

04-17-2009 10:24 AM
ponzie

Hi, Can anybody explain in detail with steps (if possible) ,how to achieve drillthrough capability for a calculated member in the cube, if there are...

ArvindRavish

04-16-2009 09:20 AM
Reeves

Hi, To explain my problem consider the following scenario: I have a cube with - a time dimension - a product dimension - a sales amount measure (a...

wim

04-15-2009 10:57 AM
wim

SQL 2005 Analysis Services SP 3 I have created a calculated measure that accurately produces a standard deviation for a specific variable when run...

jp

04-15-2009 10:28 AM
jp

I just want to know the importance of creating a separate Time dimension table.

Aditi

04-11-2009 11:35 PM
Aditi

Go and have a look at http://inforpt.codeplex.com/ Br Magnus

mape36@gmail.com

04-11-2009 03:51 PM
mape36@gmail.com

Nowadays, many reporting tools claim that they are Excel-like, and they support Excel-like report design after improvements. Then, what is a real...

Compatible Mozilla/4.0EmbeddedWB-

04-09-2009 10:48 AM
Compatible Mozilla/4.0EmbeddedWB-

I have the calculated measure in SSAS2005 with periods to date function. which is as follows: CREATE MEMBER CURRENTCUBE... AS...

PSO BI Team

04-09-2009 08:28 AM
PSO BI Team

Hello Everyone, I'm working with the Project 2K7 Cube. Currently, using the MSP_Portfolio_Analyzer cube (the cube is a virtual cube base on 2...

Patrice Lamarche

04-08-2009 01:56 PM
Hitachi Reed

When I click "Design Aggregation..." I get the next message. What does it mean? I cannot find an answer neither in technet nor MSDN. Please help me...

SignOff

04-06-2009 03:42 PM
SignOff

Hi While browsing the cube I get below error Unable to browse the cube <cube name> Unspecified error. I'm on SQL 2000 Dev edition. Sp3 I have...

Khushbu

04-06-2009 07:11 AM
Khushbu

SQL2k sp4a All of the sudden, my Analysis Manager is no longer able to connect to my AS server. This has worked fine for years, and all the sudden...

Andre

04-05-2009 01:23 PM
Andre

Guys, I posted a question back on Feb 5th regarding controlling the amount of "All" entries in my result set. I want to use "AllMembers"...

sitexcite@hotmail.com

04-01-2009 01:46 PM
Hitachi Reed

SSAS 2005...This works like a champ. Get a nice EmployeeSet on Axis 1. WITH SET EmployeeSet...

Dan

04-01-2009 11:23 AM
fimiani@exologic.com

I rewrite your expression. Replace the leaf level token with your product leaf level. IIf(IsLeaf(.CurrentMember), IIf(. <> 0, ....

Neil Evans-Mudie

03-31-2009 08:31 PM
Ohjoo Kwon

Hello: On Adventure Works I have a query involving a calculated member that produces (null)'s in places don't expect. Here is a simplified...

Michael D.

03-31-2009 12:35 PM
Michael D.

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-31-2009 08:12 AM
Simon Watkins

Hello All I am trying to modify how a role-playing dimension reports based on the level of another hierarchy. Here's an example from AdventureWorks...

TenorMan

03-31-2009 06:13 AM
TenorMan

I am trying to understand, and best design a mock database I am playing with. It's a well designed OLTP database, but my need to to make a Star...

Cralis

03-30-2009 06:01 PM
fimiani@exologic.com

I have a single DW with data from 12 different clients. Each client has their own cube and each cube has the same schema right down to the DSV. ...

taparo

03-28-2009 05:19 PM
taparo

Hi, I want to know if there is a way to get sub totals & Grand Total in 1 MDX stmt? Here is output sample: Sample Output: Distinct Employee Count...

Prasad

03-27-2009 04:50 PM
Will Alber

Hello, I have a cube with a dimension that is restricted to only 3 members. When the user uses the drillthrough action to see the transactional...

riskiad

03-26-2009 03:09 PM
riskiad

I know this has been posted before but I was not able to find where there was an answer. We have an analysis service cube that seems to have poor...

rjvanzanten

03-26-2009 10:47 AM
rjvanzanten

I have a fact table which contains sales delivery facts. In this i have columns Order Number, Position Number and Delivery Sequence Number. I have...

Anup

03-25-2009 12:33 PM
Anup

In order to use the "translations" feature of Sql Server Analysis Services 2008 we need to set the locale identifier of the OLEDB connection...

Elyo Ravuna

03-24-2009 04:29 PM
Elyo Ravuna

Hello all: I am new to SSAS 2005 and not sure what happened here: I have a simple cube with 1 Fact table and 4 dimensions. I can see that all five...

Todd C

03-24-2009 08:01 AM
CLS

Hi , I have time dimension as below Yr-Qtr-Month-date Now I have to create a measure to get the Number of days out of the date level so the...

Kris

03-23-2009 08:56 PM
Kris

Hi , I have time dimension as below. Yr-Qtr-Month-date Now I have to create a measure to get the Number of days out of the 'date' level from the...

Kris

03-23-2009 08:40 PM
Kris

I learned Gemini(next AS) will work with column-based feature. From my current understanding, the column-based means attribute with single field. If...

Xie Zheng

03-23-2009 06:14 PM
fimiani@exologic.com