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

Copying from SQL Server table to Oracle 11g using ssis

I'm copying huge amount of data (4-30M rows) from SQL Server (ole db source) to Oracle database (ado.net destination) using SSIS. It takes more than 4 hours to transfer. Can anyone help me to more quickly transfer from a SQL Server table to Oracle?
Sakthi Ananth
  • 19
  • 1
1
vote
1 answer

Unable to deploy metadata. reason : The syntax of 'Filter_Table' is incorrect

I created the following calculated column. IsRenewal := VAR Filter_Table = SUMMARIZE ( FILTER ( SUMMARIZE ( SUMMARIZE ( FACT_ACCOUNT; FACT_ACCOUNT[ID_LOAN_INFORMATION]; …
FATNASSI Salmen
  • 13
  • 5
1
vote
1 answer

Foreach Loop container in SSIS suggestion

I have for-each loop container in my SSIS master package There is 'Execute Package Task' under this 'Execute SQL Server Agent Job Task' is there.(It has 35 steps) Problem: SSIS master package is starting next iteration…
p.ganesh kumar
  • 13
  • 5
1
vote
0 answers

SSRS Report Data Export to CSV format for more than 1 million records

I am trying to export some SSRS report data to a CSV file format which has more than 1 million records but I am getting the error message below. How can I export the more than 1 million records to an Excel CSV file from an SSRS report?
VMadhav
  • 11
  • 2
1
vote
1 answer

comparing with date values with if condition

I want to compare workers present status with time, if any worker comes 10 mins Late then it should be like "Below 10 mins"(I tried to derive it from time diff column which I done with help of IN time & Report time ) "IF('Attendance Info'[Time Diff]…
hem..
  • 13
  • 1
  • 4
1
vote
2 answers

Running Total in MDX

Hi guys I need help I want this result i have trying different queries with MDX in SSAS but doesn't work. Thank you !
Joe
  • 47
  • 7
1
vote
0 answers

Cube processing is slow when select each ssas objects in SSIS Analysis Services Processing Task

I am processing the cube using SSIS packages which is scheduled in SQL Server agent job. In SSIS package I am selecting just ssas DB name under Analysis Services Processing Task. it takes around 5 hours. In the same SSIS package and Analysis…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
1
vote
1 answer

Stored Procedure Deployment and Backup Using SSIS

I am trying to create an SSIS package for Stored Procedure Deployment and Backup for our project. I have some .sql file, each file contains one stored procedure definition and the name of the file is the stored procedure name itself. I am trying to…
Draga
  • 43
  • 6
1
vote
2 answers

T-SQL If condition inside select

I have a condition where there are multiple scenarios and I need to check each scenario. I need to concatenate the result if two or more cases matches. What I thought was , using CASE statement but i am unable to concatenate multiple scenarios using…
Sql Programmer
  • 213
  • 4
  • 17
1
vote
1 answer

SSIS: Change row delimiter from {LF} to {CR}{LF} massively in flat file connection manager

I am new to SSIS, I have created a data flow with oledb source and flat file destination. Initially the destination file have row delimiter as {LF} but I have to change it as {CR}{LF} now. I have around more than 100 flat file destinations like…
StackUser
  • 5,370
  • 2
  • 24
  • 44
1
vote
1 answer

Alternate of installing Microsoft Office Access Database Engine 2007

I am having a SSIS script task from which I have written some logic to write SQL query results to excel file. I am using the connecting string as Provider=Microsoft.ACE.OLEDB.12.0, but again it is asking to install Microsoft Office Access Database…
user9689875
1
vote
1 answer

Importing Latest Modified Excel FIle With Multiple Sheets

I have multiple excel files with multiple sheets with same structure, i am getting newest file using script task but not able to load all sheets using for each loop. any help would be appreciated.
sonu kumar
  • 13
  • 2
1
vote
1 answer

How can we get the usage of measures and dimensions in SSAS cube?

We are struggling to find the usage of measures and dimensions in SSAS cube. Objective: To have a statistical dashboard to find the unused or most used measures and dimensions. I have got help from…
Vikas Gupta
  • 1,293
  • 1
  • 15
  • 21
1
vote
1 answer

Power BI Custom Dataconnector Authentication

I am looking create a Power BI Custom Dataconnector that will allow authentication by capturing username, password and then calling webapi to authenticate the user. I have tried the example from …
mehwish
  • 199
  • 3
  • 15
1
vote
1 answer

How to change the Database table name in SSIS through XML configuration file

I can able to change the Database name through the connection string which has been defined in SSIS XML configuration file. But how can i able to change the destination table name through XML configuration file (version used is Data tools 2012).…
Ram
  • 527
  • 1
  • 4
  • 7
1 2 3
…
20 21