Every project invariably needs some type of reporting functionality. From a foreach loop in your language of choice to a full blow BI platform. To get the job done what tools, widgets, platforms has the group used with success, frustration and failure? ...
I have the need to copy the entire contents of a directory on a FTP location onto a shared networked location. FTP Task has you specify the exact file name (not a directory) and File System Task does not allow accessing a FTP location. EDIT: I ended up writing a script task. ...
I'm looking at Pentaho BI Platform to extract information from Mantis, but I don't find any tutorial to setup a full working environment (without preloaded data). Do you know any tutorial? Maybe another way to develop reports from Mantis data? Thanks! ...
I have IIS6 configured such that browsing to http://localhost:8082/Reports gets me the reporting services default home page, which is all as expected. However, when I try to publish a report via Microsoft Business Intelligence Visual Studio 2005 I get the following error: A connection could not be made to the report server http://localh...
What books or online resource would you recommend for learning how to do advanced charts and dashboard design with Reporting Services? ...
What advice would you have for someone who wants to start in the BI (Business Intelligence) domain? I where and what I should start with: Books, Blogs, WebCasts... What I should pay attention to and what I should stay away from. Are the Microsoft technologies worth while ? ...
Hi, I have a multi select list box value prompt in Cognos 8.3. It contains values: Adelaide North Adelaide South Adelaide East Adelaide East Sydney North Sydney South Sydney East Sydney West etc. I want to able to add a button onto my prompt page that when clicked, selects predetermined options, such as Adelaide North, South Ea...
Let me first say that being able to take 17 million records from a flat file, pushing to a DB on a remote box and having it take 7 minutes is amazing. SSIS truly is fantastic. But now that I have that data up there, how do I remove duplicates? Better yet, I want to take the flat file, remove the duplicates from the flat file and put the...
Hello people! My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've installed a version, and I got it up and running quite painlessly. So that's good....
We are migrating our test report data (unit, regression, integration, etc..) from an XML format to a database format for better analysis. Right now the majority of our test analysis is done using the CruiseControl.NET dashboard, but this is limited to primarily the most recent test data. Older test data can be accessed but not easily com...
I am told that SQL Server 2005 installation with BI tools and SQL Server 2008 with BI tools can't work together on the same computer. Apparently "some" things stop working. This was told to me by one of my team members. Since I'm new to SQL BI, I cant discount what he has said altogether and I dont want to install them both on my dev box...
Is anyone using the business intelligence tool Inetsoft Style Report ? I'm stuck with it and was wondering if anyone has advice on tuning and/or best practices for server admin? We are running on a fast Solaris box using Tomcat with a db2 database. ...
We are in the process of selecting BI stack for our data warehouse. The top contenders are OBIEE = Oracle BI Enterprise Edition (formerly Siebel Analytics) and Microstrategy. Has anyone worked with OBIEE? Lessons learned? General impressions? Flaws, strengths? ...
I am starting to work with Microsoft BI suite: Analysis services 2005, Business Intelligence Development Studio 2005, stuff like that. Of course my first wish was to set up the same source control/automated testing environment I have for my .NET projects. But xml files used by Analysiss services (dwproj, cube, dim, ds, dsv) and Integ...
Hi, I am using Business Intelligent reporting servicess to reporting some data from My MS SQL Database. In ASP.NET I create new Reporting Viewer that take data from BI and display the report then I can Print it. My Question is How can I print the report without report viewer? thanks in advance :) ...
Is "business intelligence" a buzzword that has no real meaning to software developers, or does the term carry some implied meaning in terms of what the software does or how the software does it (in a general sense)? It appears to be a real business term, but does it mean anything in particular to software that performs business intellige...
I have an existing application written in perl. Now i need to integrate this application with ocbi. The plan is having button that user can click on to open ocbi in iframe. The ocbi resides on a different server from the running application. Has anyone done this before, know what is the best practice of doing this, and what is the effort...
I recently got a Business Intelligence programmer job offer, and I'm wondering what kind of job would that be and what are the potential career paths that it could lead to*. I had an interview where I asked that very question, and the interviewer went on talking about this exciting field combining design, development, database, and busi...
We'd like to see if we can get some improved performance for analysis and reporting by moving some of our key data into Analysis Services cubes. However, I haven't been able to find much in the way of good client front ends. Our users have Office 2003. The move to 2007 is probably at least a year out and the Analysis Services add-in fo...
I was talking with a co-worker yesterday regarding a situation where he used SSIS (or something like that) to do some really cool thing with an SSIS Package where he passed in a name like "Dr. Reginald Williams, PhD." and based on some weighting scheme the system was smart enough to figure out how to tokenize it and store it in the datab...