Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Analysis (OLAP) | Forum profile

Forum profile page for Analysis (OLAP) on http://www.sqlmonster.com. This report page is the aggregated overview from a single forum: Analysis (OLAP), located on the Message Board at http://www.sqlmonster.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Analysis (OLAP)" on the Message Board at http://www.sqlmonster.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: SQL Server Forum - Analysis (OLAP) (site profile, domain info sqlmonster.com)
Title: Analysis (OLAP)
Url: http://www.sqlmonster.com/Uwe/Forums.aspx/sql-s...
Users activity: 12 post per thread
Forum activity: 6 active threads during last week
 

Posting activity on Analysis (OLAP):

  Week Month 3 Months
Threads: 6 42 148
Post: 6 49 176
 

Analysis (OLAP) Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Will Alber
2
user's latest post:
Connecting to OLAP Cube
Published (2009-11-30 00:24:00)
Take a look at http://msdn.microsoft.com/en-us/library/cc917711.aspx  which details setting up Analysis Services 2005 to work over HTTP (this is for Win2K3, WinXP details are available here http://technet.microsoft.com/en-us/library/cc917712.aspx ).  Be careful to ensure that you configure security so as to not open your analysis server up to hackers, though. > Please help me understand... > [quoted text clipped...
Piquet
1
user's latest post:
SSAS 2005: How to I change...
Published (2009-11-23 01:59:00)
I am experiencing the same issue in SQL 2008 with a view in my DSV, however the ramifications are worse - the Logical Primary Key that BIDS selects for this view is NOT A UNIQUE KEY for the records exposed by this view - at least with the example provided above the logical primary key, whilst excessive, at least still provides uniqueness. In my case, as I wish to provide fact-table details on a drill-through action, I have problems doing this...
igor
1
user's latest post:
HideMemberIf still not working...
Published (2009-11-24 10:21:00)
Hi all, I've found some posts that this feature is not working (unless applied onto leaf levels) in 2005, and now I'm trying to get it working on 2008 and it seems it's still now working? Really? This used to work under AS 2000 :( I have Country->Region->City hierarchy and have set HideMemberIf on Region. I've tried both ParentName, OnlyChildWithParentName and NoName and it simply doesn't work (Of...
Dorota
1
user's latest post:
How enhance performance of...
Published (2009-11-29 16:33:00)
Hi , I have cube with four dimensions: [ORG] (levels:[SO_KANAL], [SO_STRUMIEN],[ORG]), [SP_KATEGORIA] (level [SP_KATEGORIA]),[TYDZIEN_B_N] ( levels: [ROK_B_N],[POLROCZE_B_N],[KWARTAL_B_N],[TYDZIEN_B_N]), [Wersja budzetu] (level [Wersja budzetu].[Wersja budzetu]) I have to aggregate data from lowest level. I have created following calculated members: CREATE MEMBER CURRENTCUBE.Measures.[KS_PL_wsp_otwarciowy] AS iif(  ...
Pradeep
1
user's latest post:
Filtering dimensions that...
Published (2009-12-01 12:17:00)
Hi All, I'm facing problem in filtering dimensions. The dimensions look like Customer_City     Alamo     Dallas     Atkins     Wilmar Customer_State     TX     AR Geography      City_State     Alamo, TX...
 

Latest active threads on Analysis (OLAP)::

SQL Server Forum
Started 3 days, 6 hours ago (2009-11-30 00:24:00)  by Will Alber
Take a look at http://msdn.microsoft.com/en-us/library/cc917711.a spx which details setting up Analysis Services 2005 to work over HTTP (this is for Win2K3, WinXP details are available here http://technet.microsoft.com/en-us/library/cc91771 2.aspx ). Be careful to ensure that you configure security so as to not open your analysis server up to hackers, though. > Please help me understand...
Thread:  Show this thread (2 posts)   Thread info: Connecting to OLAP Cube Size: 889 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Connecting to OLAP Cube :: Analysis (OLAP) :: SQL Server Forum"
SQL Server Forum
Started 3 days, 9 hours ago (2009-11-29 20:37:00)  by Will Alber
I can't see that turning on AWE for the relational engine can be a bad thing in this situation - if you've the potential to separate the relational and analysis servers then this would be the better option, IMO. I personally wouldn't suggest messing with AS memory limits - perhaps on a 64-bit box I might limit AS to xGB, but on a 32-bit box (unless your AS databases are trivial) leaving AS ...
Thread:  Show this thread (2 posts)   Thread info: Analysis Services and relational engine on same server Size: 975 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Analysis Services and relational engine on same server :: Analysis (OLAP) :: SQL Server Forum"
SQL Server Forum
Started 10 months, 3 weeks ago (2009-01-12 00:58:00)  by mano
Hi! First Happy New Year! I would like to ask some questions about Microsoft BI. I am from Bulgaria - Sofia university and I chose to write diplom work for my master degree on theme "Microsoft Business Intelligences technologies research". My diplom work instructor gave me the following questions as a base points for my diplom work: - ROLAP, MOLAP и HOLAP support in Microsoft BI - data ...
Thread:  Show this thread (3 posts)   Thread info: SSAS 2005: How to I change logical primary key in data source view Size: 1,249 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SSAS 2005: How to I change logical primary key in data source view :: Analysis (OLAP) :: SQL Server Forum"
SQL Server Forum
Started 2 weeks, 1 day ago (2009-11-18 04:20:00)  by Zheng Xie
In ([Product].[Color].&[Black],[Product].[Color].&[Re d]), the () is a tuple which needs members from different hierarchies. If you only want to aggregate them, you can simply change ([Product]. [Color].&[Black],[Product].[Color].&[Red]) to be {[Product].[Color].& [Black],[Product].[Color].&[Red]}.
Thread:  Show this thread (3 posts)   Thread info: More than one slices from same dimension in Where clause not working Size: 348 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: More than one slices from same dimension in Where clause not working :: Analysis (OLAP) :: SQL Server Forum"
SQL Server Forum
Started 2 weeks, 5 days ago (2009-11-13 12:04:00)  by Charles Wang [MSFT]
Is your server also serving for other applications with heavy load on network/disk etc? You can use Performance Monitor to monitor this. Another reason is probably related to cache. What is the result if you perform a full process of your cube on your server? Best regards, Charles Wang
Thread:  Show this thread (4 posts)   Thread info: Why is my more powerful server slower than my laptop (same database, same
query)? Size: 319 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why is my more powerful server slower than my laptop (same database, same
query)? :: Analysis (OLAP) :: SQL Server Forum"
SQL Server Forum
Started 1 year, 4 months ago (2008-07-28 08:25:00)  by Charles Wang [MSFT]
Hi Craighb, Thank you for using Microsoft MSDN Managed Newsgroup. From your description, I understand that you could not deploy your SSAS project to your live server that is in a different network. If I have misunderstood, please let me know. From the issue appearances, it seemed that this issue was most likely related to network access configurations or permissions. For network connection ...
Thread:  Show this thread (8 posts)   Thread info: Error deploying database to SQL Server Analysis Server Size: 5,151 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Error deploying database to SQL Server Analysis Server :: Analysis (OLAP) :: SQL Server Forum"
 

Hot threads for last week on Analysis (OLAP)::

Analysis (OLAP)
Started 3 days, 6 hours ago (2009-11-30 00:24:00)  by Will Alber
Take a look at http://msdn.microsoft.com/en-us/library/cc917711.a spx which details setting up Analysis Services 2005 to work over HTTP (this is for Win2K3, WinXP details are available here http://technet.microsoft.com/en-us/library/cc91771 2.aspx ). Be careful to ensure that you configure security so as to not open your analysis server up to hackers, though. > Please help me understand...
Thread:  Show this thread (2 posts)   Thread info: Connecting to OLAP Cube Size: 889 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Connecting to OLAP Cube :: Analysis (OLAP) :: SQL Server Forum"
Analysis (OLAP)
Started 3 days, 9 hours ago (2009-11-29 20:37:00)  by Will Alber
I can't see that turning on AWE for the relational engine can be a bad thing in this situation - if you've the potential to separate the relational and analysis servers then this would be the better option, IMO. I personally wouldn't suggest messing with AS memory limits - perhaps on a 64-bit box I might limit AS to xGB, but on a 32-bit box (unless your AS databases are trivial) leaving AS ...
Thread:  Show this thread (2 posts)   Thread info: Analysis Services and relational engine on same server Size: 975 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Analysis Services and relational engine on same server :: Analysis (OLAP) :: SQL Server Forum"