What would be the MDX equivilent of this SQL? Select sum(gifts) from Production where LastName in ('Smith','Smyth','Shift') Assume dimensions and...

Joe Genshlea

07-29-2003 08:49 AM
Chris Umbaugh

hi, i need help with pro clarity 5.0 mdx functions, i need to know if there is any function wich can respond directly to the members I select to ...

hans soller

07-29-2003 08:08 AM
hans soller

Parent-child dimensions only have aggregations at the bottom and top levels, so it's possible depending on your dimension and fact counts that...

Yubo Fan

07-29-2003 07:14 AM
etpolaris

Hi all, I have encountered a problem using calculated measures (and Excel). I have designed a cube containing several dims and measures - and one...

Lutz Morrien

07-29-2003 03:24 AM
Lutz Morrien

Hi, Please let me know how to filter the drill to detail data based on the roles. Regards, Subbu --

SubbuR

07-29-2003 03:19 AM
SubbuR

Do you have the same problem with both calculated and base measures? Slow performance with calculated measures is a problem with Excel, because...

Bill Koran

07-29-2003 02:12 AM
Lutz Morrien

hi, I have a problem using the pivot Table in excel 2000. Earlier the location of the pivot table in excel was pointing to say c:\sales.mdb. Now the...

Sajith

07-29-2003 01:53 AM
Lutz Morrien

Hi all, I have a fact table which includes dtmCalendarDate and hourly values. dtmCalendarDate links to a tbCalendar table which has a column that...

awong

07-29-2003 12:14 AM
Dave Wickert [MSFT]

Hi All, Quick question. If I create a pivot table and then save as a web page. Each time I hit the refresh icon, is the query being reissued against...

ALF

07-28-2003 06:21 PM
John Thomas

Hi: I'm using .NET/DSO on Windows Server 2003. On calling dsoPartitionAnalyzer.Initialization(), I got error message: Can't open Clipboard I have...

Polaris

07-28-2003 05:11 PM
Polaris

Hi, Would like to know how to export Cubes and Dimensions definition so that I can transfer them to a different server. I already know about...

Pramod Anchuparayil

07-28-2003 04:08 PM
Pramod Anchuparayil

Hi, When can we say CUBE is BIG cube ? I have created cube with 29 Dimensions and fact tabele is having 4.6 million rows.Server is a Dual...

Kris

07-28-2003 12:50 PM
Sean Boon [MS]

Hello All, Is there any way that i can display one of the measures then a calculated member and then another measure ? Since the display order is...

msnews.microsoft.com

07-28-2003 07:15 AM
Lutz Morrien

Hi! You cannot just copy a cube/database from one folder to another. You must archive the database (= back up) and restore it to the new location...

Pavel

07-28-2003 04:19 AM
Pavel

Hi I have a cube with 3 dimensions : time, salesman, zone. An URL custom action (defined on the dimension Salesman) retrieves details about...

Emil Damian

07-28-2003 03:54 AM
Emil Damian

Is it possible, via DSO, to convert a public dimension of a cube into a private one? I'm using now a publicdim, but I want to reprocess that...

Francesco Civardi

07-28-2003 03:52 AM
Francesco Civardi

Hi, I would like to create a local cube from a virtual cube in MS Analysis Server. There are several users, and for each user there are...

BenBal

07-28-2003 03:38 AM
BenBal

Hi, Is there a way to know the type of cell I am querying? In the sense, is it possible via MDX or XML/A to know if the cell is of calculated...

anand_h

07-28-2003 03:11 AM
anand_h

Two additional resources: Programming Office 2000 Web Components http://www.microsoft.com/mspress/books/index/3533.asp Microsoft Office XP Web...

Dave Wickert [MSFT]

07-27-2003 02:20 PM
Dave Wickert [MSFT]

