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
0
votes
2 answers

SSAS: How to use .net DLL and stored procedures in ssas using Assemblies

How to call the .Net DLL and stored procedures in ssas assemblies and how to get the result using that stored procedure or Dll's 1) i created simple stored procedure name like division it returns division value of two numbers 2) After that i…
Hari
  • 23
  • 1
  • 5
0
votes
1 answer

How to log each container and task details into a table in SSIS

I have a package which contains several containers and each container have multiple tasks in it like below. during package execution, i need to log each container and task details into a table like below. LogID Container Task …
Ram Das
  • 348
  • 4
  • 15
0
votes
1 answer

Can I load calculated measures from SSAS cube in Power Query?

Power Query Version 2.17 is supporting SSAS Cubes as data source now. When I connect to a cube I just see the standard measures of the cube and not the calculated members defined in the cube. Is there a way in Power Query to get access to the…
Andi
  • 487
  • 3
  • 6
  • 22
0
votes
1 answer

SSAS -How to select a particular attribute when we drag dimension into query editor

I have about 4 attributes in Race dimension as shown in blow dimension name is Race 1)Race 2)RACE DESC 3)RACE KEY 4)RACE SHORT NAME when go to cube browse and right click on Race dimension and select add query as below 1)when i drag Race…
Hari
  • 23
  • 1
  • 5
0
votes
0 answers

out of memory at line 5 in SSRS report on server

I have developed a SSRS report in which I have user three different select queries to create three different report and not a single parameter is used in any of these queries, only select statement like select col1,col2,col3 from table_name; There…
Abhishek Singh
  • 1
0
votes
2 answers

Parameters for RDL Report generated from Cub

I am working with SQL Server 2008 and i generated my cub and i want to make a rdl report with parameters but when i preview the report i found that the structures of values are strange For example instead of seizing in a field of paramettre the…
Abder KRIMA
  • 3,418
  • 5
  • 31
  • 54
0
votes
1 answer

My ssis package is running very slowly

My ssis package is running very slowly. The package is like this, using FTP task we will collect files from server and then loads that data into sql server table. It is scheduled to run every night as a job. When I run it in IDE it is very fast. And…
manne anvesh
  • 1
0
votes
0 answers

How to store excel data from a sharepoint path to sql server using ssis package

I am creating a SSIS Package for importing excel file(with Several tables in the form of named ranges) from sharepoint to sql server(database) tables. I tried importing file to a local folder using script task and then storing it as a excel source…
user1925343
  • 11
  • 2
0
votes
1 answer

SSIS 2 Conditional Split not working as Expected

I am new to SSIS and was going through a usecase where I want to implement SCD type 2 without using SCD component (that is the requirement) where I have to use more than one conditional split and a Lookup. now when i use a single lookup and single…
Ameya Deshpande
  • 3,580
  • 4
  • 30
  • 46
0
votes
2 answers

SSAS Tabular Model on Azure VM

I have an Azure VM with SSAS Tabular Model. I understand that using Virtual Network it can be accessed from On-Premise. But is it possible to access it using DAX queries without creating Virtual Network?
Srinivas
  • 2,479
  • 8
  • 47
  • 69
0
votes
2 answers

Running a DFT Based on a condition in SSIS

I've a package where I need to retrieve data from a mysql table and insert it into sql server table. I've a situation where in old data often gets modified and the client wants to dump all data which is too large and time consuming...So I've come up…
VJAI
  • 111
  • 1
  • 14
0
votes
1 answer

SSIS Package Sequence Container to Fail after Executing an SQL Task

I have an SSIS Package Which Updates a Table in a machine and then needs to copy the data to a different machine(server). The Package Often Fails Due to Time out failure,So we've come up with an option of first loading it to a temp table and then…
VJAI
  • 111
  • 1
  • 14
0
votes
0 answers

How to Create a report in SSRS using Flat file source?

I got the requirement from one of my client to create ssrs reports using Flat file source in SSDT 2012. For my understanding to create SSRS report using flat file there is no direct method.We need to change the flat file source to other source(EX:…
PPRas'd
  • 81
  • 2
  • 9
0
votes
1 answer

Time dimension in SSAS

I am trying to understand Time dimension is SSAS. In SSAS we have an option to create Time dimension. I have two questions related to it What difference it makes if i generate, Regular calendar, Fiscal calendar, Manufacturing Calendar or ISO 8601…
Sukesh Marla
  • 178
  • 11
0
votes
2 answers

do I need to define Fact Table or the Dimension tables?

I am trying to build a data warehouse using the OLTP database and was wondering if I need to define the Fact Tables first or the Dimensions? Please help? Regards Yogi
LondonUK
  • 437
  • 1
  • 8
  • 20
1 2 3
…
20 21