dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Discuss in the microsoft.public.sqlserver.olap forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.olap Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
i recently read that it was possible to publish cubes directly to IIS (if you had enterprise version) can someone tell me how to this done or point...
07-08-2003 02:02 PM
Irina Gorbach [MS] Go to last post
1 118
"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote I can heartily recommend Nigel's report. He knows the industry inside out. He is very keen...
John Keeley
07-08-2003 01:57 PM
Jane Jackman Go to last post
4 151
Hi, I would like to know if there is a way to know if a cube is empty using MDX. (i.e. using programmation) Thanks a lot Lydie
07-08-2003 12:52 PM
Marin Bezic [MSFT] Go to last post
1 121
Hi, I'm having trouble with creating a straightforward balance calculated measure : If there is no "YTD Amount" for the month then carry forward the...
07-08-2003 11:58 AM
Ryan Go to last post
2 103
Hi Tom sorry, I think I wasn´t clear.... I´d like to know how do I visualize anything that I build in MDX builder? how to put it in the...
07-08-2003 11:45 AM
ygb Go to last post
4 154
The following is the expression that I use to create a calculates member: IIF (. <> 0, IIF...
Mark Dengler
07-08-2003 10:41 AM
Mark Dengler Go to last post
1 104
Yossi, 0) I agree with Sean on star vs. snowflake designs 1) on your issue: a single Dimension with Manu as the top level and Brand as the...
07-08-2003 07:11 AM
Dennis Redfield Go to last post
6 147
Hi, this does sound like a slowly changing dimension to me. (Organisation is changing and the changes are to be reflected in the dimension.) If this...
Lutz Morrien
07-08-2003 06:14 AM
roberta1 Go to last post
2 119
I'm in the process of creating a large cube. The source data is partitioned by week so I've partitioned the cube the same way (each weekly table is...
07-07-2003 11:38 PM
Deepak Puri Go to last post
1 106
Hello, I have a SQLServer 2K being used for OLAP processing. There are several DTS packages that do the DTS processing. Some of these DTS packages...
UR ednec
07-07-2003 10:25 PM
Jéjé Go to last post
1 147
Hi: what is the max amount of RAM that Analysis Services (SP3a) supports? Is there a 64-bit version AS? What is the Max RAM supported and which...
07-07-2003 02:09 PM
Polaris Go to last post
2 116
hi i would like to use the count method with mdx to know how many data there is in my cube. I haven't been able to do so. Is it possible or os there...
07-07-2003 12:53 PM
Marin Bezic [MSFT] Go to last post
1 150
Is it a techical limitation ?
07-07-2003 10:43 AM
Sanka Go to last post
1 135
Hello, All! We are using Excel XP PivotTable as OLAP client and we encounter a lot of problems. The most serious problem is with calculated cells :...
Andrew Surinov
07-07-2003 06:53 AM
Lutz Morrien Go to last post
1 108
Hi, we're about to try writeback forecast data to our AS cube from Excel. Many questions arises: 1. Is writeback included in SQL server Standard...
07-07-2003 02:58 AM
John Keeley Go to last post
4 157
Hello! Can somebody help me out? I'm newbee in working with olap and datacubes. Can somebady explain to me what a dataminer exactly is? -- Kind...
07-07-2003 01:13 AM
Janssen Go to last post
2 135
Hi all I have a field in fact table storing age for all people. How do i do grouping for this people in this format 0-10 11-20 21-30 etc and...
07-07-2003 12:47 AM
Jono Indrawijaya Go to last post
1 103
Dear all, I need to set up OLAP cubes for sales analysis. In the source database, there are two fact tables: Inventory Balance and Sales Summary...
07-06-2003 11:54 PM
Jono Indrawijaya Go to last post
2 116
Hi Darren, Have you seen this case study? http://www.microsoft.com/resources/casestudies/casestudy.asp?CaseStudyID=13929 It might not be exactly...
Chris Webb [MS]
07-06-2003 10:28 PM
Deepak Puri Go to last post
1 136
Howard Taylor " <Howard.Taylor (AT) o2olap (DOT) com> wrote Dear Mr. Taylor... Would you please reduce your spam a little bit? Thanks.
07-06-2003 05:49 AM
Howard Taylor [O2OLAP] Go to last post
1 119
Dear all, I´m new in this MDX world and I´m trying to figure out wich mdx functions I can use on calculated members and wich I can use just in MDX...
07-05-2003 10:36 AM
Jéjé Go to last post
1 128
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...
07-05-2003 08:46 AM
GS Go to last post
3 120
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 Go to last post
1 113
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] Go to last post
1 150
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...
07-03-2003 11:29 AM
SANBAR Go to last post
2 166
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 Go to last post
2 157
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 Go to last post
1 125
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...
07-03-2003 08:02 AM
Matt Go to last post
2 113
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...
07-02-2003 11:53 PM
SubbuR Go to last post
2 166
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...
07-02-2003 10:59 PM
Gray Go to last post
1 123
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...
07-02-2003 06:03 PM
Nigel Pendse Go to last post
1 117
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] Go to last post
5 205
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 Go to last post
1 136
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...
07-02-2003 05:12 PM
Francesco De Chirico Go to last post
1 174
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...
07-02-2003 03:52 PM
GS Go to last post
1 132
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 Go to last post
2 134
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...
07-02-2003 02:11 PM
Matt Carroll [MS] Go to last post
1 222
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...
07-02-2003 01:36 PM
Irina Gorbach [MS] Go to last post
1 169
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] Go to last post
1 151
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 Go to last post
1 158
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 Go to last post
1 161
Dear Listers, Are there any known issues regards AS functionality following installation of SP3? TIA John
07-01-2003 09:07 PM
Jéjé Go to last post
1 199
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...
07-01-2003 01:47 PM
alexberenguer Go to last post
1 150
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 Go to last post
2 214
Hi I want to change the name of an existing cube. Kindly advise. Thank you very much.
07-01-2003 01:41 AM
Lutz Morrien Go to last post
1 177
I don't think this is possible, but wanted to through it out and see if anyone has any ideas... I have a Olapdatabase of purchase transactions. I...
Jim Fox
06-30-2003 06:50 PM
Jéjé Go to last post
1 190
Hi, have you checked your cube layout/design? Usually, if one adds a dimension and the cube shows all empty, the reason is a wrong join between fact...
Lutz Morrien
06-30-2003 02:04 PM
Marcelo Noga Go to last post
1 197
Two-part question: 1. Is Analysis Services available in different languages? I would assume so since the download for SP3 appears to be available...
Dave Fackler
06-30-2003 11:26 AM
Tim Peterson Go to last post
1 208
Hi Sarah, That helps magnificently. This is exactly what I was looking for in the first place. Thanks for clearing that up for all of...
06-30-2003 10:19 AM
malcolm Kraushaar Go to last post
1 252
Post New Thread

Display Options
Showing threads 9151 to 9199 of 9199
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.