Hi All! I am looking for best practices in implementing cubes with a mix of additive and non-additive (inventory, shapshot, balance --...

ygb

07-27-2003 02:18 PM
ygb

Is this possible in Excel 2000? -- Posted via http://dbforums.com

joelap2

07-27-2003 02:14 PM
Dave Wickert [MSFT]

Analysis Services only uses Windows Integrated security. So there is no management of logins, a la "standard security" with SQL Server. The closest...

Dave Wickert [MSFT]

07-27-2003 01:52 PM
Dave Wickert [MSFT]

I will not get into why I am asking but I need to know if Analysis Services can do it's 'thing' if it only has access to queries in the SQL Server...

George H. Finn

07-26-2003 02:57 PM
Tom Chester

Hello there: I am looking for an mdx editor that highligts mdx sintaxis parenthesis and everything!

Xavier Mernio

07-25-2003 09:06 PM
Matt Carroll [MS]

If a summation of values, for example, the amount in the Budget cube, is greater that about 9,99,999 then the amount is written to the cube as a...

Geeta

07-25-2003 04:20 PM
Geeta

Hi, I got the following error message while conneting the Analysis server on a remote server. ____________ Cannot connect to the repository.

td

07-25-2003 04:08 PM
Wang Xiaoning

Hi. Anyone knows if BI Portal needs licensing? Thanks.

yj

07-25-2003 03:49 PM
Wang Xiaoning

I understand it's not quite possible to have more than 1 datasource in 1 cube. For instance: I have 2 systems, revenue system and sales crm...

mowksi

07-25-2003 02:38 PM
mowksi

I am looking for a good training center in USA, for class "Implementing Business Logic with MDX in SQL2000", from microsoft web site they listed...

Wang Xiaoning

07-25-2003 01:49 PM
Wang Xiaoning

This is for a simpler case so it may not be helpful for this problem, but nevertheless I thought there might be people looking fo answers to this...

ben9

07-25-2003 12:20 PM
ben9

Some extra information I forgot : I'm using AS 2000 SP3 Developper Edition on a Win2K Professional SP4 system Michel CARADEC CEGID Business...

Michel CARADEC

07-25-2003 11:14 AM
Michel CARADEC

Thanks for the response. All 4 are yes, and we can connect using the users credentials fine from here in CO (where the server is). When they try to...

Darryl Carden

07-25-2003 09:20 AM
Darryl Carden

i want to be able to switch the physical cubes that a virtual cube is looking at (same structure etc) , via DSO ... has anbody done this ? the...

dkshfkdshf

07-25-2003 07:51 AM
dkshfkdshf

hello, maybe your users are all admins ? look in your user-definitions of your nt-domain. peter "Andrea Worley" <k_rage (AT) hotmail (DOT) com>...

Peter Hartmann

07-25-2003 02:30 AM
Peter Hartmann

This should be a simple calculation for the following (currnet charge - avg charge for previos level)/stddev(current charge) for previous level . ...

Monty

07-25-2003 12:55 AM
Monty

Can anyone say if there are likely to be any improvements to writeback. The problem I have with writeback is it doesn't actually writeback to the...

John Keeley

07-24-2003 06:20 PM
Mosha Pasumansky [MS]

Currently Excel is displaying my dimension data horizontally and my measures data vertically. ie. Dimensions X,Y,Z Measures A,B,C like this X Y Z A

zoltar

07-24-2003 03:25 PM
Eduardo Pacas

Excel stores connection information in .OQY files. By default you can find these files in: C:\Documents and Settings\<User...

Brian

07-24-2003 02:09 PM
Brian

John, Reporting Services is a direct competitor to Crystal Reports, aimed at production reporting. That is a valid, important requirement for...

John Keeley

07-24-2003 12:38 PM
claudio

Hi, Somebody know like Could I export the Analysis Services users to file for example Excel Thanks a lot, JEPP

JEPP

07-24-2003 12:14 PM
SQL Server Development Team [MSFT]

Hello, they say, Analysis Server with SP3 improves the performance of cell writeback, it is necessary to change the SSFastLoadOptions registry key at...

Peter Hartmann

07-24-2003 11:49 AM
Peter Hartmann

Hi, We have installed the SP3 for the Analysis Services, after installation We are unable to see the Server from the Analysis Services. Thanks in...

Sri

07-24-2003 11:31 AM
Sri

Hi, We use ProClarity5 as our client tool. We now want to evaluate write-enabled dimensions but ProClarity doesn't support this functionality. Can...

david wilson

07-24-2003 04:21 AM
Howard Taylor [O2OLAP]

Hello Most dialogue is based on building the datawarehouse - naturally ... however - does anyone know some litterature regarding testing the...

Michael V

07-24-2003 03:07 AM
Michael V

at first i created a cube,after that i deleted default EveryOne role,and create a new custom role. but it is failed when i try to login ,would u tell...

steven

07-24-2003 01:06 AM
steven

Hi all, I use EXCEL XP to view my Cube which shows project information like this. Project A $100 Project B $200 Project C $300 Now I have a...

Tom Walker

07-23-2003 05:40 PM
Tom Walker

Hi All, I am trying BI Portal and could run it successfully over LAN. I could not run it over the web. I am using Enterprise edition of Analysis...

Swapan

07-23-2003 05:07 PM
Swapan

If so have you had any connection issues? It constantly tells me I cannot access the registry or I am not a member of the OLAPAdmins. I am a...

Kevin Brooks

07-23-2003 04:44 PM
Kevin Brooks

Hi, I need to save a cube view (MDX) via a browser. I can get the MDX statement but was wondering if anybody can post or send me a link on saving...

mrwoopey

07-23-2003 04:39 PM
mrwoopey

Hello friends, I´d like to make a formula only if a condition is true and if it´s false it shouldn´t do anything. for example the member needs to...

Jhonny

07-23-2003 02:46 PM
Jhonny