Tried to open an SSIS project I had been working on today and received this lovely error: Unable to generate temporary class (result=1) error CS0009: Metadata file 'c:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0_b77a5c561934e089\System.XML.dll' could not be opened -- 'No metadata was found.' Anyone know why this happens and how to cor...
Hi All, Trying to edit an SSIS package, when I go to the advanced editor on the update database package I can only see on the component properties page three properties. ID, Name and Description. when my colleague opens this up he can see 20+ options including the SQL option I am needing to be able to edit. Is this an issue with my SQ...
Hi, I need to allow my end users to view SQL Server Analysis Services data mining model (to be exact Association finding). I'm looking for a tool which can do the job. For the cubes I'm using Excel OWC, and I'm quite satisfied. So far I had found only DM Companion . But I'm struggling to find anything else. Can you recommend somethi...
So if I had a dashboard of political parties in North Korea, is it really a dashboard? To me a dashboard should be regularly updated, having the possibility that a number or indicator could change at a regular interval... and for now I'll say regular is less than once per day. Also in today's usage, a dashboard seems to mean more and m...
What do these mysterious "Business Intelligence" software do anyway ? ...
Can We create such kind of reports using Crystal Reports XI Cross-Tab? Product Sales Comparison +---------------------------------------------------------------------------------+ | | Jan | Feb | Mar | April | May | TOTAL | | |---------------------------------------------------...
“We make solutions that help you achieve 200% productivity, and reduce your HR costs by 37%!”. This is not the first time you’ve read a line like this. And you can tell that its a standard IT firm pitch, because it doesn’t say: “But implementing such a solution is gonna cost you three times what your HR did, and it will take at least 6...
For a new project I'm working I have the need to store some data into a database. The type of data and access model fits well with the NoSQL model and document databases. We are considering things like MongoDB but are still yet undecided. One of the requirements is to be able to allows Business Intelligence tools to consume some of our ...
I have a fact table containing 8 Million rows with 1 Million rows increase per month. The table already contains indexes on it. The table is used by IBM Cognos environment to generate reports. Currently I am looking for way to optimize the table SELECT statements. As first try, I partitioned the table (each partition has equal distribu...
I have a LAMP host, not tomcat therefore no java, I need a Business Intelligence Tool which can be run on mysql/php Must be able to download large reports ...
I'm looking for a templating tool that allows powerful manipulation of data and report building. JasperReports is powerful, but is it the best out there? I generally don't need the ability for fancy colors or gradients, but I do need the ability to position data accurately and produce reliable, quick results. Ideally, generating a report...
I am BI Manager on top of a SAP installation. I have a SAP DB which the SAP application writes data to. In order to get an environment to query without loading on the sap, I have mirrored the SAP DB on a server, and it works fine. Each night I do a full load of data, and it works fine for now. I know that somewhere down the line, I will...
Hello all. I am looking for a reporting tool for my end users to build their own reports using their data which is stored in a MySQL DB. I have researched this on stackoverflow and most of the solutions seem to be desktop apps or web-based services which allow you to upload data which is not an options. I would prefer this software ...
What is the simplest MDX request? I want to test whether my MDX endpoint answers correctly to a very simple request. In SQL, I would say SELECT 1; ...
I keep getting the error message Error: 0xC020901E at Data Flow Task, Lookup ProjectId [580]: Row yielded no match during lookup. Error: 0xC0047072 at Data Flow Task, DTS.Pipeline: No object exists with the ID 880. It does not reoccur in the same spot rather in different places each run. Even when everything is exactly th...
I have one data warehouse table that contain one row for each item sold. Each row contains the item's type. What MDX request could show the number of items sold for each item type? What (dimensions,levels,etc) would it suppose to create? In case it is relevant, I am using Pentaho/Mondrian/Spoon/Schema Workbench. ...
My problem is that I am receiving a "Configuration system failed to initialize." error every time I try to open or create a Business Intelligence Project in Business Intelligence Development Studio. I am on a fairly new install of Windows Server 2008 R2 Enterprise in which I first installed SQL Server 2008 R2 Enterprise (with the Busine...
I am trying to figure out if there's a way to create a semantic layer, similar to what you can do with Catalogs in Cognos and Universe in SAP-Business Objects, in QlikView. I am fairly certain that it is not something that you can do out of the box but I am wondering if there isn't a creative way to achieve the same through a combinati...
I am developing a custom assembly in SSAS. I wanted to make the connection string configurable or i wanted to read the connection string from cubes data source ...
In Oracle BI Publisher, I can't seem to find in what format the date parameters are passed in to the query. For example select * from myTable where the_date = :the_date Any ideas? ...