Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Fact table design issue- Please advise!

  Hi, I am trying to design the star schema (and OLAP cubes) using SQL server relational tables. I am…

  Pac123

  8 replies

  14 years, 10 months ago

  By: andrew gothard

• MDX Parallel Period same as WHERE clause

  I am new to MDX, and can't for the life of me figure out how to get the SAME parallel period as my …

  Greg Grow

  1 replies

  14 years, 10 months ago

  By: George W (no relation)

• SSRS report with Multi Value and Null Parameter

  HI Guys, I have got a question for SSRS. I am creating a report and i am adding a drop down menu wi…

  zombi

  19 replies

  14 years, 10 months ago

  By: shanu.hoosen

• Problem authenticating ReportServer connection

  Hello, Thanks for looking at this. I have a pc that I've installed MSSQL 2008 on and have successfu…

  hans.johnson

  2 replies

  14 years, 10 months ago

  By: hans.johnson

• SSIS Package Hangs

  i have a package with a data flow task that has an OLE DB source and OLE DB Destination. In the OLE…

  mrtrich99

  3 replies

  14 years, 10 months ago

  By: sqlrocks79

• MDX SSAS Calculation - Contact Duration

  I have a problem with a measure in my cube. Please xcuse me, I am relatively fresh at maniupulating…

  ProKelly

  2 replies

  14 years, 10 months ago

  By: Peter Rijs

• Help me to deploy my repots to sharepoint

  I am new into sql server 2005 reporting. I have managed to create a report but now I want help in d…

  bseloko

  2 replies

  14 years, 10 months ago

  By: steveb.

• SSAS 2005 - Organistion Hierarchy - Parent Child Relationship

  I am trying to create a dimension to show a company's organisational hierarchy which has the follow…

  jerstep

  6 replies

  14 years, 10 months ago

  By: jerstep

• reports on report manager

  I i lost all my reports on report manager can i get them back from the ReportServer database for wh…

  Tara-1044200

  3 replies

  14 years, 10 months ago

  By: Dave Klug

• Handling different Time Zones

  I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC ti…

  Daniel Klionsky

  1 replies

  14 years, 10 months ago

  By: andrew gothard

• SSIS File System Task

  Hi I used Foreach loop container to move the data from D:\data to E:\olddata so i used File Syste…

  parthi-1705

  7 replies

  14 years, 10 months ago

  By: Chuck Hottle

• overlapping problem

  Hi guys, I have a table resource_schedule fields resource_id int,startime int schedule varchar(36) …

  natalie_orlovsky

  7 replies

  14 years, 10 months ago

  By: natalie_orlovsky

• Need to construct an error message in SSIS

  This is my first SSIS package. It runs a stored procedure on each of 12 servers that deletes users…

  Judy Scheinuk

  10 replies

  14 years, 10 months ago

  By: Alvin Ramard

• SSIS Deployment Issue: Config file already exists

  Please help Error204System.ApplicationException: Could not copy file "C:\LED\Config Files\STGETWO…

  suresh_sqldba

  11 replies

  14 years, 11 months ago

  By: Sriram-288748

• Inventory of the reports and subscriptions on MS Reporting Server

  I need to see what reports are scheduled to run in MS Reporting Server. I tried USE ReportServer …

  Iulian -207023

  1 replies

  14 years, 11 months ago

  By: Iulian -207023