Hi I can create a normal SSRS Project and use a ODBC connection. But i cant create one with i want to create a Report Model Project??? Any idea why and how i can work around it? Thanks in advanced!! ...
Backgroup: We are looking at SAS BI Dashboard. We have currently implemented almost all of SAS's other applications (with the exception of Enterprise Miner). Other technologies online include Business Objects, some custom reporting stuff, and Project R. The Question: What feedback do you have with: implementing SAS BI Dashboard buil...
I have to study about data mining using SQL Server. As I know, Business Intelligence in SQL Server supports data mining, but I'm not pretty sure. Does BI really support data mining? How can I start with data mining with SQL Server? I mean, resources such as books, blogs,..etc Thank you all. ...
When I asked our DB designers why our Fact table do not have a PK, I was told that there is no set of columns in the table that would uniquely identify a record, even if all the columns were selected. Whenb I suggested that we an an identity column in that case I was told that "I'd just be wasting space and that it wasn't needed." My fe...
Being a programmer who likes all things terminal (like Vim and the GNU tools), I've finally met my match. The company I work for has decided to move from an in-house developed report generator to the Cognos suite. We have had some informal meetings/workshops regarding the process of creating reports in Cognos, but I can't really make it...
Is there any way to execute a scalar-valued function from within a Derived Column transformation in SSIS? -Scenario- I have a function in my source DB that converts weights based on a UOM value in the record's UOM column. I want to utilize this function in the ETL process to ensure that my weight measures are always pounds. Can I call ...
What resources (books, videos, tutorials, etc) would you recommend to learn about business intelligence? ...
Hi. Is there a high quality sample code for Data Flow Components in SSIS? I specifically need the following: OLE DB Source Derive Column Transformation Flat File Destination. Lets say that the table schema comprises of two columns, ID of varchar(2) and Description of varchar(20). The output is a flat file ID of 1 char (just get th...
We have a system that generates many events as the result of a phone call/web request/sms/email etc, each of these events need to be able to be stored and be available for reporting (for MI/BI etc) on, each of these events have many variables and does not fit any one specific scheme. The structure of the event document is a key-value...
I was trying to compare with the cube's data with that of data mart using TSQL query. It s hard for me to find where the columns used in the cube are coming from. Because the columns used in the cube are coming from data source view, but how do I know which table? Help appreciated ...
Hi, I am using Informatica 8.1.1. Source flat file contains one date/time field. I want to load it as two separate columns date and time in target table. I tried TO_DATE function to get the date and time separately. But it is giving some errors. How can I split this date/time into date and time? or Can we load a string value from so...
How do you programmatically add an SSIS ForEachLoop? We are limited to SQL Server 2005. I'm having trouble adding the following properties: ForEachEnumerator CollectionEnumerator Directory FileNameRetrieval FileSpec Recurse My code format looks like this: Microsoft.SqlServer.Dts.Runtime.Executable executable = aSequence[0].Executable...
I've noticed an increasing number of jobs that are asking for experience with datamining and business intelligence technologies. This sounds like an incredibly broad topic but where would one go if they wanted to develop at least a partial understanding of this stuff if it were to come up in an interview? ...
I have implemented delta detection while loading data warehouse from transaction systems using an identity column or date-time column in source transaction tables. When data needs to be extracted next time, the maximum date-time value extracted last time is used in the filter of extraction query to identify new or changed records. This w...
I want to finish my final project, my project is about market basket analysis with apriori algorthm. I use C# and SQL server 2005. Can you help me please. I have a saving mart datasets. I am newbie and I don't know step-step how to use market basket analysis on sql server 2005. Please help me. ...
I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anyb...
Technology has brought the small and medium enterprises (SMEs) a faster way to do things and not necessarily a better way. Many messaging platforms have been created. Many programs and systems have been build. A lot of information is now available at an instant. Perhaps the three most important contributions are the email and instant...
I am looking to integrate some dynamically generated BI reports into a web app. The requirements are: Able to view report based on JSON RPC XML, or some similar streaming data source (therefore, not requiring direct access to the DB). Why? Because many users have access to different copies of similar data. I.e. 3 companies, 5 projects....
We are developeing a BI portal and in that most of the data are from SQL Analysis Service OLAP DB. Please let me know which is the method for using the same in web application like ADOMD.NET, OPENROWSET inside existing SP,... Thanks in advance Bipin ...