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     
Please help me understand... I am using Radatsoft cube browser control in an ASP.net web application, my web server is in the DMZ and my SQL(OLAP)...
steve kennedy
11-29-2009 06:24 PM
Will Alber Go to last post
1 359
We have a server with Analysis Services 2005 SP2 and the SQL Server 2005 SP2 Enterprise. AS processing is failing and performance counters point...
11-29-2009 02:37 PM
Will Alber Go to last post
1 133
SELECT NON EMPTY {TopCount({Crossjoin({.},{...AllMembers})},20,.)} ON COLUMNS, NON EMPTY {hierarchize(TopCount({.. .AllMembers},20,.))} ON ROWS FROM...
11-19-2009 02:30 AM
rupniceguy@gmail.com Go to last post
2 152
I need help on a simple MDX query. It is to find 1) the latest HeadCount or 2) the HeadCount of today. Say, if today is aug 15, 2009. the basic...
11-15-2009 05:34 AM
amish Go to last post
3 164
Hi, I have a question based on the need to use OR operator in a MDX query. How can I filter a query using something like this conceptual...
. .Ronen
11-11-2009 12:52 AM
. .Ronen Go to last post
3 169
Hi all, I’m working on a conversion from SSAS 2005 to 2008. I'm getting extremely poor performance when processing multiple partitions...
Joe Sampino
11-10-2009 01:07 PM
Classiarius Go to last post
3 342
With sql server 2000 Personal edition I was able to load the Olap server on my workstation on practice some mdx queries on a cube with the sample...
11-09-2009 03:31 PM
Rich Go to last post
3 150
Hi, Can any one help me with sorting the data year wise for below MDX without much changing the MDX means that data should be displayed...
11-09-2009 07:01 AM
amish Go to last post
1 135
Using a Dynamic Named Set won't help here, because it isn't re-evaluated for every cell in the result set. Directly evaluating the Top 2...
11-02-2009 03:12 PM
Json Go to last post
1 128
Hi, I'm trying to hide a dimension (in all cubes) for a role but there are no alternative for the Access property like "none" in the Dimension tab...
10-28-2009 05:04 PM
dpuri Go to last post
1 143
this is my case... i have a measure called Rank with this value: 3 2 4 1 ad a dimension OPTION with the members OPTION - Percentage
10-28-2009 04:30 PM
dpuri Go to last post
1 145
How do I recieve and implement user input for (measure) cube writeback on analysis service 2008?
10-28-2009 04:48 AM
Retha via SQLMonster.com Go to last post
4 139
Hello developers, How to enable Excel 2007 "Trust access to the VBA project object model" option during VSTO add-in setup? My add-in requires that...
10-22-2009 07:23 AM
Thomas Go to last post
1 118
Warning: I suspect it'll take a hotshot SSAS guru to sort this out. As noted in the title of this question, my basic problem is that I'm getting...
10-22-2009 02:48 AM
Marco Russo Go to last post
1 232
Hi, Just wonder how am going to filter member by using the following command. ..ExcludedMember = (" ") --> if i want to filter customer Last...
Lester Lim
10-21-2009 09:16 PM
SQLKID Go to last post
1 119
Hi there, I am new to SSAS, and I was wondering wether the following was possible : - One fact table : myTable myTable contains many codes...
10-16-2009 06:37 PM
dpuri Go to last post
5 151
My time dimension is Year-Month-Week-Day, but I want to query the total week, not the week from that month. Below is a sample query where I get 2...
CIndy Lee
10-16-2009 06:21 PM
dpuri Go to last post
1 107
Hi, I would like to know is there a simple way to export the configuration of the Cube from one SSAS to another SSAS that could be on another...
10-16-2009 12:54 PM
LawnMowerHater Go to last post
2 157
Hi, I will construct AS cubes on a server I must not be server "administrator" on , so we added my user in Analysis server Properties /...
10-16-2009 03:32 AM
Jerome Go to last post
1 101
HI Just wondering anyone out there who've had success in implementing security on measures i SSAS2005 I've tried to deny access to...
10-15-2009 07:15 AM
fsk@platon.net Go to last post
1 103
I'm trying to do a query to that I pick the top 5 customer sales in one year and then using those same customers get the sales for the previous 4...
10-04-2009 11:43 AM
dpuri Go to last post
1 275
Hello Developers, Probably it is a trivial question but I cannot find out what the rules are. Why both queries attached below return the same...
09-29-2009 06:47 AM
Charles Wang [MSFT] Go to last post
3 240
I have a VPC (Win 2003, SQL 2008, MOSS 2007). I applied the SQL 2005 packs in ordere to install PPS on SQL 2008. WAs able to view SA ScoreCard in...
09-28-2009 04:57 AM
tansu Go to last post
1 370
Hi, I have following problem: In my query I have 2 time dimensions and they are nested as follows 01/04/2009 03/03/2009 04/03/2009
09-25-2009 08:53 PM
Zheng Xie Go to last post
1 131
Hi. I am using PeriodsToDate function to calculate YearToDate averages for a series of periods in a year. example: periods: 1,2,3 values: 100, 200,...
Piotr Lipski
09-25-2009 04:05 AM
eljay Go to last post
1 133
There was a post on 1/31/2007 that describes the issue. I created a posting under that, but I have not seen any responses from Microsoft. Please...
09-24-2009 11:44 PM
Anne Rocco Go to last post
4 165
We are using data services to produce a report in Excel from our MS Project Server OLAP cubes. One of the worksheets shows forecasted assignments...
09-24-2009 07:41 AM
Rainbow Go to last post
1 127
Hello Developers, Probably it is a trivial question but I cannot find out what the rules are. Why both queries attached below return the same...
09-22-2009 01:25 PM
Thomas Go to last post
2 128
Hi, I have a snapshot time dimension (date, month, year) that my users wants to roll up to month and year as the latest snapshot in current month /...
09-22-2009 11:24 AM
[MSFT] Wayne Robertson Go to last post
1 127
Hello, I have found a many Cubes on our company's ssas servers, but the vs projects are gone. Is there a way to generate project from existing...
09-21-2009 09:32 AM
eljay Go to last post
2 196
I've got an server running SQL Server 2005 and Analysis services on the same box. Server is W2K3 R2 Sp2, with 32 gb ram. I've configures SQl Server...
09-18-2009 09:50 AM
[MSFT] Wayne Robertson Go to last post
1 145
Hi, I don't know how exactly how to do this for sql 2000 So for example I have the following set of data: Table: tbl_country_costs Country Type ...
09-17-2009 11:08 PM
Duc Bui Trong Go to last post
1 113
Hello, in a SSAS 2005 project, the target edition is Standard Edition. Can the Developer Edition behave like Standard Edition, so that I won't get...
Thomas Steinmaurer
09-17-2009 02:09 PM
Jeroen Mostert Go to last post
2 123
I am creating offline cube file over AS2008 cubes. The week dimension is ordered based on an attribute field ("DisplaySequenceID") While browsing on...
Minas Papageorgiou
09-14-2009 08:24 PM
Nathan Peterson Go to last post
1 243
Hi I looking for help regarding HOWTO place named sets on an axis in a manner similar to a dimension in a client application. I'm using OWC 9.0...
09-12-2009 04:10 PM
Chris Go to last post
4 193
This post is not a question, but just to share a resolution to an SSAS 2005 syncronize issue when upgrading our OLAP environment. In our environment...
09-10-2009 11:25 AM
Jesse O Go to last post
1 108
I have migrated my cube to a new server. But when I process the cube, it still points to source data on original server. How can I change cube...
Mike Torry
09-09-2009 04:31 PM
Roberto H. Go to last post
3 304
I recently ran the BPA against our SSAS cube and it came out with several warnings of the type: "The 'Date' granularity attribute from the 'Trading...
09-07-2009 03:06 AM
MervynScarlett Go to last post
3 150
I'm a newbie when it comes to SSAS, so let me just preface this question with a "pardon my ignorance" clause. I am with a small insurance company,...
09-04-2009 09:39 AM
[MSFT] Wayne Robertson Go to last post
1 120
Okay, here is a tricky one... I have two tables (in Dynamics Ax). The first tables has six different fields and each field references the id field...
09-04-2009 09:29 AM
[MSFT] Wayne Robertson Go to last post
1 128
Hi, Is it possible to encrypt an OLAP database design so at the customers servers the olap administrators only can process (and administer roles)...
09-04-2009 09:09 AM
[MSFT] Wayne Robertson Go to last post
1 96
Hi all, i'm using SQL Server 2005 (build 9.00.3239.00). In one of our cubes (called "Cube 1") we have defined an MDX calculation script. This script...
09-02-2009 09:25 AM
Antonio Go to last post
4 536
I want to select all the countries except one, I try something like this but it does not work. SELECT {.Units} on columns, {.members} on rows FROM...
Roberto H.
09-01-2009 04:22 PM
Roberto H. Go to last post
2 231
As far as I have understood, virtual cubes do not exist in SQL Server 2008. Instead I have created a Cube that uses linked objects, a small selection...
08-31-2009 07:21 AM
Jonas Go to last post
2 117
SSAS Team, Our scenario is this. We have SSAS 2008 and SQL Server 2008 installed on a Windows 2008 Server Enterprise Edition (64 bit) with 64 GB of...
Michael Briggs
08-28-2009 04:05 PM
[MSFT] Wayne Robertson Go to last post
7 127
In the SSAS 2008 Performance Guide (page 30 under Partition Slicing) there was a statement that's confusing in my mind: Whenever you use multiple...
Jesse O
08-27-2009 01:33 PM
[MSFT] Wayne Robertson Go to last post
1 104
I have a cube with (lets say) sales information. The security resuirement is that users can see all information except the name of clients that is...
08-26-2009 04:08 PM
[MSFT] Wayne Robertson Go to last post
1 99
I'm using SQL Server Analysis Services 2005 Standard. I have a calculation as folows: Turnover Rate = Terminaion Count / Employee Count At End Of...
08-12-2009 03:23 AM
baty Go to last post
1 151
I have an OLAP 2000 server with multiple cube databases on it, each of which has the same structure, just different data. Can anybody tell me how to...
Doug Tumeo
08-12-2009 03:17 AM
baty Go to last post
1 105
I have tried to define aggregation rules in our OLAP cube but when I trace queries using the SQL Server Profiler I only ever see Partitions being...
08-11-2009 06:13 AM
John Go to last post
4 163
Post New Thread

Display Options
Showing threads 101 to 150 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.