Home > Archive > MS SQL Server OLAP > December 2005 > Record limit per filter axis tuple









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Record limit per filter axis tuple
Web1987

2005-12-20, 1:24 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.
Peter Yang [MSFT]

2005-12-20, 8:25 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.


--------------------
>Thread-Topic: Record limit per filter axis tuple
>thread-index: AcYFlMqhk755gyfQRB+5
p1yHFG5DjQ==
>X-WBNR-Posting-Host: 204.152.32.251
>From: "=?Utf-8?B?V2ViMTk4Nw==?=" <Web1987@nospam.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@microso
ft.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!TK2MSFTNGXA03.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.
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com