I wonder if anyone has had a similar problem. I'm using composite keys to join a dimension to a fact table. The dimension is a named query that...

leomepham@hotmail.com

04-24-2007 11:37 AM
leomepham@hotmail.com

Have a number of users who can't drill through on any of the cubes in the repository, this effects some users. All the users are using the Excel...

SunilKarsan

04-24-2007 09:06 AM
SunilKarsan

Maybe unusual isn't the right word, just I can't find any information on doing this type of report and I'm a bit new to OLAP. Suppose you have a...

demeritcowboy@gmail.com

04-24-2007 08:42 AM
Vidas Matelis

Hi, I have seen various people posting similar problems, but there were no clear answers. We have a quite complex AS 2005 database, with...

Stan Kondrat

04-24-2007 08:39 AM
Vidas Matelis

Im using SQL 2005 Standard edition, and i had the following trouble: Security on calculated members: How could we set permissions on the calculated...

ghadeer

04-24-2007 06:44 AM
ghadeer

Im using SQL 2005 Standard edition, and i had the following trouble: Security on calculated members: How could we set permissions on the...

microsoft

04-24-2007 04:59 AM
microsoft

Hi, I am trying SSAS 2005 Median() calculation, and I finding that it is consistantly not matching with Median in Excel. It appears as though SSAS...

xpdnt1

04-23-2007 10:46 PM
xpdnt1

I have a parent-child hierarchy where the top level contains very many members. The members are strings and I'd like to separate them by...

erick calder

04-23-2007 10:15 PM
ekkis

I have set the NameColumn property of a dimension's attribute (an id) to a column containing text. that attribute is also set as Usage = /Parent/...

ekkis

04-23-2007 09:41 PM
Vidas Matelis

Background: We are an ASP and are starting our implementation of Analysis Services and need to create a Date Dimension that can handle Time...

Steve Hughes

04-23-2007 09:00 PM
Jeje

Hi: Wizard does not find table or view from underlying source to create new partitions. I also tried Filter table but for some reason It does not...

Sal

04-23-2007 12:16 PM
Sal

Hello, I'm new on analysis server and i have a question :) I have 1 table with Products and 1 table With Sales relation is one to many. In the...

xpander@tiscali.fr

04-23-2007 09:15 AM
xpander@tiscali.fr

hi,I am learning MDX now .there is a big question that how to execute batch MDX query in SQL management studio,like executing the...

microsoft olap

04-23-2007 07:18 AM
Jeje

Is there any means to get the MDX query generated internally when we browser the cube in Business Intilligence Development Studio (BIDS)? Please let...

Austin

04-23-2007 07:14 AM
Jeje

Hi All ! I want to show my cubes in asp.net application, is there any OALP Browser or how is it possible to develop my own OLAP browser. BYE

shujamughal@gmail.com

04-23-2007 06:53 AM
shujamughal@gmail.com

Dear all, Before I archived data cube, it was fully processed. When I restored the data cube, it became unprocessed. Why? Actually, I only want to...

Polly

04-22-2007 10:28 PM
Polly

Hello all, I'm using AMO to incrementally update (only add new rows) my SSAS 2005 dimension using ProcessAdd option. for some reason it gives...

Arun

04-22-2007 05:24 PM
Vidas Matelis

Hi: Member Properties created in AS 2005 can be seen in Office Pivot Table by right clicking at it. In AS 2005, member properties have been...

Sal

04-22-2007 05:15 PM
Vidas Matelis

What do these error codes mean? TextData: The job completed with failure. Error: -1056964601 TextData: Server: The operation has been...

Jesse O.

04-22-2007 09:35 AM
gmwithers

what is the query run against the database? do you use a view or table for your fact table? do you use AS2000 or 2005? "DXC" <DXC (AT) discussions...

Jeje

04-22-2007 09:33 AM
gmwithers

I have created a time dimension in AS2005 using the time wizard. I now need to add extra dates/years to this table. Is there is an easy way...

Andrew Wilkie

04-22-2007 09:21 AM
gmwithers

I need calculate the summary of the number of effective orders for each salesperson in a period. The effective order means the collection summary of...

Bob

04-22-2007 12:17 AM
Bob

SSAS 2005. I have a simple, standard Time table with TimeKey, CalYear, CalMonth, CalDay columns as: .... 20050101 2005 1 1 20050102 2005 1 ...

christy

04-20-2007 07:26 PM
Vidas Matelis

I am using AS 2005 and accessing via Analysis Services 9.0. I am trying to create an offline cube file to be used on other client PC's, which only...

barrex2000@hotmail.com

04-20-2007 12:02 PM
barrex2000@hotmail.com

Dear all, I was working with AMO and wanted to query partitions. I found that the object Microsoft.AnalysisServices.Partition contains the member...

Arun

04-20-2007 11:23 AM
Arun

