Hi ,
I need to know how to make a cube faster the cube i built have millions of data and it is very slow while browsing how can make it faster also i would like to know about aggregation in SSAS ...
http://www.experts-exchange.com/Microsoft/Development/Q_23533768.html
I run Windows XP on PC with ASUS A7A266 Motherboard, 1.2GHz Athlon CPU, 512Mb DDR RAM, 2 Maxtor 40 Gb HDD's, PCi USB2 card. For no apparent reason, at every boot, a Found new hardware box pops up c...
http://www.experts-exchange.com/Hardware/Desktops/Q_20958361.html
Hi all,
I use views when defining bjects in SSAS data sources. For example rather than adding the date table, I use a view which (in most cases) is just a select * from date table.
I like to ...
http://www.experts-exchange.com/Database/OLAP/Q_22944831.html
Is there a way to show column names in business terms, when doing a drill to detail in Proclarity?
Example: In our report, when we do a drill to detail it shows column name as [$Machine_Dim.col...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2309...
When a OLAP cube is full processed error is reported.
Details:
First time when I deploy the cube I dont have any issues
After the dimensional tables rows are added then the full process ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2323...
So, if I have multiple fact tables in my cube, and they share the same dimensions, what is the best practice for the dimension in the cube? Should I add a view for the dimension so I can link to b...
http://www.experts-exchange.com/Database/OLAP/Q_23326909.html
Hi ,
I have created a new data warehouse which has a dimension table User with all the user details like username, userid, FirstName,lastname,DOB, gender, Age etc .. and have measure groups lik...
http://www.experts-exchange.com/Database/OLAP/Q_23537517.html
Hi,
My cube processed fine on my desktop but when I tried to process the dimension of the cubes on the VM its taking ages the VM behaviour is completely different . the dimension processing is st...
http://www.experts-exchange.com/Database/OLAP/Q_23546182.html
Zones:
OLAPDate Answered: 07/09/2008 Grade: B Views: 4
i have cubes on SSAS. do i need from time to time (or daily basis) to clear memory? i ask because i see decline in the performance.
this is even tough i have agrregations working.
if so - can y...
http://www.experts-exchange.com/Database/OLAP/Q_23606725.html
Zones:
OLAPDate Answered: 08/21/2008 Grade: A Views: 5
I have a site that is connected to the main site via a VPN connection.
When the users leave the Siebel application open and idle for more than 1 hour they receive the following errors:
Generic S...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20567713.html
Zones:
DatabasesDate Answered: 02/18/2004 Grade: A Views: 5
