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     
We have a server with Analysis Services 2005 SP2 and the SQL Server 2005 SP2 Enterprise. AS processing is failing and performance counters point...
Handyman
11-29-2009 02:37 PM
Will Alber Go to last post
1 119
SELECT NON EMPTY {TopCount({Crossjoin({.},{...AllMembers})},20,.)} ON COLUMNS, NON EMPTY {hierarchize(TopCount({.. .AllMembers},20,.))} ON ROWS FROM...
rupniceguy@gmail.com
11-19-2009 02:30 AM
rupniceguy@gmail.com Go to last post
2 126
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...
light_wt
11-15-2009 05:34 AM
amish Go to last post
3 152
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 154
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 262
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...
Rich
11-09-2009 03:31 PM
Rich Go to last post
3 131
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...
rupniceguy@gmail.com
11-09-2009 07:01 AM
amish Go to last post
1 107
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...
dpuri
11-02-2009 03:12 PM
Json Go to last post
1 121
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...
Jerome
10-28-2009 05:04 PM
dpuri Go to last post
1 124
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
Carnefrisca
10-28-2009 04:30 PM
dpuri Go to last post
1 130
How do I recieve and implement user input for (measure) cube writeback on analysis service 2008?
Newbe
10-28-2009 04:48 AM
Retha via SQLMonster.com Go to last post
4 128
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...
Thomas
10-22-2009 07:23 AM
Thomas Go to last post
1 101
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...
LawnMowerHater
10-22-2009 02:48 AM
Marco Russo Go to last post
1 192
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 107
Hi there, I am new to SSAS, and I was wondering wether the following was possible : - One fact table : myTable myTable contains many codes...
Stefan[www.itsconsulting.fr]
10-16-2009 06:37 PM
dpuri Go to last post
5 127
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 88
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...
Stefan[www.itsconsulting.fr]
10-16-2009 12:54 PM
LawnMowerHater Go to last post
2 133
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 /...
Jerome
10-16-2009 03:32 AM
Jerome Go to last post
1 89
HI Just wondering anyone out there who've had success in implementing security on measures i SSAS2005 I've tried to deny access to...
fsk@platon.net
10-15-2009 07:15 AM
fsk@platon.net Go to last post
1 92
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...
SQLKID
10-04-2009 11:43 AM
dpuri Go to last post
1 265
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...
Thomas
09-29-2009 06:47 AM
Charles Wang [MSFT] Go to last post
3 229
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...
shacham
09-28-2009 04:57 AM
tansu Go to last post
1 328
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
DominicB
09-25-2009 08:53 PM
Zheng Xie Go to last post
1 121
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 120
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...
pietrzbm
09-24-2009 11:44 PM
Anne Rocco Go to last post
4 137
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...
rebecca
09-24-2009 07:41 AM
Rainbow Go to last post
1 115
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...
Thomas
09-22-2009 01:25 PM
Thomas Go to last post
2 114
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 /...
Jerome
09-22-2009 11:24 AM
[MSFT] Wayne Robertson Go to last post
1 110
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...
eljay
09-21-2009 09:32 AM
eljay Go to last post
2 179
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...
MRWildiac
09-18-2009 09:50 AM
[MSFT] Wayne Robertson Go to last post
1 134
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 ...
caliguy1979
09-17-2009 11:08 PM
Duc Bui Trong Go to last post
1 101
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 104
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 183
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...
Madan
09-12-2009 04:10 PM
Chris Go to last post
4 168
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...
bhays40@gmail.com
09-10-2009 11:25 AM
Jesse O Go to last post
1 96
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 288
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...
MervynScarlett
09-07-2009 03:06 AM
MervynScarlett Go to last post
3 118
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,...
IT
09-04-2009 09:39 AM
[MSFT] Wayne Robertson Go to last post
1 107
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...
Jonas
09-04-2009 09:29 AM
[MSFT] Wayne Robertson Go to last post
1 110
Hi, Is it possible to encrypt an OLAP database design so at the customers servers the olap administrators only can process (and administer roles)...
Jerome
09-04-2009 09:09 AM
[MSFT] Wayne Robertson Go to last post
1 82
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...
Antonio
09-02-2009 09:25 AM
Antonio Go to last post
4 292
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 217
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...
Jonas
08-31-2009 07:21 AM
Jonas Go to last post
2 109
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 112
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 95
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...
Antoon
08-26-2009 04:08 PM
[MSFT] Wayne Robertson Go to last post
1 89
I'm using SQL Server Analysis Services 2005 Standard. I have a calculation as folows: Turnover Rate = Terminaion Count / Employee Count At End Of...
Jonathan
08-12-2009 03:23 AM
baty Go to last post
1 133
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 95
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...
MervynScarlett
08-11-2009 06:13 AM
John Go to last post
4 118
Hi All, In my cube I have both measures aggregating with SUM and AVERAGEOFCHILD. I have a report where I show measures of both types combined on...
DominicB
08-10-2009 10:32 AM
DominicB Go to last post
1 96
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 - 2014, Jelsoft Enterprises Ltd.