Search results for query: *

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...

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...

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...

I have a String Parameter field set to have discrete, multiple values which I need to display on the header of my report. I've achieved this with the following formula.... join({?Solver Group},chr(13)) .... and that works fine until many values are selected and the combined lengths of those...

I have a CR8.5 Report on BOXI InfoView which I am unsuccessfully trying to export to a network drive. The Report runs successfully when I export it to a local drive but fails when I point it at the network drive and I'm struggling to understand why. I have previously set the same report up on...

Hi, I have a DTS package running about 30 various tasks. In the middle there are 2 'Execute SQl Tasks'; the first one of these takes a table field and sets all of the values in it to 'N', the second one applies some criteria and sets some of the records to 'Y'. When run independently (i.e. -...

I have written the insert statement below to load some db info into a table. insert into [DB_SIZES]( [NAME], [FILE_PATH], [SIZE] ) select name, filename, (size * 8) from sysfiles I have created this as a Stored Procedure but I think this is going to limit me to using it within a single...

I have the following view which extracts the top 10 records from a table based on their costs. The view sorts these records in descending order so the most expensive one is at the top. What I would like to do is add a new column as a running count to the view so that the first one is 1 and the...

The following two pieces of code seem to do the same thing, but I am curious as to which is the better to use? Could someone please summarise what the differences are and which, if any, is the 'better' one to use. Many Thanks in advance. Select EQUI.EQUNR From EQUI Inner join AFIH on...

I have the following code to set the field MATERIAL_DESC on the basis of a value in the MATERIAL field. Update [DB1].[dbo].[DIM_MATERIAL] Set MATERIAL_DESC = 'Consumables' From DIM_MATERIAL Where MATERIAL = 'Z0001' Update [DB1].[dbo].[DIM_MATERIAL] Set MATERIAL_DESC = 'Repairables' From...

I have a Table which I need to report summary information from and to assist with my testing of this I was wondering if it is possible to return summary fields against records in a results set without losing visibility of the detailed records which constitute them? As an example of what I am...

I have a Data Transformation Task which is going to end up with 40-50 lines of code in it using table names which are quite lengthy. In order to make the code shorter and easier to read I am trying to substitute the table names with a variable but I am not having much joy and don't even know if...

I have a Firewall running Solaris 2.6 with a /30 link network connecting it to a Router on its qfe0 interface. I am attempting to set-up a second /30 link network as a virtual interface to connect to the same Router but am having problems getting the connection up. The connections look as...

When using the following syntax in an SQL Expression: {fn SUBSTRING(C0FNAT."WORKINGRELATIVEPATH",7,1)} I am getting the following errors: ORA-00911; invalid character and Error in compiling SQL Expression: Invalid function found here. The field in question is a blob field in an...

I am working with a spreadsheet that looks similar to the following: - Col.1 Col.2 Item 1 Part A Item 2 Part B Part C Item 3 Part D Part E Part F Item 4 Part G And I am aiming to get this data into a format similar to: - Col.1 Col.2 Item 1...