Does anyone know the fastest (best!) way to answer the following question: Give me all Customers who spent more than 2$ on Good Imported Beer...

mdxuser

07-05-2003 08:46 AM
GS

Dear all, when I create a measure in the MDX Builder application, how do I use this later, I mean, at the front end application? I´m new on it...

Cris

07-04-2003 09:18 PM
Cris

Hello, Can anyone explain with an example about Degenerated and Mystery dimensions and how the same can be achieved in SQL2000? Thanks in...

Nair

07-04-2003 05:16 AM
Nair

Hello, Can anyone help me with a set of best practises that need to be followed for using MDX expressions. Also, I'm looking for the various points...

nair

07-04-2003 05:14 AM
nair

Hi, I am just starting with having a look at Analysis Services to see whether our company can utilise it. I have a strong SQL 2K and genral...

London Developer

07-04-2003 04:01 AM
Lutz Morrien

Hi! We have installed the MS BI Portal and it works fine on the majority of our client machines. But some of them gets this error message...

Thomas Revetal

07-04-2003 03:51 AM
Thomas Revetal

Hi, I use an excel pivot table template to access my olap cube. The data in the cube is refreshed every month. I saved the excel pivot table and...

Leng

07-04-2003 01:58 AM
Leng

I'd like to announce to the group that a whitepaper titled "Analysis Service Performance Guide" has been posted to TechNet...

Sean Boon [MS]

07-04-2003 01:35 AM
Chris Webb [MS]

When connecting from a Web Server I can set my PTS properties for my connection. Do these live on the analysis server anywhere? If they don't how do...

07-03-2003 02:43 PM

Andrew, You have two options, one of which you pursued below. Analysis Services must load all dimension members into memory by design. If you are...

Sean Boon [MS]

07-03-2003 02:37 PM
Sean Boon [MS]

Hello GS, You can not make it blank or orbitrary string, but take a look at "Secured Cell Value" in BOL, this might help you. BOL...

Irina Gorbach [MS]

07-03-2003 12:48 PM
Irina Gorbach [MS]

What are the current best methods for real time data updates in an analysis services cube?

Wilbur

07-03-2003 11:54 AM
Wilbur

Hi I want to create a % growth formula in MDX but do not know how. Can someone advise me. I need % growth in terms of year on year and % growth for...

freger

07-03-2003 11:29 AM
SANBAR

Hello, I am trying to hide a dimension until the lowest level of our product dimension is revealed. The dimension I am trying to hide doesn't...

Jen

07-03-2003 09:06 AM
Jen

For help with percentiles and other statistical functions check http://www.dsslab.com/MDXSolutions.html/MDXStatistics.doc I believe percentiles...

Sean Boon [MS]

07-03-2003 08:46 AM
Tom Chester

Hi, First a piece of our databasedesign to make things clear: Website(id, name, ...) PageGroup(id, name, website_id, ...) Page(id, name,...

Jeroen Oosterlaar

07-03-2003 08:44 AM
Tom Chester

Thanks for the reply. The article was very interesting but I'm still confused. Reading that article, I would expect my OWC to not function without...

Matt

07-03-2003 08:02 AM
Matt

Very interesting Ajay. My Japanese is a bit rusty - or should i say non-existent. Is it a program you download or is it avaliable in the dot net...

Michael V

07-03-2003 06:54 AM
Michael V

Hi, I have a sales cube that is used in a PivotTable in Excel XP to show daily sales by Store. The user would like to see always the complete list...

pierrot

07-03-2003 03:08 AM
pierrot

Hi, I want to concat the strings a member with %. How do I achieve this. ex, if (.) = 98 then i want to display it as 98 %. "Changing the format to...

SubbuR

07-02-2003 11:59 PM
SubbuR

Hi, How do i concat 2 strings. I tried using "Generate" function but was not able to achive what i wanted. Please let me know the exact way of doing...

SubbuR

07-02-2003 11:53 PM
SubbuR

Thanks very much Irina :-). I'll go check it out. Gray. "Irina Gorbach " <irinag (AT) online (DOT) microsoft.com> wrote Yes, the problem with Http...

Gray

07-02-2003 10:59 PM
Gray

Hello, Does anyone out there know if it's possible to enable realtime OLAP with a non-SQL Server datasource (dimension data stored relationally in...

Sy

07-02-2003 06:03 PM
Nigel Pendse

Nevermind. I figured out how to show member properties in my pivot table. But I can only show Employee_ID to the RIGHT of Employee_Name, and of...

louis garrett

07-02-2003 06:03 PM
Sean Boon [MS]

Hi Martin, What I am trying to do is get a distinct count of the number of Clients in a system. The Client Id is an alphanumeric field, a text...

Fred K

