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

Difference between ADO NET source and OLE DB Source in SSIS 2008?

Can anyone say the Difference between ADO NET source and OLE DB Source in SSIS 2008 ?are they both same in any context ?
Bala
  • 1,077
  • 5
  • 15
  • 35
13
votes
2 answers

How to configure/Enable the form based authentication in SSRS 2008 RS

I have two reports , one is for internal users and another one is for external users, For internal Users i need to enable form authentication to view the report instead of creating the user accounts in the server. For external User i do not want to…
karhtik
  • 506
  • 3
  • 15
8
votes
1 answer

Pass Parameters to OLE DB SOURCE

I am new to SSIS and having trouble passing parameters to OLE DB Source. I want to query data for a given date range. I have two variables, variable1 of data type Date Time and the value of the variable is set by expression DATEADD("day", -1,…
Sezera
  • 81
  • 1
  • 3
5
votes
5 answers

Yesterday's date in SSIS package setting in variable through expression

I am setting a variable in SSIS package and I'm using this expression: DATEPART("yyyy", GETDATE())*10000 + DATEPART("month", GETDATE())*100 + DATEPART("day",GETDATE()) The expression will give me a variable value like 'yyyymmdd'.…
Mytroy2050
  • 179
  • 1
  • 2
  • 17
4
votes
0 answers

What does SSAS really do when "processing"?

As I can see, the cube issues some queries to the db when processing, like "select xxx from sss", and then build index. But the doc said, cube will "preaggregate" the measures by dimensions so that it's faster than query the database…
L_G
  • 209
  • 2
  • 10
4
votes
2 answers

why we do the convert to projet connection in msbi

I wanted to know the utility of carrying out a conversion in project connection in the connection managers in ssis
Asma
  • 51
  • 2
4
votes
1 answer

what is environment variable configuration in ssis and what registry entry configuration in ssis

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I am not understanding what is Environment Variable configuration and what is registry entry configuration in SSIS.
Ghayaz Dot Net Apps Developer
  • 77
  • 1
  • 2
  • 11
3
votes
2 answers

SSAS - how to perform partial cube processing without losing data

I have cube where measure groups are partitioned into 2 partition for different time frame as below: latest 2 years data ( PRT_DATA_2YEARS ) older data than 2 years ( PRT_DATA_REST ) By processing 1st partition ( with any of processing option ),…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
3
votes
1 answer

Deal with commas in comma delimited file when importing flat file as a source to SQL Server in SSIS

I have a flat file that with comma as a delimiter. In one address column I have . My issue is that one of the fields in my file contains "," (commas), so when the file is created it creates new columns because the field is "," comma delimited on the…
Nadeem Ahmed
  • 31
  • 2
3
votes
1 answer

SSIS :: How to implement SCD type 2 in SSIS without using SCD Wizard. When incoming dataset has multiple records for the same Business Key

In SSIS, if an incoming dataset has multiple records for the same Business Key, how do I load it to the dimensions table with SCD type 2 without using the SCD Wizard. Sample dataset Customer ID Name Segment Postal Code 1 James…
Saurav Kumar
  • 31
  • 3
3
votes
2 answers

How to write the condition in SSRS for dynamically changing color of the cell based on value

How to write the condition in SSRS for dynamically changing color of the cell based on value https://i.stack.imgur.com/2XHL4.png
sanket
  • 59
  • 8
3
votes
1 answer

SSAS MDX Except statement issue

I am working on an requirement in Cube MDX like data for year 2008 and prior should not be displayed in report. So thought of using MDX 'EXCEPT' function in SCOPE statement to exclude the mentioned years. Time dimension is hierarchy with structure…
Naveen Kumar
  • 51
  • 1
3
votes
1 answer

MDX query not working

I am trying to perform the between two dates (inclusive) in mdx. I have two fact tables and one mapping table. Fact_TableA TableAId, ValueA, Date_FK Fact_TableB TableBId, ValueB, Date_FK Fact_MappingTable TableAId, …
107
  • 552
  • 3
  • 26
2
votes
1 answer

Parameter is not visible in the deployed SSIS package

I need to use environment variables instead of the set parameters of the SSIS package / project. I have the following problem: I create a SSIS project/package and project/package parameters deploying the project in SSISDB MS SQL Server why when I…
bwoah
  • 25
  • 7
2
votes
0 answers

what to setup in SQL profiler to investigate SSAS Cube synchronization job hang?

I am using SSIS job to process the ssas DB(cube, dim, partition etc) in source server and XMLA script in the same SSIS package to synchronize the SSAS DB from source server to destination server. This SSIS job is deployed and get initiated daily on…
ScriptSoft
  • 163
  • 1
  • 2
  • 11
1
2 3
…
20 21