dbTalk Databases Forums  

Record limit per filter axis tuple

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Record limit per filter axis tuple in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Web1987
 
Posts: n/a

Default Record limit per filter axis tuple - 12-20-2005 , 12:40 PM






When drilling through on a cube in the BI Portal, receive a message: Only
the first 5000 records per filter axis tuple will be displayed.
Is it possible to change this limit? If so, where and how would I make this
change.

Reply With Quote
  #2  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Record limit per filter axis tuple - 12-20-2005 , 08:06 PM






Hello,

Based on my scope, there is no limitation on AS server side related to this
problem. I belive this limitation is from BI portal Web application for
performance purpose. Usually it may take too long to render a page more
than 5000 records. You may want to contact the vendor for more information
about this.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
Quote:
Thread-Topic: Record limit per filter axis tuple
thread-index: AcYFlMqhk755gyfQRB+5p1yHFG5DjQ==
X-WBNR-Posting-Host: 204.152.32.251
From: "=?Utf-8?B?V2ViMTk4Nw==?=" <Web1987 (AT) nospam (DOT) nospam
Subject: Record limit per filter axis tuple
Date: Tue, 20 Dec 2005 10:40:03 -0800
Lines: 4
Message-ID: <BA8058D7-B2D9-4ABA-AB76-B0C0203997F9 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.olap
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:65628
X-Tomcat-NG: microsoft.public.sqlserver.olap

When drilling through on a cube in the BI Portal, receive a message: Only
the first 5000 records per filter axis tuple will be displayed.
Is it possible to change this limit? If so, where and how would I make
this
change.



Reply With Quote
Reply




Thread Tools
Display Modes

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 - 2012, Jelsoft Enterprises Ltd.