Business Intelligence

• Topics

  Started by

  Posts

  Last post

• How to install data mining database?

  How to install data mining database? Thanks

  forsqlserver

  2 replies

  14 years, 6 months ago

  By: Koen Verbeeck

• Analysis Services vs. QlikView

  Greetings, I have just been given the task of investigating tools for developing dashboards, busin…

  randy.witt

  11 replies

  14 years, 6 months ago

  By: darth_vodka

• SSIS loosing rows on text file import

  Hi. I only have a small amount of experience with SSIS and I have something very odd happening. I …

  William Plourde

  3 replies

  14 years, 6 months ago

  By: METFANdeRookieGK

• Need some kind of Union in package

  HI, I have my source data this way TestId TestName Testplace TestLoc 1 Social School1 Null 2 Scienc…

  v-swgar

  5 replies

  14 years, 6 months ago

  By: jm99

• Executing a task causes unexpected execution of other tasks

  Hi, I am attaching a few screen-shots below: - the first one, Head.jpg, shows that I have an Execut…

  btio_3000

  2 replies

  14 years, 6 months ago

  By: btio_3000

• Wrong sorting order of Date dimension in Excel.

  Hi. I have a Date/Calendar dimension in my cube. When I open my cube in SSAS cube browser, and then…

  victordba

  3 replies

  14 years, 6 months ago

  By: cmbrooks08

• Data warehouse multiple time dimension

  Hi, I have a weird situation. I need to apply to my fact tables, different time dimension for diff…

  Rem70Rem

  3 replies

  14 years, 6 months ago

  By: PaulB-TheOneAndOnly

• Populate Fact Tables incrementally SSIS 2005

  Hi All, I have populated my dim tables from many base tables via joins in SCD. That part is working…

  ashish.mehrotra

  3 replies

  14 years, 6 months ago

  By: Koen Verbeeck

• cannot convert between unicode and non-unicode string data

  Hi !I am running a simple Query on a oracle source database as below and trying to insert the data…

  Steve Dell

  4 replies

  14 years, 6 months ago

  By: Koen Verbeeck

• How to catch error messages

  Hi ! I am running a query in around 100 oracle databases from BIDS(Visual Studio) .and if any error…

  Steve Dell

  3 replies

  14 years, 6 months ago

  By: Koen Verbeeck

• Referencing Dimensions through a Fact Table

  Hi everybody- I have a fact table of service calls that is basically an accumulating snapshot fact …

  cmbrooks08

  1 replies

  14 years, 6 months ago

  By: cmbrooks08

• Get Max value Min Value and number of values between two dates

  I am creating a report using SSRS and feeding in two dates using paramaters. My table has IssueDate…

  cmckenzie-656927

  1 replies

  14 years, 6 months ago

  By: Orlando Colamatteo

• dropdown list in ssrs report

  I am using this proc for my report alter PROCEDURE counts @year char(4)=null, @month char (3)=null…

  Tara-1044200

  4 replies

  14 years, 6 months ago

  By: sayyad.azhar

• I would like to know some table names and fact table names in Banking projects.Will somebody please provide them

  I would like to know some table names and fact table names in Banking projects.Will somebody please…

  hari_b

  7 replies

  14 years, 6 months ago

  By: taybre

• Populating Result in Excel file - on a specific Column and Row.

  Dear Forum members, I have a different requirement. I am executing few SP's and writing the result …

  rockybhai

  5 replies

  14 years, 6 months ago

  By: taybre