Recent content by M8tt

Many thanks Denny that has worked. I must of checked the permissions on the folders beneath root half a dozen times without realising I needed to do the same thing on root itself. Thanks again, Matt

I have a user who has developed a simple reporting website using Reporting Services. This uses anonymous access in IIS, but I need to disable this so that I can pass user credentials through to the SQL Server which runs on the same machine. However when I disable anonymous access (IIS Manager...

Thanks very much Paul, that has been irritating me for the past week!

Hi, I have a measure coming from a database field with the data type decimal(18,2), in AS the field is AggregateFunction = Sum and DataType = Double. When I look at the aggregated values some have the 2 decimal places I would expect to see but others go to 6 decimal places. This is not...

Hello, I'm just wondering if anyone has tried using Business Objects Voyager with MSAS 2005's drillthrough actions? I have Voyager successfully picking up a 2005 olap cube but I cannot get it to see a drillthrough action within that cube, I've tried various things but I'm starting to wonder if...

Hello, I'm just wondering if anyone has tried using Voyager with MSAS 2005's drillthrough actions? I have Voyager successfully picking up a 2005 olap cube but I cannot get it to see a drillthrough action within that cube, I've tried various things but I'm starting to wonder if it is...

Hi, I'm looking for some assistance with drill-throughs on SSAS 2005. I've built a Cube from several Dimensions and a Fact Table, the Fact comprises some measures and a description field which is neither a measure nor a Dimension attribute. I now want to define a drill-through which I would...

Many thanks, those advanced settings should provide the required control. Only snag is it means I'll end up issuing/managing seperate BO and db log-ins but I don't think I'm going to get around that. Thanks again, Matt

Hello, Having just migrated to BOXI I'm in the process of trying to overhaul our BO access/security and enforce row level security on our database for both connections through Universes (webi and CR) and directly to the database (CR). I have a solution for the Universe part of this: using the...

I'm in the process of rebuilding a 2000 DTS package in 2005 and am hoping for some advice on the best way to use the Data Flow to do this. In my 2000 DTS I have around 30 tables which are being transferred from 1 SQL database to another SQL database using 30 seperate Transform Data Tasks. I...

We have numerous reports in CE8.5 which display graphs, some of which have been happily working for a couple of years now. However we have suddenly developed a problem whereby the graphs on reports are no longer there when they are viewed and where the graph was we now just have white space...

Thanks for the suggestions and I have found a way around this by using subscript to return the data from the array in 2 seperate lots (as I know it doesn't exceed 2 lots of 255) in 2 seperate formulas. The first: whileprintingrecords; stringvar SG1; numbervar cnt:= ubound({?Solver Group})...

Nice idea but unfortunately not - I still get the same error, presumably because Crystal is making the 'join' calc before the 'left' calc and therefore hitting the 255 limit.

Madawc, Sorry, I'm being a bit thick here but when I try.... Split({?Solver Group}, "")[1] .... as you suggest, I get the following error: This array must be subscripted. For example Array[i]. Can you tell me what I'm doing wrong? Thanks again, Matt

Are you saying I can extract the various values of the parameter array out and show them in seperate fields? If so can you advise how I would go about doing this? I can get the highest/lowest values using maximum/minimum but have been unable to get at the values between them. Many Thanks, Matt