Showing posts with label familiar. Show all posts
Showing posts with label familiar. Show all posts

Thursday, March 22, 2012

Digital Dashboard Question

I’m not sure if this is the right topic for this particular forum but here goes anyway…

Okay, admittedly, I am not really familiar with MS SQL Server (I’m Oracle, actually) but I am investigating a possible implementation on a relatively small scale.I am sure that MS SQL Server will handle all the database functions I need and will leave plenty of room for future growth.That really isn’t the issue.What I am trying to figure out is how the Digital Dashboard I’ve read about works.Of particular concern is the apparent connection between the Dashboard and Share Point.My first question is this:Is Share Point required to use the Digital Dashboard?

My next question is actually a bit easier… Is there a sample site I can access that shows some of the capabilities of a Digital Dashboard implementation?I’d like to make sure that the kinds of displays I am trying to build are actually available using this feature…

Thanks in advance for your assistance!

Try searching around on the MS newsgroups. From what I read on there Digital Dashboard has long been superceeded by WSS.

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=%22digital+dashboard%22&dg=&cat=en_US_8BC69AC3-3D05-041E-84C8-501EAB19564E&lang=en&cr=US&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us

|||

Probably we should start with some understanding about what you are reading. Searching on "digital dashboard" reveals that it's been announced several years ago and a lot of things have changed since

Next, tell us a bit more about your high-level requirements. I guess the most important question is does your dashboard have to be web-based? If so, SharePoint v. 3.0 will definately help since you will get so much "dashboard" plumbing essentially for free, e.g. page personalization. In addtion, since you are posting your question to this forum, SQL Server 2005 SP2 will allow you integrate SSRS reports seamlessly with SharePoint. You will be able to bring in other report views, e.g. Excel spreadsheets, KPIs from SSAS. etc. Yet, you don't have to use SharePoint if for some reason you don't want to. Alternatively, you can whip out a custom ASP.NET-based app.

About your second question, we are still waiting for the AdventureWorks dashboard demo. The Office newsgroups will be a better vanue to ask this question.

|||

Okay...

High Level Requirements - We are a large Army Hospital. The types of data that I need to display include financial, productivity, manpower, and HR data. We currently have several MS Access databases that are handeling the analysis and reporting of this information but because of the large amounts of data, they are begining to stretch the file size limitations of Access. The specific reports that I will want to display are various bar charts, line charts, spreadsheet-type reports and possibly other forms based on the requirements determination that we are still putting together. I will need to use drill down for two reasons: First, each user will need to see primarily that data which pertains to their specific work center. Second, some users will need to move up and down the data chain to gather and analyze information across the enterprise.

Web-based - Well, I think this would work best. Idealy, I'd like to be able to create a mobile version that key staff members can access via their Blackberry devices. This will allow them to take certain data with them to meetings, while traveling, etc... I would be reluctant to put together something that required a client installation on the local PC. There are a lot of people who would need the information and installing and maintaining each one would be difficult.

Share Point - Well, my only problem with this is that we do not currently have Share Point implemented (I know... wake up and smell the technology).

Custom App - Well, the obvious drawback here is development and maintenance. I really don't have the resources to commit to a complex development and maintaining it would be equaly problematic. This is why I think a pre-designed thin client of some kind would work best for my situation. I am not familiar with ASP.NET so I don't really know the level of complexity involved.

I am not necessarily committed to MS SQL Server, if there is another option out there, I'd be happy to hear about it...

Again, thanks in advance for your assistance.

|||

1. Start by implementing the SSRS reports you need.

2. If you need to display reports side-by-side consider installing SQL Server 2005 SP2 to surface the SSRS reports to SharePoint If you don't need side-by-side reports and web parts, you may find that the Report Manager (a web application that ships with SSRS) is all you need. The Report Manager will allow your users to access reports on the web.

Drillthrough reports are supported by SSRS.

Difficulty in creating Time Dimension - SSAS

Hello all,

I am familiar with Analysis Services 2000 in which creating a time dimension is very easy.

In SSAS (2005) , i have a table in which there is field for DateTime which i want to use as time dimesion.

In time dimension wizard , it asks for the column for year , month etc (which is created by default in AS 2000) .

Since i have only one column having datetime datatype, how should i proceed

by creating heirarchy (year,month ,day - same as AS 2000).

Thanks,

deepti

i

You can create a stored procedure that populate a table with "time elements". See this example where I created a procedure that add rows into a table named CALSTD:

create procedure AddCalendar @.nYear int as

if not exists(select * from sysobjects where name='calstd')

