|
More site info...
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.
|
|
|
|
|
Posting activity on Analysis (OLAP):
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
6
|
42
|
148
|
|
Post:
|
6
|
49
|
176
|
|
|
Analysis (OLAP) Posting activity graph:
|
Top authors during last week:
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...
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...
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...
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( ...
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)::
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...
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 ...
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 ...
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]}.
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
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 ...
|
|
Hot threads for last week on 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...
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 ...
|
|