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
vote
5 answers

How I can fetch last two full years and current year records in SQL Server

I have following expression in my where clause: DA.Access_Date >= DATEADD(YEAR, -2, GETDATE()) But it returns data till '2015-02-17' i.e. current year minus two. I want data of two full years and current year e.g. 2015-01-01 to till date. Any…
Ankur Jain
  • 9
  • 3
1
vote
1 answer

SSIS deployment and execution

Have been reading and following tutorials on Microsoft Business Intelligence. And i would like to clarify some things. So, as i have read and practiced, there is no technically build process like that of 'maven' or 'msbuild' kind of in MSBI. i am…
OK999
  • 1,353
  • 2
  • 19
  • 39
1
vote
0 answers

Microsoft SSAS Cube to Teradata - data migration

Per the project requirement, I want to migrate all the data from the Microsoft SSAS cubes to Teradata database. So I am not very sure about the best approach to do this activity. First thing comes into my mind is to get extract of the data in excel…
Aditya
  • 2,299
  • 5
  • 32
  • 54
1
vote
1 answer

SSIS 2014 - Flat File Destination with Different Number of Columns

I've got an SSIS package (SQL 2014) that loads data from a table into a flat file. The file has 5 columns, however there is one row in my dataset that is used by the system for duplicate checking, and its required to have 3 columns, instead of…
Pops
  • 468
  • 2
  • 15
1
vote
1 answer

I need to fetch master record and potential match from the column match result in my table which having same groupid

I have one table in which there are many records, now I need to fetch master record and potential match records from my column match result which having same groupid on the basis of it's top parented.
Manish Prajapat
  • 5
  • 1
1
vote
1 answer

SSIS SMTP Connection Reestablish Connection after every Foreach Loop

I have a foreach loop in SSIS that sends an email for every record that it loops through. I'm getting a SMTP connection timeout error after the job runs for 10 minutes, which is the timeout setting on the exchange server. Is there any way for the…
Pops
  • 468
  • 2
  • 15
1
vote
2 answers

Msg 232, Level 16, State 3, Line 5 Arithmetic overflow error for type int

how can i find the difference between two variables? error is Msg 232, Level 16, State 3, Line 5 Arithmetic overflow error for type int, value = -39827814763.955299. Msg 232, Level 16, State 3, Line 12 Arithmetic overflow error for type int, value…
deepanshu nagpal
  • 47
  • 3
  • 9
1
vote
1 answer

how to make each record of equal length in text file using SSIS?

I have a text file in which each record length is varying. I don't care how many columns are there and column delimiter. I just want to make them equal in length using SSIS likely a fixed width file with single column. I want to add space for those…
Ankit
  • 13
  • 1
  • 7
1
vote
1 answer

Does parallel execution in SSIS work correctly?

Can anyone say, " Are there any priorities within ddl and dml commands? " Because, I came across a scenario where I have a ssis package where in which I have one dataflow task in control flow, whose work is to transfer data from flatfile…
Naresh
  • 47
  • 2
  • 10
1
vote
1 answer

SSRS Report Error Multiple parameter selection -Incorrect Syntax near ','

My below code works fine in SSMS but it is giving me an error while executing using SSRS Incorrect Syntax near ',' Dataset.I am trying to select Multiple Parameters through SSRS. Can anyone please guide? Below is my code Declare @Startdate…
Rajashri
  • 59
  • 1
  • 5
1
vote
1 answer

Conversion Failed String to Integer in SQL

I have stored the OrganisationIds 1 ,2 in @String variables.i want to convert it into Integer.Can anyone please help? Below is my code.. DECLARE @RowCount INT Declare @String varchar(100) declare @OrganizationIds int SELECT @RowCount = COUNT(*) FROM…
Rajashri
  • 59
  • 1
  • 5
1
vote
0 answers

An error has occurred during report processing. (rsProcessingAborted) Query execution failed

I have created the SSRS report and it's working fine in preview mode..When i am trying to deploy it's giving me an error. Can anybody please help me to resolve this issue? i am using the stored procedure. An error has occurred during report…
Rajashri
  • 59
  • 1
  • 5
1
vote
4 answers

Calculating Avg Orders per day using MDX

I am trying to create a calculated member which should returns the averages orders per week per person. Below is the screen shot where the client will be looking to forecast the work load. Staff may not work all the days in a week. The…
Murty
  • 79
  • 2
  • 9
1
vote
1 answer

Getting year-end values from prior year on each result row of MDX query

I have a snapshot fact table with a time grain of monthly and so the measure values are only point in time, not cumulative over time. I need to derive a Previous Year-End value to compare any given month's values to the end of the previous year…
Iwantallthedata
  • 43
  • 3
1
vote
2 answers

Last sunday of previous week in SSIS

I want a SSIS expression which will give me the sunday date of last week. Corresponding sql server query looks like : select convert(date,DATEADD(wk, DATEDIFF(wk, 6, convert(date,@report_dt)), -1)) I want the same result in SSIS expression. Thanks
diptarana mitra
  • 100
  • 4
  • 9
1 2 3
…
20 21