CREATE TABLE [dbo].[CalStd](

[Data] [datetime],

[Data_lunii] [datetime],

[An] [smallint],

[Luna] [smallint],

[LunaAlfa] [char](15) ,

[Zi] [smallint],

[Saptamana] [smallint],

[Trimestru] [smallint],

[Zi_alfa] [char](10),

[Camp1] [char](10),

[Camp2] [char](10),

[Camp3] [char](10),

[Fel_zi] [char](1)

) ON [PRIMARY]

DECLARE @.I INT,@.DDATA DATETIME,@.DDATAL DATETIME,@.DDATAST DATETIME,@.NAN INT,@.nZi int,@.cZiChar char(10),@.cLunaAlfa char(15),@.nZileAn int

DELETE FROM CALSTD WHERE YEAR(DATA)=@.NAN

set @.nan=@.nyear

SET @.I=0

SET @.DDATAST=CONVERT(DATETIME,'01/01/'+RTRIM(STR(@.NAN)))

if (@.NAN%4)=0 and (@.nAn%400)<>0

SET @.nZileAn=366

else

set @.nZileAn=365

WHILE @.I<@.nZileAn

BEGIN

SET @.DDATA=DATEADD(DAY,@.i,@.DDATAST)

SET @.DDATAL=dateadd(day, -day(dateadd(month, 1, @.dData)), dateadd(month, 1, @.dData))

Set @.nZi=datepart(weekday,@.dData)

set @.cZiChar=(case when @.nZi=1 then 'Sunday'

when @.nZi=2 then 'Monday'

when @.nZi=3 then 'Tuesday'

when @.nZi=4 then 'Wednesday'

when @.nZi=5 then 'Thursday'

when @.nZi=6 then 'Friday'

else 'Saturday' end)

set @.cLunaAlfa=(case when datepart(month,@.dData)=1 then 'January'

when datepart(month,@.dData)=2 then 'February'

when datepart(month,@.dData)=3 then 'March'

when datepart(month,@.dData)=4 then 'April'

when datepart(month,@.dData)=5 then 'May'

when datepart(month,@.dData)=6 then 'June'

when datepart(month,@.dData)=7 then 'July'

when datepart(month,@.dData)=8 then 'August'

when datepart(month,@.dData)=9 then 'September'

when datepart(month,@.dData)=10 then 'Octomber'

when datepart(month,@.dData)=11 then 'November'

else 'December'

end)

INSERT INTO CALSTD(Data,Data_lunii,An,Luna,LunaAlfa,Zi,Saptamana,Trimestru,Zi_alfa,Camp1,Camp2,Camp3,Fel_zi)

VALUES(@.dData,@.dDatal,datepart(year,@.dData),datepart(month,@.dData),@.cLunaAlfa,datepart(day,@.dData),datepart(week,@.dData),datepart(quarter,@.dData),@.cZiChar,'','','','L')

SET @.I=@.I+1

END

|||

Thanks crysty that was really helpful.

regards,

deepti.

|||

Hi Deepti, I was in the same situation, but I found a simple way to achieve the Time Dimension Generation, please visit the following url, to know something about it. http://www.ssw.com.au/ssw/Standards/Rules/CreatingATimeDimensionIn10EasySteps.aspx

So for more information about sqlserver 2005, i'm building a blog with some resources at: http://grupohix.blogspot.com

Regards

FraGar

Difficulty in creating Time Dimension - SSAS

Hello all,

I am familiar with Analysis Services 2000 in which creating a time dimension is very easy.

In SSAS (2005) , i have a table in which there is field for DateTime which i want to use as time dimesion.

In time dimension wizard , it asks for the column for year , month etc (which is created by default in AS 2000) .

Since i have only one column having datetime datatype, how should i proceed

by creating heirarchy (year,month ,day - same as AS 2000).

Thanks,

deepti

i

You can create a stored procedure that populate a table with "time elements". See this example where I created a procedure that add rows into a table named CALSTD:

create procedure AddCalendar @.nYear int as

if not exists(select * from sysobjects where name='calstd')

CREATE TABLE [dbo].[CalStd](

[Data] [datetime],

[Data_lunii] [datetime],

[An] [smallint],

[Luna] [smallint],

[LunaAlfa] [char](15) ,

[Zi] [smallint],

[Saptamana] [smallint],

[Trimestru] [smallint],

[Zi_alfa] [char](10),

[Camp1] [char](10),

[Camp2] [char](10),

[Camp3] [char](10),

[Fel_zi] [char](1)

) ON [PRIMARY]

DECLARE @.I INT,@.DDATA DATETIME,@.DDATAL DATETIME,@.DDATAST DATETIME,@.NAN INT,@.nZi int,@.cZiChar char(10),@.cLunaAlfa char(15),@.nZileAn int

DELETE FROM CALSTD WHERE YEAR(DATA)=@.NAN

set @.nan=@.nyear

