RE: Querying a cube...!
Tech-Archive recommends: Fix windows errors by optimizing your registry
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) |
|