Creating Real time DASHBOARDS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Creating Real time DASHBOARDS

20 posts, Page 2 of 2

««1 2

Creating Real time DASHBOARDS

Rate Topic

Display Mode

Topic Options

Author

Message

Koen Verbeeck

Posted Friday, March 22, 2013 2:04 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

maretix (3/21/2013)

Hi.
Thans for your comment.
Yes i am reading about PowerView and i used Power pIVOT yet.
I will install Excel 2013 so i will test both together...
But even if i was able to create dashboards in PowerView , how can i share these Excel workbooks with others users ???
I do not know want to build only dashboard for me...but i have to produce something that a group of users have to use in our network...
How can i do that without SharePoint ???
I do not know...

Remember that you need a specific edition of Office 2013 to have Power View. I think it is Professional Plus, which only comes in volume licensing.
Share? Everyone with the same edition of Excel can view the Power View reports. I believe you can export it to PowerPoint, but I'll have to check that out.
Without SharePoint it certainly becomes trickier. Microsoft has designed it's BI stack in such a way you need SharePoint in a corporate environment so you can easily share your dashboards.

Anyway, other competitors also need some kind of server to run their dashboards on, so either way, you'll still be spending money.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1434154

maretix

Posted Friday, March 22, 2013 1:25 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:04 PM
Points: 52, Visits: 93

Thanks for reply.
Yes MICROSOFT wants you buy Sharepoint 201 OR BETTER 2013 ,,,but not all companies can do that.
Besides you need SHAREPOINT not STANDARD EDITION but ENTERPRISE...

Another question if you know..

I have SSAS 2008 R2 and i built 10 MULTIDIMENSIONAL CUBES.
To browse them with POWERVIEW i need to upgrade to SQL SERVER 2012 ..but i read it is no native so i need to install SQL SERVER 2012 and add to it also a new CTP ...
Is it true ???

After all can i really browse my MULTIDIMENSIONAL CUBES without do nothing on clients and ONLY to install that patch in my DW Server over SQL SERVER 2012 standard installation ???

(aT THE MOMENT i cannot use TABULAR Models only POWERPIVOT with Excel)..

Thanks for your possibile reply,,,,HAVE A GOOD WEEK.END Smile

Post #1434496

Koen Verbeeck

Posted Monday, March 25, 2013 2:27 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

Yes, you need SQL Server 2012 to use Power View. In order to use it on Office 2013, I think you need service pack 1, not 100% sure on that.
Furthermore, Power View works - for the moment - only on tabular models. This means PowerPivot or SSAS 2012 Tabular. So you cannot use your multidimensional cubes in Power View.

ps: I think there's something wrong with your caps lock

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1434776

maretix

Posted Monday, March 25, 2013 5:17 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:04 PM
Points: 52, Visits: 93

Hi thanks for you reply.
This confim what i read.
Besides i found this useful link that tells there is CTP for Multidimensional Cubes in PowerView.

Here is that link ----> http://www.microsoft.com/en-us/download/details.aspx?id=35822

If i understood good i have to :

1) Install SQL SERVER 2012 on my SSAS Server (New one virtual server)
(Our company will buy only SQL SERVER 2012 Standard Edition..so nothing Tabular Model are permitted,,,)
2) Install that CTP (I understood so..)
3) In this way i will be able to use PowerView with PowerPivot and also with Multidimensional Cubes.

In future if our company will buy a version major of Standard , also it will be possibile use Tabular Models...

Did you suggest to try ????

Will see next month will be install Sql Server 2012....

Ps. Awfully sorry for my Caps Lock... Smile

Post #1435204

Koen Verbeeck

Posted Tuesday, March 26, 2013 3:46 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

Right, I forgot about that CTP. It is still brand new, so I would test it out thoroughly before you set anything in production.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1435351

Koen Verbeeck

Posted Tuesday, March 26, 2013 3:50 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

I've been going through the documentation of that CTP, and it seems you still need SharePoint:

In the Power View connectivity for Multidimensional Models CTP, connectivity to Multidimensional Models (cubes) is supported for Power View in SharePoint mode.

Power View for Multidimensional Models - Feature Drill Down

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1435354

maretix

Posted Tuesday, March 26, 2013 2:36 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:04 PM
Points: 52, Visits: 93

Thanks...for the advice.
I understood bad so another time this huge Sharepoint...i begin to hate it... Smile

i imagine also people need to buy Sharepoint Enterprise...we have only Sharepoint Standard...

Why this ??? I have 60 users that every day quering Multidimensional cubes, why i cannot use powerful feature of PowerView with any models Tabular or Multidimensional...

Okay i think i will test PowerView next week installing Excel 2013 on my Home Pc, and i will test over PowerPivot model...

Will see if a day , something will be change...: Angry

Many thanks for your patience...
I hope to talk with you others times..

Have a good day.

Post #1435698

Koen Verbeeck

Posted Wednesday, March 27, 2013 1:34 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378, Visits: 6,473

maretix (3/26/2013)

Thanks...for the advice.
I understood bad so another time this huge Sharepoint...i begin to hate it... Smile

Microsoft is still a company who has to make profit. They want to sell SharePoint Enterprise licenses, so they put the good stuff over there.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1435787

lmartino

Posted Wednesday, March 27, 2013 5:12 AM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 1:35 AM
Points: 1, Visits: 258

I know Targit, we used it for ours multidimensional cubes (SSAS).
It's fine and very, very simply to use.

We are in Italy, and we never had problems with sw house that provides Targit.
If Targit is not able to do a job or a expression, the house sw declares him or tries to solve the problem.

Ciao
L

Post #1435828

maretix

Posted Wednesday, March 27, 2013 10:55 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:04 PM
Points: 52, Visits: 93

Hi we are in Italy too (Bologna)
3 years ago i saw a Demo about TARGIT.....
I think it is a good product...
I suggest to my chief to do a Demo again...
Many thanks...

Post #1436041

« Prev Topic | Next Topic »

20 posts, Page 2 of 2

««1 2

Permissions