SET @.I=0

SET @.DDATAST=CONVERT(DATETIME,'01/01/'+RTRIM(STR(@.NAN)))

if (@.NAN%4)=0 and (@.nAn%400)<>0

SET @.nZileAn=366

else

set @.nZileAn=365

WHILE @.I<@.nZileAn

BEGIN

SET @.DDATA=DATEADD(DAY,@.i,@.DDATAST)

SET @.DDATAL=dateadd(day, -day(dateadd(month, 1, @.dData)), dateadd(month, 1, @.dData))

Set @.nZi=datepart(weekday,@.dData)

set @.cZiChar=(case when @.nZi=1 then 'Sunday'

when @.nZi=2 then 'Monday'

when @.nZi=3 then 'Tuesday'

when @.nZi=4 then 'Wednesday'

when @.nZi=5 then 'Thursday'

when @.nZi=6 then 'Friday'

else 'Saturday' end)

set @.cLunaAlfa=(case when datepart(month,@.dData)=1 then 'January'

when datepart(month,@.dData)=2 then 'February'

when datepart(month,@.dData)=3 then 'March'

when datepart(month,@.dData)=4 then 'April'

when datepart(month,@.dData)=5 then 'May'

when datepart(month,@.dData)=6 then 'June'

when datepart(month,@.dData)=7 then 'July'

when datepart(month,@.dData)=8 then 'August'

when datepart(month,@.dData)=9 then 'September'

when datepart(month,@.dData)=10 then 'Octomber'

when datepart(month,@.dData)=11 then 'November'

else 'December'

end)

INSERT INTO CALSTD(Data,Data_lunii,An,Luna,LunaAlfa,Zi,Saptamana,Trimestru,Zi_alfa,Camp1,Camp2,Camp3,Fel_zi)

VALUES(@.dData,@.dDatal,datepart(year,@.dData),datepart(month,@.dData),@.cLunaAlfa,datepart(day,@.dData),datepart(week,@.dData),datepart(quarter,@.dData),@.cZiChar,'','','','L')

SET @.I=@.I+1

END

|||

Thanks crysty that was really helpful.

regards,

deepti.

|||

Hi Deepti, I was in the same situation, but I found a simple way to achieve the Time Dimension Generation, please visit the following url, to know something about it. http://www.ssw.com.au/ssw/Standards/Rules/CreatingATimeDimensionIn10EasySteps.aspx

So for more information about sqlserver 2005, i'm building a blog with some resources at: http://grupohix.blogspot.com

Regards

FraGar

Tuesday, February 14, 2012

Differences between 2000 and 2005

Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?

Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone

thx

Kat

hi kat,

install the sql management express to make things easier

http://go.microsoft.com/fwlink/?LinkId=65110.

http://msdn.microsoft.com/vstudio/express/sql/download/

QA and enterprise manager is now integrated as one UI

which is called the management studio (SQL-MS). Since you are using express

you need the MS express.

regards,

joey

|||

Kat,

Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

HTH,

Rajesh

|||

Hi Joey,

Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.

thx,

Kat

|||

Thx Much Rajesh!

Kat

|||

sorry my fault. I've got a hell of a week. my pc bug-ged down so

is my brains. hahaha

i though you were using sql express. just a bit too busy these days

any way if your looking for QA and EM its no longer around.

They are now in the new UI the SQL management Studio.

and yes reporting service is only found in the enterprise version

|||

Thanks Joey,

I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?

thx much!

Kat

|||

hi kat,

Use the developer edition. enterprise edition works best on servers.

developer edition works better in Xp. developer edition

have the same functionallity as the enterprise except that the

are used in development environment.

good luck with your interview

regards,

joey

|||

SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.

SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.

Hope this helps,
Steve

|||

I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.

Kat

|||

try the 2005 developer edition

i'm prettry sure express will install

Differences between 2000 and 2005

Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?

Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone

thx

Kat

hi kat,

install the sql management express to make things easier

http://go.microsoft.com/fwlink/?LinkId=65110.

http://msdn.microsoft.com/vstudio/express/sql/download/

QA and enterprise manager is now integrated as one UI

which is called the management studio (SQL-MS). Since you are using express

you need the MS express.

regards,

joey

|||

Kat,

Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

HTH,

Rajesh

|||

Hi Joey,

Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.

thx,

Kat

|||

Thx Much Rajesh!

Kat

|||

sorry my fault. I've got a hell of a week. my pc bug-ged down so

is my brains. hahaha

i though you were using sql express. just a bit too busy these days

any way if your looking for QA and EM its no longer around.

They are now in the new UI the SQL management Studio.

and yes reporting service is only found in the enterprise version

|||

Thanks Joey,

I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?

thx much!

Kat

|||

hi kat,

