Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Reporting without using SSRS

  I am looking for reference materials and/or strategies for improved reporting performance that appl…

  duncfair

  17 replies

  14 years, 7 months ago

  By: Evil Kraig F

• SSIS: Can't import data from MS Access: The workgroup information file is missing or opened exclusively by another user

  I need to use an MS Access database as my datasource to do some work on it to migrate it to SQL Ser…

  Maxer

  20 replies

  14 years, 8 months ago

  By: sgmunson

• Documenting a BI Project

  Hi, We just implemented a BI solution and I wanted to go back and document in detail the entire pro…

  BoilerJ

  5 replies

  14 years, 8 months ago

  By: BoilerJ

• Date table not in cube

  I have a Date Dimension table in the DSV, then created the Dimension for it (Dim Date). When I fina…

  Brandie Tarvin

  22 replies

  14 years, 8 months ago

  By: Brandie Tarvin

• How to access the datasource of a connection manager ?

  Hi, I was trying to retrieve the datasource of a connection manager that i have used to make a conn…

  kiran.mahamkali

  1 replies

  14 years, 8 months ago

  By: kiran.mahamkali

• Loading tables in ssis with Parent Child relation ship

  i have two table X,Y with out any refrential Integrity, i want them to be loaded into tables X1 and…

  sweath

  5 replies

  14 years, 8 months ago

  By: cochran124

• SSAS Scope and Role playing date dimensions

  I have two measures in a cube (SSAS 2008) e.g. [Measure] [Measure LastNonEmpty] one aggregates usin…

  pete.griffiths

  3 replies

  14 years, 8 months ago

  By: pete.griffiths

• reuse dataset but with different parameter value possible?

  Is it possible to build an rdl report that has one datasource and two report tables. each table usi…

  smallmoney

  1 replies

  14 years, 8 months ago

  By: smallmoney

• Installing Analysis and Integration services On Virtual server

  ...

  SqlSavy

  2 replies

  14 years, 8 months ago

  By: Gail Shaw

• Error while deploying Report to Report Server

  I am having the following error while deploying reports on the report server. I am deploying from t…

  Virender Sihag

  1 replies

  14 years, 8 months ago

  By: Raunak Jhawar

• Excel not supported in SSIS 64bit

  Hi Experts, I am running a package with a 64bit version of sql server .The package runs fine when e…

  sqlislife

  3 replies

  14 years, 8 months ago

  By: liam.gavin

• SSIS Package to export data to a spreadsheet

  Hi, I am new to SSIS, I need assistance in creating a package that will export data to an excel and…

  epari_srikant

  9 replies

  14 years, 8 months ago

  By: Koen Verbeeck

• Cube not being populated with data after a certain date

  I get the following error messages when my SSAS package executes: Executed as user: INTLSOS\london.…

  barryFS

  4 replies

  14 years, 8 months ago

  By: stevefromOZ

• Query on using BIDS and connecting to Analysis Services database

  Hi there - have a question relating to the following issue I am having. Running SQL 2005 SP3, and…

  BravehearT1326

  1 replies

  14 years, 8 months ago

  By: Brandie Tarvin

• Could not load file or assembly 'file:///C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ScriptTask\10.0.0.0__89845dcd8080cc91\Interop.ADODB.dll' or one of its dependencies. The system cannot find the file specified.

  Hi All, Presently i am working on SSIS 2008. Here i am using Script task vb.net project. Here i am…

  pkkrao1

  1 replies

  14 years, 8 months ago

  By: Brandie Tarvin