RE: Querying a cube...!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sanka (loonysan_at_mailcity.com)
Date: 02/12/04


Date: Thu, 12 Feb 2004 00:11:06 -0800


Check Out this URL.

     http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/Optimize/AnSvcsPG.asp

Cheers,
Sanka

     ----- AlejoR wrote: -----
     
     Hello people
     When I filter a dimesion the cube is too slow to refresh the data.
     How to makes a cube really fast when I filter that or any dimension.
     Thanks
     
     
     



Relevant Pages

  • HELP! Dimension Security
    ... this filter, which I found in the SQL Server Mag January ... This filter is applied to the institution dimension ... I have a virtual cube that points to two ... (regarding what members they can see), ...
    (microsoft.public.sqlserver.security)
  • RE: Filtering dimensions - where the fact table also needs filtering
    ... You could use the "Source Table Filter" property of the Cube to filter out ... > Sample data view of the Sales cube appears to work. ... > Attempted to reprocess the Sales Cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: Filtering out blank values from a cube
    ... data in the Cube browser/pivot table. ... set of rows but the output of the Bottom 5 would be different as there ... And use the same Named Set as a filter when I browse the ...
    (microsoft.public.sqlserver.olap)
  • Macro and Pivot tables using a CUBE as data source
    ... I'm using several pivot tables all driven from the same Cube. ... using the same field to filter on [MAJOR TERMINAL CODE-NAME]. ... Any idea how to capture both columns to the variable pivotchoice ...
    (microsoft.public.excel.programming)
  • Excel and Pivot Table performances
    ... I would like to know what is happening on my SSAS 2005 cube when I browse it ... role), can see all data, while the other roles have a filter on the measures ... Let's consider the client dimension, ... Imagine to browse the cube in Excel 2007, with users who belong to different ...
    (microsoft.public.sqlserver.olap)