Designing a Dashboard - Level 6 in the Stairway to Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jessica M. Moss » Designing a Dashboard - Level 6 in the...

Designing a Dashboard - Level 6 in the Stairway to Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Jessica M. Moss

Posted Wednesday, August 03, 2011 10:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 2:10 PM
Points: 8, Visits: 332

Comments posted to this topic are about the item Designing a Dashboard - Level 6 in the Stairway to Reporting Services

Post #1153997

SQLRNNR

Posted Thursday, August 04, 2011 9:38 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:09 PM
Points: 18,848, Visits: 12,433

Great information and nice tutorial.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1154352

thepotplants

Posted Wednesday, August 15, 2012 5:51 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:09 PM
Points: 53, Visits: 249

Hi.

I've just done the Microsoft SSRS training course, and now that I'm back an work I'm trying to put a few things into practice.

I've downloaded the Adventureworks2008R2 and AdventureWorkDW2008R2 databases and have been trying to work through your example. (It looks great BTW.)

However, I haven't got very far... Your SQL in Figure 3, refers to a table that doesn't exist in the AdventureworksDW2008R2 database: dbo.DimTime. Exercises in SSRS training course Mod 4 refer to it, but none of the supplied scripts create it.

Is this just a version difference? between 2008 and 2008R2 sample db's. Is there a script I need to run?

Any help or suggestions would be greatly appreciated.

Cheers

Pete

Post #1345614

steve roberts

Posted Wednesday, September 12, 2012 3:14 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 12, 2012 6:17 AM
Points: 49, Visits: 163

Hi
I had the same issue and replaced the line in the script

inner join dbo.DimTime t on f.DueDateKey = t.TimeKey

with

INNER JOIN dbo.DimDate AS t ON f.DueDateKey = t.DateKey

hope this helps

Post #1357851

JediSQL

Posted Monday, October 29, 2012 12:28 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:18 PM
Points: 27, Visits: 102

Hi,

I got the same thing, but then I read carefully. She says to use "AdventureWorksDW" not "AdventureWorksDW2008R2".

Sincerely,
Daniel

Post #1378404

JediSQL

Posted Monday, October 29, 2012 12:34 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:18 PM
Points: 27, Visits: 102

So far so good, but now I have a problem with the Dashboard. I do not get the expandable groups. They are all expanded without the +/– control to expand/collapse the groups. It is just a static report with grid lines.

Sincerely,
Daniel

Post #1378407

ccdeal26

Posted Monday, March 18, 2013 9:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:45 AM
Points: 2, Visits: 0

Wonderful.

Share a website with you ,

( http://www.ccdeal.net/ )

Believe you will love it.

We accept any form of payment.

Post #1432236

ccdeal26

Posted Monday, March 18, 2013 9:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:45 AM
Points: 2, Visits: 0

Wonderful.

Share a website with you ,

( http://www.ccdeal.net/ )

Believe you will love it.

We accept any form of payment.

Post #1432237

JAMESC2003

Posted Monday, March 18, 2013 9:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 05, 2013 4:19 PM
Points: 6, Visits: 67

There is a program (adventureworks2008_sr4.exe) that creates the
DW database. I do not remember where I found it, but perhaps
an internet search will help.

Post #1432240

John_P

Posted Monday, March 25, 2013 3:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 06, 2013 3:32 PM
Points: 9, Visits: 44

I Love the SIGN function...

CASE WHEN fsq.SalesAmountQuota > frs.SalesAmount
THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount
THEN 0 ELSE -1 END
END as Trend

Can be replaced with:

SIGN(fsq.SalesAmountQuota - frs.SalesAmount) as Trend

IMNSOH, I think it is simpler :)

Post #1435194

« Prev Topic | Next Topic »

Permissions