Search results for query: *

How can you calculate actual values using year-to-date values in SQL (using no bespoke function calls). The source table: Period Site Actual YTD The Destination table: Period Site Actual YTD Actual The YTD values start at period 1 and end at period 12. They start fresh each year. Once...

Does anyone in the group have experience of both these products or done a product comparison? The Microsoft website claims the tool can do everything other BI vendors can, but at a significantly lower price - does anyone know how true these claims are? Thanks in advance Lee

Thanks. I've now got the case statement produced in the SQL, however when I include a metric it is not included in the group by and hence the SQL will not run. Any ideas? All I am trying to acheive is to convert a code into a meaningful description. I'll have a go at the comparison report...

I have a number of questions that I hope you can help me with... 1. On my Time Dimension table I have a column called 'Relative Week Code' containing numbers relating to the business week e.g. 0 is Current Week, -1 is Last Week, -2 is Previous Week, etc etc. I would like to create an object to...

Does anyone know of a company offering Microstrategy7 training in the UK, other than Microstrategy?

If anyone has any documents (or ideas) regarding businessobjects best practices for universe/report design, admin, deployment, infrastructure etc and would be willing to share it would be much appreciated. Thanks in advance Lee

As I am new to this site I am unsure of the protocol, so if I step out of line then I apologise. Background - I have spent the past 2 years on various BusinessObjects development projects, however I also have some very limited experience on the old DSS Agent kit. I have a list of questions...