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
1 answer

Convert Universe/report BO to Cube/report MS BI or the contrary

My first question is to know if you can help to know if it's possible to convert Universe BO to Cube SSAS or The contrary? My second question is: is it possible to convert a webi report to SSRS report or the contrary? If you have some…
user3887824
  • 13
  • 2
1
vote
1 answer

Power Query 'an evaluation is in progress' when merging

When merging two tables in PowerQuery an evaulation is run to determine the possible number of matches. I run pretty large tables (merge a 10K record table with a 500K record table) so this can take a long time. I know there will be matches because…
Jay Killeen
  • 2,832
  • 6
  • 39
  • 66
1
vote
1 answer

how to re-start from package from where it stopped on user selection

We have a Master SSIS package and it calls few other child packages and some tasks,We have UI portal build for it to start the master package and to check the status of the package.Whenever package fails(i.e.because of network issues or other errors…
Ram Das
  • 348
  • 4
  • 15
1
vote
6 answers

Script component Fail: System.IndexOutOfRangeException: Index was outside the bounds of the array

In SSIS package “script component” is failing due to the following exception. This exception is occurring sometimes only. This script component contain Try/Catch, still it’s failing. What could be the reasons for this exception? Error…
Dav1
  • 11
  • 1
  • 2
1
vote
1 answer

Show less data on the Report but while Exporting the data in excel , export more data

I need to show only 5 rows of data on the SSRS reports , but when the user exports the data he must be able to export all the data that dataset is holding. Is there anyway to achieve this ?
Bala
  • 1,077
  • 5
  • 15
  • 35
1
vote
2 answers

how to consider delimiter(,) as a text in SSIS?

i got the requirement from one of my client. the requirement is source is a delimiter flat file and delimiter is comma(,). source data contain the comma within the data.now i want to consider that delimiter also text. here is the example source…
PPRas'd
  • 81
  • 2
  • 9
1
vote
1 answer

Complex Case Statement in SSIS Expression

Trying to re-write Case statement in SQL to SSIS Expression. Case When ADate is Null and BDate > DateAdd(DD,120,CDate) then 'ABC' When ADate is not Null and BDate > ADate then 'CVA' Else '' End Is this even possible to re-write as SSIS…
user1810575
  • 823
  • 3
  • 24
  • 45
1
vote
2 answers

Dynamic Excel WorkSheets based on data tables using SSIS

Trying to create dynamic Excel WorkSheets based on data tables using SSIS. Each Excel worksheet would represent a State and State work sheet would have different rows and columns. For instance: AL - Alabama WorkSheet A/C No Col1 Col2 Col3 .....…
user1810575
  • 823
  • 3
  • 24
  • 45
1
vote
1 answer

SSIS Text file destination with a custom defined formatting

I am trying to create a file with custom formatting for the destination text file. I am not sure if this can be done without creating any custom transformation. Example: I have a following table: Date CompanyName CompanyAddress Phone …
CuriousKid
  • 605
  • 5
  • 24
1
vote
1 answer

Can an SSAS Cube be used as a data source for a data warehouse/BI database?

I have a requirement to pull data from an existing 3rd-party SSAS cube into my current BI system. Is there a best practice for how to do this? Can a cube be used as a source for another BI database? How do I import this data? I'm open to…
Priyank Gupta
  • 942
  • 1
  • 7
  • 26
1
vote
1 answer

how to load Text file Thorn(þ) delimited into sql-server 2012

I have text file something like this col1þcol2þcol3þcol4 aaaþbbbþcccþddd xxxþyyyþzzzþabs 123þtyehþyetþethrr i tried loading into sql-server using ssis package after following steps from here but i couldn't find solution,could somebody guide me in…
vhadalgi
  • 7,027
  • 6
  • 38
  • 67
1
vote
1 answer

What is difference between Event based and Time based Job scheduling in SSIS

What is difference between Event based and Time based Job scheduling in SSIS? I'm quite new to MSBI and SSIS,I did some search on this and found that usage of these depends of the requirements of the user now could somebody please guide me to…
vhadalgi
  • 7,027
  • 6
  • 38
  • 67
0
votes
0 answers

SSIS - Retrieve variable value from controle flow (no using script task) to data flow

I'm facing an issue with a case where I need to retrieve variable value from controle fow to data flow. The value of the variable in controle flow = 3 but in data flow = 0 as if the value was not passed. Any idea please ? FYI, scope of the variable…
Joe
  • 47
  • 7
0
votes
0 answers

Why SSRS PDF link is not clicking

I am working with the SQL Server Business Intelligence Development Studio 2008. I want to integrate PDF link in a SSRS report. The PDF complete link is stored in database. When I open that link on file explorer and browser. The PDF file is opening,…
Abdul Sami
  • 1
  • 1
0
votes
0 answers

Issue with ssrs parameter

I have 5 bookmarks in my report,let us assume i have clicked run, then gone 5th page or 5th bookmark ,from there if i filter any values in parameter, the report refreshing and going to first bookmark, how to make stay it in only same bookmark
Ramya
  • 41
  • 3
1 2 3
…
20 21