Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Get tables from XSD using SSIS

  Hi, I have a xsd file which has more than one tables structures. I am using XML source to get table…

  ayemya

  1 replies

  14 years, 5 months ago

  By: ayemya

• No SSIS option in Visual Studio 2008?

  Just installed VS 2008... File... New... Project... but no "Integration Services Project" type is …

  Greg J

  5 replies

  14 years, 5 months ago

  By: Greg J

• Graphical builder for SSAS cubes?

  Hi Everyone, I’m in the process of converting cubes from both Hyperion Essbase and Comshare MPC to …

  richardshields

  9 replies

  14 years, 5 months ago

  By: richardshields

• How to Assign SSIS User Variable (DOUBLE) from Execute SQL Task

  I'm fairly new to SSIS so I'm a bit stumped on how to get this conversion to go through. I have, wh…

  rheim651

  11 replies

  14 years, 5 months ago

  By: Orlando Colamatteo

• SSIS - Getting Sequence Container Name

  Hello Everyone Here is my issue: 1.I have a Sequence Container . 2.I have a script task in it. 3.…

  Kranthi Babu

  8 replies

  14 years, 5 months ago

  By: J_SANDERS

• SSAS Cube process

  Hello friends, I work for a huge retail chain and so there is large amounts of data that pump-in da…

  maheshsahini

  3 replies

  14 years, 5 months ago

  By: renjith_githu

• Slow Cube Process time in SSAS 2005

  I have a decent sized cube that sources it's data from a 2005 SQL Server DB. We process the cube o…

  John Semo

  2 replies

  14 years, 5 months ago

  By: renjith_githu

• Data from resultset to destination server table

  Hi ! I have a execute SQL Task and i am running one query and it gets data of 200-500 rows of data …

  Steve Dell

  1 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• Fact table creation

  create table master1 ( ID1 int primary key, sal1 int ) create table master2 ( ID2 int primary key, …

  hari_b

  1 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• Column headers not showing on report when exported to pdf

  hey guys, i have an ssrs report created in ssrs business intelligence studio, the report does not s…

  klineandking

  4 replies

  14 years, 5 months ago

  By: klineandking

• how filter dimension attribute data in SSAS Cube

  Hi, I have a cube. I have a attribute region in location dimension. when I select region attribute…

  VRT

  2 replies

  14 years, 5 months ago

  By: VRT

• FACT_TABLE DESIGNING

  create table master1 ( ID1 int primary key, sal1 int ) create table master2 ( ID2 int primary key, …

  hari_b

  3 replies

  14 years, 5 months ago

  By: Jayanth_Kurup

• Top 1 Records in Each Group

  Table Structure CREATE TABLE [dbo].[sts_stock_reg]( [Sys_SR_Num] [numeric](20, 0) IDENTITY(1,1) NO…

  murthysundara

  1 replies

  14 years, 5 months ago

  By: Ron McCullough

• Whats the most hot BI tool now in the market

  hi friends, Now am using Procalrity 6.3 as my front end for our BI solutions.Am quite wondering wh…

  elegantkvc

  18 replies

  14 years, 5 months ago

  By: Ralf Bohne

• Convert XML to relational output

  Hi, I have a table in DB(sql server 2008) with column XMLDoc of type XML. This will XML source f…

  a2zwd

  1 replies

  14 years, 5 months ago

  By: GSquared