Search results for query: *

Hi, I am importing from one SQL server to another using the standard Data Flow task. Within that task I use the SQL command as the Data access mode i.e SELECT * FROM view_A. Dumping the resulting 23940 records straight into TableB. It has been working fine until it failed last night, with the...

Hi, I use a TSOT to copy approx 700 tables between one server and another as an overnight package. This data is set to replace and there are no other objects (views, etc) being copied. What I have noticed by looking at the event log, is that it takes about 1 and 1/2 hours between the package...

Hi, While messing about trying to work out a way so that when a field does not have any data for a parameter all records are returned I stumbled along: declare @schcode varchar(2) SET @schcode = '13' --returns records for 13 (13 is a valid school) select * FROM udw.division as d left join...

Hi, Following the instructions found in http://blogs.msdn.com/performancepoint/archive/2007/10/05/implementing-a-hyperlink-from-a-kpi-in-a-scorecard.aspx I can create a link to bring up a webpage. However the design of our dashboard is based on 2 different Scorecards (each with their own KPIs)...

Hi, Is it possible to add a Sharepoint Integrated report where the url starts with https ? The examples given all use: http://someMachine/reportserver and http://someMachine/Documents/report.rdl where we are using https://someMachine/reportserver and https://someMachine/Documents/report.rdl...

Hi, I am trying to add a existing SSRS report via the SSRS Report Viewer Web part, and I get the following message "ASP.NET ViewState has been disabled. The Report Viewer control requires that ViewState be enabled. " I have checked the web.config files on the server and it has the following line...

Hi, I am using a BT VOyager 2100 router with Orange (formally wanadoo) as my ISP. A majority of websites will not load, some will i.e. www.google.com but the most i.e. www.windows.com will not. This is with either a pc or lapop, I have disabled firewall settings on both pc/lap and router...

Hi, Not sure if this is the right forum, but needs must, when trying to add a "Reporting services Report" Report view type to a KPI / Scorecard I cannot connect to our SharePoint Integrated Server in the Report server box. When I enter our server address (http://OurServer/ReportServer), a...

Hi, Is there any way to apply a filter in the MDX Section while setting up a KPI? The Data Filter option within Mapping does not seem to work so am trying to use a MDX statement, it would be something along the lines of DIM1 = A and DIM2 = B NB DIM1 is Programme - Division - School DIM2 is...

Hi, When trying to install the BSM server, I get the error"Failed Microsoft SharePoint Extended Site" The documentation for ver 2.0 explains how to extend the server / site, but I can't find any for ver 3.0, Anyone got any ideas?

Hi, I have two cubes which are the same structure, one contains historical data (2004-2006) and the other is current (2007) Using some MDX I try to return OB and CB figures: WITH MEMBER [Measures].[FNEEnr] AS 'CoalesceEmpty((Measures.[Enrolled], [INSERT DATE BY YWD].CurrentMember ) ...

Hi, I'm just starting off in the AS path and was hoping someone can help with a speed poser. I have 2 cubes (one normal measures the other a Distinct Count) which both have calculated measures (OpeningPeriod for a time dim) These 2 cubes are then combined into a Virtual cube, on which I have...

Hi, I have constructed a Dril down WI report (BO 6.1) based on the following heir struct: Sch->Loc->PC->GL->EmpID. Column headings Sch | Measure1 | Measure2 | Measure3 etc Now the thing is if I have some details associated with the EmpID i.e. Surname is it possible to have a new column at the...

Hi, In SRSS/access, etc it is possible to colour code a cell depending on its contents (i.e. if it is a negative figure its red, or between 0 and 5 it green, 5+ red, etc) Is it possible to do the same in the BO WebIntelligence report? Many thanks in advance

Hi, I have a WI document calling a wid using the opendocument command. The second doc has two prompts (SChoice and PC_Choice) which I have in the string : &lsSSChoice="+DrillFilters([Sch_Head])+"&IsSPCChoice="+DrillFilters([PC_Head])+"\">Link </a>" The problem is that when the link is clicked...

Hi, We currently are using j2re1.4.1_01 / tomcat to run a web app. There are a number of files in the Programfiles/java/j2re1.4.1_01 folders that need to be there. Trying to get Tomcat to run as a service, I need to install j2sdk1.4.1_01. My question is, If I install this will it change any...

Hi People, When applying a XSLT file to a XML file that calls a SQL procedure via IIS, something (I guess the browser) is inserting a META Tag in the <head> line i.e This <head> <style type=&quot;text/css&quot;> table.grey {background-color: #D3D3D3} table.white...