SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Creating Real time DASHBOARDS


Creating Real time DASHBOARDS

Author
Message
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27799 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
maretix
maretix
Old Hand
Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)

Group: General Forum Members
Points: 313 Visits: 234
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:-)
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27799 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
maretix
maretix
Old Hand
Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)

Group: General Forum Members
Points: 313 Visits: 234
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...:-)
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27799 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27799 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
maretix
maretix
Old Hand
Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)

Group: General Forum Members
Points: 313 Visits: 234
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...:Angry

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

Have a good day.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27799 Visits: 13268
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
lmartino
lmartino
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 272
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
maretix
maretix
Old Hand
Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)Old Hand (313 reputation)

Group: General Forum Members
Points: 313 Visits: 234
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...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search