Search Results | SQL Server Performance Forums

How to select data on 31 Dec

Thread by: biru, Jul 25, 2007, 1 replies, in forum: Analysis Services/Data Warehousing

Hi everyone...i'm developing an OLAP report which consist of date and vehicle dimension...and also Amount as measure...the date dimension consist of...

Value in percentage

Post by: biru, Jul 13, 2007 in forum: Analysis Services/Data Warehousing

i'm using analysis services and sql server 2000..in the example that i gave earlier, there's a measure called Amount..as far as i know, we can't...

Value in percentage

Post by: biru, Jul 13, 2007 in forum: Analysis Services/Data Warehousing

Thank u ndinakar...but can u explain more on how to do that...coz i'm quite new to olap report..lots of thing i still don't know yet...

Value in percentage

Thread by: biru, Jul 13, 2007, 4 replies, in forum: Analysis Services/Data Warehousing

Hello...i have a question here..how can i display the value in an olap report in percentage(%) based on the selected criteria?...because currently i...

how to avoid the report from total up the value?

Thread by: biru, Jun 4, 2007, 1 replies, in forum: Analysis Services/Data Warehousing

Hi everyone...i've created an olap report using the pivottable in excel which contain data like opening and closing balance...the closing balance for...

problem with refreshing data in olap report

Post by: biru, May 22, 2007 in forum: Analysis Services/Data Warehousing

hi..i'm asking about refreshing data on the excel...i'm using MS Office Professional Edition 2003...sorry coz in the ealier question i provided you...

problem with refreshing data in olap report

Thread by: biru, May 21, 2007, 3 replies, in forum: Analysis Services/Data Warehousing

hi...i have a question here..why does it take so long for me to refresh the data in an OLAP report?...when i want to refresh the data it will take...