Use the developer edition. enterprise edition works best on servers.

developer edition works better in Xp. developer edition

have the same functionallity as the enterprise except that the

are used in development environment.

good luck with your interview

regards,

joey

|||

SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.

SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.

Hope this helps,
Steve

|||

I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.

Kat

|||

try the 2005 developer edition

i'm prettry sure express will install

Differences between 2000 and 2005

Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?

Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone

thx

Kat

hi kat,

install the sql management express to make things easier

http://go.microsoft.com/fwlink/?LinkId=65110.

http://msdn.microsoft.com/vstudio/express/sql/download/

QA and enterprise manager is now integrated as one UI

which is called the management studio (SQL-MS). Since you are using express

you need the MS express.

regards,

joey

|||

Kat,

Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

HTH,

Rajesh

|||

Hi Joey,

Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.

thx,

Kat

|||

Thx Much Rajesh!

Kat

|||

sorry my fault. I've got a hell of a week. my pc bug-ged down so

is my brains. hahaha

i though you were using sql express. just a bit too busy these days

any way if your looking for QA and EM its no longer around.

They are now in the new UI the SQL management Studio.

and yes reporting service is only found in the enterprise version

|||

Thanks Joey,

I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?

thx much!

Kat

|||

hi kat,

Use the developer edition. enterprise edition works best on servers.

developer edition works better in Xp. developer edition

have the same functionallity as the enterprise except that the

are used in development environment.

good luck with your interview

regards,

joey

|||

SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.

SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.

Hope this helps,
Steve

|||

I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.

Kat

|||

try the 2005 developer edition

i'm prettry sure express will install

Differences between 2000 and 2005

Just installed 2005 Enterprise Edition on an XP Media computer... I am blown away because nothing looks familiar to me. Anyone else feel lost?

Where is the best site for specific changes from 1 version to another... it appears that Enterprise Manager is gone, Query Analyzer is gone, my brain is gone

thx

Kat

hi kat,

install the sql management express to make things easier

http://go.microsoft.com/fwlink/?LinkId=65110.

http://msdn.microsoft.com/vstudio/express/sql/download/

QA and enterprise manager is now integrated as one UI

which is called the management studio (SQL-MS). Since you are using express

you need the MS express.

regards,

joey

|||

Kat,

Just have a look into the following product info article which will help you in knowing What's New in SQL Server 2005.

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

HTH,

Rajesh

|||

Hi Joey,

Do you mean that I shouldn't be using the Enterprise Edition? I need to learn the reporting services that aren't in the Express Edition. I'm not sure I understand your answer.

thx,

Kat

|||

Thx Much Rajesh!

Kat

|||

sorry my fault. I've got a hell of a week. my pc bug-ged down so

is my brains. hahaha

i though you were using sql express. just a bit too busy these days

any way if your looking for QA and EM its no longer around.

They are now in the new UI the SQL management Studio.

and yes reporting service is only found in the enterprise version

|||

Thanks Joey,

I'm trying to find out if anyone is running 2005 on an xp media machine. I did get the enterprise edition installed (not the db's yet but someone gave me a link to that). I also installed IIS but know nothing about configuring it. I'm lost in space... interview in 2.5 hours. I bought this machine without knowing that the xp media operating system is an upgrade from xp professional. I'll lose all the programs if I downgrade to professional and since this was a floor model, there aren't any cd's to replace those programs. Microsoft will charge me a wonderful 285 for tech support but I want to find out first if it is even going to be possible. Can you recommend a site to ask, post, whatever?

thx much!

Kat

|||

hi kat,

Use the developer edition. enterprise edition works best on servers.

developer edition works better in Xp. developer edition

have the same functionallity as the enterprise except that the

are used in development environment.

good luck with your interview

regards,

joey

|||

SQL Server Enterprise Edition is supposed to only be installable on server operating systems. XP Media Center is a workstation operating system, so I'm surprised you could install Enterprise on it at all.

SQL Server Developer Edition is functionally equivalent to Enterprise Edition, except it can be installed on Windows XP or Windows Vista. Note that the Developer Edition license doesn't let you use the Developer Edition server for production use.

Hope this helps,
Steve

|||

I spoke with Microsoft and they said I couldn't install 2005 on a XP media machine. I'm not sure now about the other versions. All versions of 2005 require 2000, xp, etc. Nothing is listed as working with the Media version operating system. I was told I had to upgrade to the full version of XP professional. Nice huh? Or I could get rid of all of the programs installed and bring it to another operating system. Oh well, once my XP Pro laptop is fixed, I'll probably try the Express version. I just wanted to work on the reporting services which is available only in the Enterprise Edition as far as I can tell.

Kat

|||

try the 2005 developer edition

i'm prettry sure express will install