07-02-2003 06:02 PM
Fred K

Hi, I have 10 tables each represent a product category. I have created 10 cubes for all these products. However, I need to create a cube that...

freger

07-02-2003 05:12 PM
Francesco De Chirico

if any of the measure in the particular sub group is hidden because of secuirty, the measure should be hidden at the sub total level also. The...

GS

07-02-2003 04:16 PM
GS

Hi Is anyone familiar with this odd behavior: My cube becomes unprocessed without being changed at all. The only change that may had been connected...

Rea Peleg

07-02-2003 03:54 PM
Rea Peleg

How can i enable the sub total to give me the totals of only the valid measures. In my cube, i am hiding some measures for some security reasons. Say...

GS

07-02-2003 03:52 PM
GS

Just right-click the cube and choose Delete from the pop up menu in Analysis Maanger. -- Jacco Schalkwijk MCDBA, MCSD, MCSE Database...

Jacco Schalkwijk

07-02-2003 03:49 PM
GS

I need to refer to the calculated member of cube 1 to define the cell secuirty of cube 2. How do i do the same?

GS

07-02-2003 03:40 PM
GS

I have two cubes, with which the cell secuirty on second cube should depend on the calculated member of the first cube. any idea of how to implement...

GS

07-02-2003 03:35 PM
GS

I've created a cube with a dimension called project in which I have set up an action to open a link giving details on the project. I'm using the...

Dave

07-02-2003 02:11 PM
Matt Carroll [MS]

Hi, I am trying to build local cube and I have a question. My tables are updated very often and I would like to keep a copy of a cube at a very...

lydie

07-02-2003 01:36 PM
Irina Gorbach [MS]

Hi Sean, Thanks for your replay, But I got a syntax error when I tried to do this, I can't find the error, can you check your expression and find...

Chovav Mazor

07-02-2003 12:53 PM
Sean Boon [MS]

I am trying to use DSO to connect to my server and keep getting a connection error. Is this because my server name starts with a numeric? My server...

Kel

07-02-2003 12:01 PM
Kel

I have a time dimension (Year->Month->Week) and region dimension (Region->Location) with measures as Revenue $, Cost $ and Cost %. Users can define...

Manish

07-02-2003 11:15 AM
Manish

Hello, All! 1) How can I realize load testing for MS AS? 2) Is somebody know the methodology of determination of hardware requirements for MS AS...

Andrey Savchenko

07-02-2003 07:34 AM
Andrey Savchenko

Hi! When I do this simple sample Analysis Service return me that error: "Column expression associated with level '_TemplateLevel' is not...

Tom

07-02-2003 07:23 AM
Tom

Lutz Many thanks for your reply, and apologies for not getting back sooner. As you can imagine we've been pretty busy trying to get this sorted. We...

Colin Counsell

07-02-2003 02:41 AM
Lutz Morrien

Hi All, I have Cube with 3 partition, I am trying to setup Drill Through on this cube form Excel. This drill through is working fine If we do...

Kalpesh

07-02-2003 12:12 AM
Kalpesh

have you set a custom formula for the "All level" in 1 of your dimension ? Try to change the aggregation model and customize it for your...

Jéjé

07-01-2003 09:12 PM
Jéjé

Dear Listers, Are there any known issues regards AS functionality following installation of SP3? TIA John

john

07-01-2003 09:07 PM
Jéjé

Excelent. That works very well. Thanks for the help. "Brian Altmann" <brianaltmann (AT) yahoo (DOT) com> wrote

Wilbur

07-01-2003 03:39 PM
Wilbur

We have a custom rollup along a dimension: --------------------------------------------- Custom rollup of the measure , along the dimension...

Tao Zuo

07-01-2003 03:25 PM
Tao Zuo

though u add a member property with 8000 characters (data type as text, i guess), AS recognises characters till 256 only. AS do not suport the...

GS

07-01-2003 01:47 PM
alexberenguer

Hi, one way is to use the create global cube statement from DDL. CREATE GLOBAL CUBE STORAGE 'C:\...\test.cub' FROM ( MEASURE ., MEASURE .,

Matthias Englert [MIS]

07-01-2003 12:44 PM
Ermanno Bonifazi

i'm new to OLAP on Analysis Service. i'm working on an OLAP project for my company and i'm doing performance testing of query times so i obviously...

groove_sf

07-01-2003 10:46 AM
groove_sf

Can anyone recommned analysis services training classes in Massacusetts...

kalapanda@yahoo.com

07-01-2003 10:43 AM
kalapanda@yahoo.com

The msg: User-generated error - the dimension "Institution" has no valid member. For more information, see your administrator. Background...

Chris Hotz

07-01-2003 09:45 AM
Chris Hotz