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...
Jez
07-08-2003 02:02 PM
Irina Gorbach [MS] Go to last post
1 108
"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 135
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
lydie
07-08-2003 12:52 PM
Marin Bezic [MSFT] Go to last post
1 110
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...
Ryan
07-08-2003 11:58 AM
Ryan Go to last post
2 101
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...
Cris
07-08-2003 11:45 AM
ygb Go to last post
4 113
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 94
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...
Yossi
07-08-2003 07:11 AM
Dennis Redfield Go to last post
6 128
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 111
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...
rknight29
07-07-2003 11:38 PM
Deepak Puri Go to last post
1 97
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 135
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...
Polaris
07-07-2003 02:09 PM
Polaris Go to last post
2 108
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...
lydie
07-07-2003 12:53 PM
Marin Bezic [MSFT] Go to last post
1 133
Is it a techical limitation ?
Sanka
07-07-2003 10:43 AM
Sanka Go to last post
1 122
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 94
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...
jerome
07-07-2003 02:58 AM
John Keeley Go to last post
4 140
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...
Janssen
07-07-2003 01:13 AM
Janssen Go to last post
2 118
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...
Loon
07-07-2003 12:47 AM
Jono Indrawijaya Go to last post
1 92
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...
Anderson
07-06-2003 11:54 PM
Jono Indrawijaya Go to last post
2 108
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 121
Howard Taylor " <Howard.Taylor (AT) o2olap (DOT) com> wrote Dear Mr. Taylor... Would you please reduce your spam a little bit? Thanks.
MK
07-06-2003 05:49 AM
Howard Taylor [O2OLAP] Go to last post
1 112
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...
Cris
07-05-2003 10:36 AM
Jéjé Go to last post
1 116
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 Go to last post
3 111
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 103
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 115
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 Go to last post
2 149
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 148
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 115
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 Go to last post
2 109
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 Go to last post
2 159
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 Go to last post
1 114
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 Go to last post
1 113
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 184
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 123
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 Go to last post
1 162
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 Go to last post
1 125
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 127
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] Go to last post
1 214
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] Go to last post
1 157
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 143
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 154
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 153
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é Go to last post
1 189
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 Go to last post
1 139
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 206
Hi I want to change the name of an existing cube. Kindly advise. Thank you very much.
freger
07-01-2003 01:41 AM
Lutz Morrien Go to last post
1 168
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 183
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 190
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 194
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...
Shawn
06-30-2003 10:19 AM
malcolm Kraushaar Go to last post
1 240
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 - 2014, Jelsoft Enterprises Ltd.