Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Creating Real time DASHBOARDS Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 2:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,545, Visits: 11,359
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
Posted Friday, March 22, 2013 1:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 90, Visits: 182
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
Post #1434496
Posted Monday, March 25, 2013 2:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,545, Visits: 11,359
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
Posted Monday, March 25, 2013 5:17 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 90, Visits: 182
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...
Post #1435204
Posted Tuesday, March 26, 2013 3:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,545, Visits: 11,359
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
Posted Tuesday, March 26, 2013 3:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,545, Visits: 11,359
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
Posted Tuesday, March 26, 2013 2:36 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 90, Visits: 182
Thanks...for the advice.
I understood bad so another time this huge Sharepoint...i begin to hate it...
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...:

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

Have a good day.
Post #1435698
Posted Wednesday, March 27, 2013 1:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,545, Visits: 11,359
maretix (3/26/2013)
Thanks...for the advice.
I understood bad so another time this huge Sharepoint...i begin to hate it...
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...


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
Posted Wednesday, March 27, 2013 5:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 8, 2013 7:05 AM
Points: 1, Visits: 265
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
Posted Wednesday, March 27, 2013 10:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 90, Visits: 182
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 »

Add to briefcase ««12

Permissions Expand / Collapse