Hi I want to setup a simple department level data mart. The source data is in an oracle database. The target is also an oracle database. I have the data mart design ready. It is a star schema. I am looking at the various options to A) Move the data from source to target B) Visualization tools to use the data mart A) For data movement I ...
I'm creating some reports in Visual Studio BIDS, out of our SQL Analysis Server 2008. The report works fine, and uses an MDX query with parameters. So far, so good. The problem is that I would like to display the parameter on the report. For example, I would like to display the 'Month' of the Date parameter, but it shows up on the repor...
I have a cube developed using SQL Server Analysis Services (2005). Its hooked up to an excel front end. At the moment users have their own logon to the reporting server and access the reports that way. However, it would be nice of they could access the reports over the web. Are there options for this? I could upgrade to 2008 if there w...
I am exposing data from a SSAS server to which users can connect from any tool they like, (in practise usually Excel 2007). We would like to provide URLs in some cells and would like Excel to recognise these as hyperlinks and make active and format accordingly. When we put a URL into a cell, it is just rendered as plain text. If you t...
In the SQL Server 2005 books online section "Defining Named Queries in a Data Source View (Analysis Services)", it states: A named query can also be used to join multiple database tables from one or more data sources into a single data source view table. Does anyone know where I can find examples or tutorials on how this can be don...
I am fairly new to using SSRS and I would like to create a report that automatically prints to a specified printer when the report is generated. I found this question on SO and it mentions writing code in the Business Intelligence Development Studio that can "fire off" a print job. How might I do that? EDIT: Forgot the URL of the thr...
This may not be a direct programming question but I am in desperate need of this and if you people feel that the question is irrelevant , please do close it but after the answer. Like if we visit www.asp.net we will get the videos(free and down loadable) for asp.net, ajax etc.). Likewise, which is the site from where I can get the free...
Hello, I've visual studio 2005 installed in one machine (dev machine) and SQL Server 2005 installed in another machine. But only when we install SQL Server with SSRS, we get the Business Intelligence Project templates in Visual Studio. Now having SQL Server in another machine how can i create a report server project in VS 2005 in the ...
The answer to this question may be obvious to someone with more experience in data-warehousing and BI, but I am looking for some guidance. I'm building a system that uses multiple JMS queues to process millions of messages per day. I need visibility into the activity of these queues, so that I can create reports like..."Yesterday at 11...
Hello stackoverflow community! I'm trying to find a way to do a search via keywords from my Android app and then get back a list of business (name, address). Including a local business listing is a plus! Any good advice to look for it or key methods to know of? ...
I already have Visual Studio 2008 installed. When installing developer Sql Server 2008, do I need to check the Business Intelligence Development Studio option? I'm guessing not. I assume if I already have VS 2008, the install will just add the relevant Sql Server related project types into VS 2008. EDIT: I marked the question answer...
I'm a software programmer who works on java, php. However, yesterday i got an offer from a company in Business Intelligence. The HR said the job would be in the "implementation" part. Can someone please clarify if this means reporting ? Is a reporting job challenging for a programmer ? I mean, can someone please tell me what all this w...
Ok, So I have to generate very complex reports from my DB. If I am to do it with SQL the query themselves will be complex, and I will have to do some more manipulation on the results later, code level. How do libraries like Jasper Reports/ Crystal Reports and friends save me time when developing such reports? What will they give me? ...
Hi, I know that there are few open sourced / Free BI projects and I am looking recommendations. I have a growing Mysql database that i got tired from writing sql queries + gui + filtering over and over again. if i am not able to find a free one than my budget will be: (1$ - 2500$ ) My needs are: Mysql 5 Connection. user permissions...
I'm looking for recommendations for an easy to use reporting/business intelligence tool that can interface with an sql server or access database. It can be web-based or a desktop tool. Ideally it would be freeware or low cost, and easy to use for users who are not that technically savvy (below the level of someone who can generate repor...
Hi! I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dimension tables and my fact table, primary keys etc. The source is a 'flat' (item level) table and my problem is now how to split it up and get it from one into the respective tables. I did a fair bit of googling but couldn't find a satisfying solution to...
I'm currently researching SQL Server 2008 as a business intelligence solution, and currently looking at Analysis Services (and I'm pretty new to business intelligence as a whole...) I'm a bit confused by some of the terms in SSAS, particularly the conceptual differences between cubes and MS's Unified Dimensional Model. I believe tha...
I’m looking for some feedback on mechanisms to batch data from MySQL Community Server 5.1.32 with an external host down to an internal SQL Server 05 Enterprise machine over VPN. The external box accumulates data throughout business hours (about 100Mb per day), which then needs to be transferred internationally across a WAN connection (qu...
I am currently working with an SSRS 2008 report that returns a dataset similar to the following: Job# ClientId MoneyIn MoneyOut ------------------------------ 1 ABC123 10 25 1 ABC123 10 25 1 ABC123 5 25 2 XYZ123 25 50 2 XYZ123 25 50 3 XYZ123 15 15 Where MoneyOut shoul...
We're about to make data transformation from one system to another using SSIS. We are four people people who will continuously be working on this for two years and therefore we need some sort of versioning system. We can not use team foundation. We're currently configuring a SVN server, but digging into it I've seen some big risks. It s...