Stack Overflow
Stack Overflow

Questions tagged [msbi]

MSBI (Microsoft Business Intelligence) is a suite of tools providing solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server.

MSBI stands for Microsoft Business Intelligence. This suite is composed of tools which helps in providing best solutions for Business Intelligence Queries. These tools use Visual studio along with SQL server. It empower users to gain access to accurate, up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

MSBI is divided into 3 categories:-

SSIS – SQL Server Integration Services. SSAS – SQL Server Analytical Services. SSRS – SQL Server Reporting Services.

Source: http://www.phpring.com/what-is-msbi-microsoft-business-intelligence/

309 questions
-1
votes
1 answer

what are the steps to work on real time project with home care agency data..like implementing Databases and BI Solution and then Reporting?

I am a graduate having some practical experience(beginner level) on MS-BI/Data Modelling.want to work on a project to gain experience and able to apply for full-time jobs.I have real data of my brother's Home Care agency to work on....All the data…
user873096
  • 1
  • 1
-1
votes
1 answer

How to select the records from one table which is not matching with the other two tables

I have one master table emp1 table with 3 columns and 3 rows as you can see below empid empname empsal 1 a 100 2 b 300 3 c 500 second table emp2 with 3 columns and 1 row empid empname empsal 1 a 100 suppose,…
Rafael Nadal
  • 3
  • 2
-1
votes
1 answer

How to upload ssrs rdl files to SQL Server 2014?

We have installed SQL Server 2014 on a web server. And we have connected to the SSRS Reporting Services, but we don't see any options (like import report) to upload into the reporting services. Can anyone plase guide on this one how to get/upload…
user2681423
  • 21
  • 6
-1
votes
1 answer

How to call dataflow task from script task in ssis

I have two kind of files (EXCEL and TXT ) if file extension is EXCEL i have to call data flow task for EXCEL and if it is TXT i have to call data flow task for TXT How would i call dataflow task from ssis Script task
Sachin Jawalkar
  • 13
  • 5
-1
votes
1 answer

How to insert the records in child table when records are inserted into parents table in SSIS?

I am stuck with a scenario in SSIS. I have two table both maintain the referential integrity means one is parent table and another is child. When I insert the some records in parent table then those new records should be insert into child…
Ankit
  • 13
  • 1
  • 7
-1
votes
2 answers

how can I easily shift my SSIS package from SQL Server to Oracle?

I have developed 25 SSIS packages with SQL Server backend. Now my requirements have changed so that the SSIS package stays the same but the database which I use should shift from SQL server to Oracle Database, How I can change the DB in my SSIS…
Naresh
  • 47
  • 2
  • 10
-1
votes
2 answers

What actually happen background when an SSIS package is being created?

Can any one explain what actually happens in the background of SQL SERVER while a SSIS Package is being created. what does SQL SERVER actually do to create a package? Help would be appreciated.
Naresh
  • 47
  • 2
  • 10
-1
votes
1 answer

MDX: I need column count based on the total rows

Here we have total 14 rows, I need one more column (RowCount-Column name) every-cell contains 14 (reputation) means total row counts. below is the query WITH MEMBER DimName AS [DimClinic].[Provider Key].CurrentMember.Member_Caption MEMBER…
Yugandhar
  • 97
  • 9
-1
votes
1 answer

Import data from one table and loop through another and extract the result using Script task

I have been asked to do a task which is import data from one table and loop through that data with another table and fetch the matching result using SSIS Script task or script component. I am very poor in script writing could anyone help me with…
Ravin2015
  • 1
  • 4
-1
votes
1 answer

Oracle BI admin tool (.rpd file ) to MSBI

I want to convert .RPD file generated from Oracle BI admin tool to MSBI.
ash123
  • 1
  • 3
-1
votes
2 answers

Converting INT to Unsigned INT

I have a large table in prod with INT datatype and it is both primary key and identity column(1,1).The number of rows is 2147479257. During the daily job run the ETL failed because of arithmetic overflow error,as it cant fit any more rows in to the…
Deepak
  • 103
  • 2
  • 3
  • 11
-1
votes
1 answer

SSAS KPI in a perspective

I have a user group that wants a KPI off a measure include in their reports. There are other user groups who do not wish to have this measure included. I was thinking of creating perspectives that filters that measure from their views. When I try…
jluk87
  • 1
-1
votes
1 answer

Joining more than 1 column using Merge join transformation in SSIS

I have came across scenarios where we have 1 column join in Merge join transformation , but i am not able to find out a option where i would specify 2 columns to join in MergeJoin transformation. Is there a property or some other way i would achieve…
Sachin Kamble
  • 129
  • 2
  • 3
  • 10
-1
votes
1 answer

Some questions about MSBI

I have some questions to ask you: I have my DW and I want at the end to have reports where there are data calculated thus I have to make my cube (table of make and dimensions(size)) except that these calculate there how and where I may make…
Abder KRIMA
  • 3,418
  • 5
  • 31
  • 54
-1
votes
1 answer

SSIS Package to find out difference between SQL server Objects

How to create an SSIS package to compare SQL server Database Objects in different servers and generate the difference in an Excel Sheet. Is it possible to do that?
sarthak dash
  • 21
  • 3
1 2 3
…
20
21