In Business Intelligence Developer Studio, I'm wondering why one would want to create a report model from an OLAP cube. As far as I understand it, OLAP cubes and report models are both business-oriented views of underlying structures (usually relational databases) that may not mean much to a business user. The cube is a multidimensio...
I’m writing to solicit ideas for a solution to an upcoming problem. The product that provides data to our ETL process currently has multiple versions. Our clients are all using some version of the product, but not all use the same version and they will not all be upgraded at the same time. As new versions of the product are rolled o...
I would like to add a data table to bottom of a (line) chart in a report. I know I can create a matrix report with the same data source. I would like to have everything lineup automatically like it does when you add a data table to a chart in Excel (as shown at http://www.tushar-mehta.com/excel/newsgroups/data_table/). Example from E...
Can anyone recommend a decent business intelligence & reporting application that can be integrated into an OEM application? Primary requirements are: Administrators can define cubes/dimensions etc (or we - the OEM - can predefine some) Report designers can easily inspect data by visually selecting dimensions, filters etc in an adhoc w...
I have an RDL report file and I would like to somehow "run" the report and get the dataset that would be used to fill the report. What I'm trying to do is get a raw data extract from the data that would be used to fill the report, without actually showing the report to the user. Is this possible? ...
What are the main differences between the Pentaho BI Suite and JasperSoft BI Suite (as they are currently packaged in 2010)? ...
I created a report that pulled 1 object from the Purchase_order table (PO_REF) and one from the ORG_ZONES table (ZONE_NAME). Why would BO generate a query that joined to a 3rd table, ORGANIZATION for no reason? Note that the ORGANIZATIONS table is related to both the PURCHASE_ORDER and ORG_ZONES table, so in a sense, if you were to loo...
We are looking at acquiring Data Mining software to primarily run predictive analysis processes. How does SQL Server Data Mining solution compares to other solutions like SPSS from IBM? Since SQL Server DM is included in SQL Server Enterprise license - what would be the justification to spend extra couple 100K to buy separate software ...
which open source business intelligence solution would you recommend? All I need is to build some cubes and let the end user play with dimensions, filter data, sort, etc, and once it's done being able to export it to excel... I'd like the solution to be as simple and easy on resources as possible, and also I'd like it to be as much ope...
a bit confuse round here, does SSAS stored ETL result? or is it SSAS connect directly to the production databases? ...
In most cases, each level of a hierarchy within a dimension represents different concepts (i.e. country->region->city, year->month->day) and this is simple enough to use in a cube. What I'm interested in are variable depth hierarchies which tend to consist of instances of the same concept, i.e. nodes in a computer network where the "dep...
Our company is working with a great Business Intelligence tool CorVu 4.2 to analyse the operational and strategic data. Since several years we are successfully working with Sharepoint 2007 to collaborate and share information with colleagues. Most of my colleagues are working with Internet Explorer 7, but step by step Internet Explorer 8...
I'm looking for a reporting engine/UI that can be integrated into a product, which has a UI along the lines of Google Analytics' Custom Reports builder. Is anyone aware of such a thing? The data is in our case is not page views/visitors/etc, but is similar in nature, in that there are limited entities or types of data, but each entity h...
I need historic and daily currency exchange rates database to work with BI solution based on Microsoft SQL Server. Thanks for the help. ...
I want to construct the scorecard having multiple KPI's in it in a similar fashion of beolwo image I will be having my KPI details in Dimesion(KPI Name). So I want the same look in Excel..All KPI names are left side and value, Goal, Status and trend in the top ...
How can I install business intelligence project in vs 2008. I can not option in new project. ...
We're looking to hire a business intelligence developer - knowledgeable in SSAS, SSRS, data warehousing, etc. My job in the interview process will be specifically to vet the candidate on SQL Reporting Services. Assuming a 60 minute interview, what sort of questions or challenges might be effective in determining a developer's level of k...
We are currently implementing the commercial Infor PM (Performance Management) package as a business intelligence tool. Infor PM website It is apparently used by over 1,000 companies around the world, but I have found scant information about it on the net except for what's on their own website. It covers the whole range of data wareho...
I'm looking for ideas / open source frameworks to use for creating individual Analytics for user profiles and all the other profile types. Users will have different custom metrics, businesses willl have seperate metrics, the admin section will have seperate, Advertises will have seperate, etc. So basically the goal is to have 1 framework...
Hello, I've lost my Reporting Services project file for Business Intelligence Development Studio. How can I open the existing reports in a new project? Can I "open" the whole project like in SSAS? I want to get the datasets and data sources into the project again as well. ...