I'm kind of a noobie to MDX and can't seem to figure this one out. I have created a time dimension per George Spofford's MDX Solutions with a...

nate951@cox.net

04-20-2007 10:14 AM
Deepak Puri

Hi all, I am implementing a Proof of Concept SSAS 2005 cube based on 2 data sources: SQL 2K5 MS Access 2007 - The Two datasources are OK - The...

Lionel Gomes

04-20-2007 08:06 AM
Lionel Gomes

We have a Analysis Services 2000 and 2005 cubes and we need to drillthrough to this cubes... The code we use is from this source,(a microsoft...

cls

04-20-2007 05:00 AM
cls

"Categorization ......... Measures, hierarchies and other objects can be grouped into folders meaningful to the user......." How can this be done? I...

jcaubin

04-20-2007 02:46 AM
baty

Hi all I am using proactive caching but it seems that my cubes are not updated. How can I find the log or error why partition is not updated...

sqlprobs@gmail.com

04-20-2007 02:24 AM
sqlprobs@gmail.com

Hi Using the Adomd.Net provider against the AdventureWorks DW sample database if I run the following query: SELECT {..DefaultMember} ON...

Andrew Wiles

04-20-2007 01:50 AM
Andrew Wiles

Hi, I've been trying to configure Kerberos Authentication on our environment with no luck. I've tried absolutely EVERYTHING that I could find on...

RB

04-19-2007 09:14 PM
Stan

MS article specifies to create a domain group "Olap Administrators" for managing AS for AS admins. My question is does this have to be named...

Stan

04-19-2007 09:08 PM
Stan

I'd like to have a calender control in Reporting Services for date range parameters From Date - To Date but the query is an MDX query connecting to...

Susan

04-19-2007 08:10 PM
Deepak Puri

In my solution, I need to do some date calculations with a granularity of minutes. Kimball recommendation is to have a granularity of day in the time...

Nico R

04-19-2007 01:58 PM
Nico R

Could any one please suggest me as how to correct following MDX? strSource = "With " strSource = strSource & " member . as " strSource = strSource...

Shailesh

04-19-2007 09:02 AM
Shailesh

Dear all, Just wondering if there is any way to perform incremental update of dimensions using SSIS packages? The AS Processing task does not...

Arun

04-19-2007 08:35 AM
Vidas Matelis

Hello: I have an AS 2000 cube containing a ragged hierarchy. For one of the members, I have a customized MDX formula using PARALLELPERIOD. I process...

gborda

04-19-2007 08:18 AM
gborda

I have designed a cube where I can monitor stock values for different products. Time hierarchy has years, quarters, months and days of month. Now I...

chus2002@gmail.com

04-19-2007 08:05 AM
chus2002@gmail.com

I have an old (C++) application build with the legacy (COM based) ADOMD library. It works fine with AS2005 cubes apart from one issue. Not all of the...

Andy

04-19-2007 06:27 AM
Andy

Dear all I need your help for time dimension. i have fact table with many date fields and i need to use them in dimension. For example Order_Date,...

JeanPaul

04-19-2007 04:10 AM
ponzie

How can I use CellSetGrid to view datacubes on my PC. I am a very new to ASP.net and I have a demo tomorrow If anyone has some detailed guideline to...

kvc

04-19-2007 03:30 AM
kvc

Hi evrybady, I use AMO library in web aplication to get a cube. The aplication correctly creates: data base, data source, data source view and...

Tom

04-18-2007 04:35 PM
Tom

Hi, I'm having a problem and I wonder if I could get some ideas from the crowd. I'm working with a database table that looks something...

leomepham@hotmail.com

04-18-2007 01:01 PM
leomepham@hotmail.com

In SQL Server Management Studio right-click an analysis server which has SP2 installed, and select Properties. Pre-SP2 there was a group of...

Steve G

04-18-2007 10:58 AM
Steve G

Hi, I'm trying to write an MDX query that would be used by reporting services. I'm very new to MDX and I bit confuse with some on the syntax. Any...

Aiwa

04-18-2007 09:08 AM
Francesco De Chirico

Date = Dimension, Data/Eow = Measure Date Data Eow 01.01.2007 1 11 (Week 1) 02.01.2007 1 12 (Week 1) 03.01.2007 1 13 ...

Dst

04-18-2007 08:32 AM
Dst

hi all, i have written one calculatedc member under time dimension which calculates the difference between current year and its previous . i have...

pratibha

04-18-2007 08:02 AM
pratibha

Dear all, I have a scd type 2 dimension in my database. I have implemented and tested it in database level. When showing this data in OLAP, I have...

Arun

04-18-2007 07:55 AM
Arun

Dear all, I am adding a new (shared) dimension to an existing cube. When I open the cube in Proclarity or cube browser of MSAS 2000, then this new...

AS_haasrode

04-18-2007 06:28 AM
AS_haasrode