Re: SharePoint BI
Have fun with that then. :) We recently deployed a solution using SSRS and the only solution I came up with was permissioning the pages used to run the reports from. One for admins, contributors and readers. Painful but it worked. I wrote a powershell script to create the 140 pages and provision the web parts and filters, create the unique groups etc. On 29 January 2013 08:58, Ajay wrote: > I have been asked to assist with a big BI project and most of BI guys have > not used SharePoint. > They will use Performance Point, Power Pivot and SSRS. (Sql Server 2012).. > no excel services > > I believe it will be stored in library and after publishing they can > update the columns.. > I noticed in performance point dashboard there is provision to add custom > properties... which then get promoted as library columns > > > > > On Tue, Jan 29, 2013 at 10:51 AM, Web Admin > wrote: > >> If the report resides in a library then, yes. Just add some new columns. >> >> Are you using Excel Services or what? >> >> >> On 29 January 2013 08:39, Ajay wrote: >> >>> [?] Confusion.. I didn't meant 2010 metadata.. meant any user defined >>> data. >>> >>> When publish reports to SharePoint.. can we assign additional >>> information for that report like Report Owner, Technical Owner.. >>> >>> >>> >>> On Tue, Jan 29, 2013 at 10:26 AM, Web Admin < >>> web.ad...@syd.catholic.edu.au> wrote: >>> I've used audience-targeting and custom permissions on documents used for the reports. Never really played around with metadata in 2010 yet. :\ On 27 January 2013 14:15, Ajay wrote: > Can we specify metadata for the reports/dashboard published > to SharePoint.. e.g. create new fields like owner for the > report/dashboards. > Which users can view.. e.g. the report owner.. in case they have a > feedback. > > I have just started looking into this.. if someone has done this or > has any idea.. will be great to hear > > Cheers, > Ajay > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > -- Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@syd.catholic.edu.au w: http://www.ceosyd.catholic.edu.au/ ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >>> >>> ___ >>> ozmoss mailing list >>> ozmoss@ozmoss.com >>> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >>> >>> >> >> >> -- >> Regards, >> >> Paul Noone >> >> SharePoint Farm Admin/Developer >> Infrastructure Team >> CEO Sydney >> >> p: (02) 9568 8461 >> f: (02) 9568 8483 >> e: paul.no...@syd.catholic.edu.au >> w: http://www.ceosyd.catholic.edu.au/ >> >> ___ >> ozmoss mailing list >> ozmoss@ozmoss.com >> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >> >> > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > -- Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@syd.catholic.edu.au w: http://www.ceosyd.catholic.edu.au/ <<330.gif>>___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: SharePoint BI
I have been asked to assist with a big BI project and most of BI guys have not used SharePoint. They will use Performance Point, Power Pivot and SSRS. (Sql Server 2012).. no excel services I believe it will be stored in library and after publishing they can update the columns.. I noticed in performance point dashboard there is provision to add custom properties... which then get promoted as library columns On Tue, Jan 29, 2013 at 10:51 AM, Web Admin wrote: > If the report resides in a library then, yes. Just add some new columns. > > Are you using Excel Services or what? > > > On 29 January 2013 08:39, Ajay wrote: > >> [?] Confusion.. I didn't meant 2010 metadata.. meant any user defined >> data. >> >> When publish reports to SharePoint.. can we assign additional information >> for that report like Report Owner, Technical Owner.. >> >> >> >> On Tue, Jan 29, 2013 at 10:26 AM, Web Admin < >> web.ad...@syd.catholic.edu.au> wrote: >> >>> I've used audience-targeting and custom permissions on documents used >>> for the reports. >>> >>> Never really played around with metadata in 2010 yet. :\ >>> >>> >>> On 27 January 2013 14:15, Ajay wrote: >>> Can we specify metadata for the reports/dashboard published to SharePoint.. e.g. create new fields like owner for the report/dashboards. Which users can view.. e.g. the report owner.. in case they have a feedback. I have just started looking into this.. if someone has done this or has any idea.. will be great to hear Cheers, Ajay ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >>> >>> >>> -- >>> Regards, >>> >>> Paul Noone >>> >>> SharePoint Farm Admin/Developer >>> Infrastructure Team >>> CEO Sydney >>> >>> p: (02) 9568 8461 >>> f: (02) 9568 8483 >>> e: paul.no...@syd.catholic.edu.au >>> w: http://www.ceosyd.catholic.edu.au/ >>> >>> ___ >>> ozmoss mailing list >>> ozmoss@ozmoss.com >>> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >>> >>> >> >> ___ >> ozmoss mailing list >> ozmoss@ozmoss.com >> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >> >> > > > -- > Regards, > > Paul Noone > > SharePoint Farm Admin/Developer > Infrastructure Team > CEO Sydney > > p: (02) 9568 8461 > f: (02) 9568 8483 > e: paul.no...@syd.catholic.edu.au > w: http://www.ceosyd.catholic.edu.au/ > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > <<330.gif>>___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: SharePoint BI
If the report resides in a library then, yes. Just add some new columns. Are you using Excel Services or what? On 29 January 2013 08:39, Ajay wrote: > [?] Confusion.. I didn't meant 2010 metadata.. meant any user defined data. > > When publish reports to SharePoint.. can we assign additional information > for that report like Report Owner, Technical Owner.. > > > > On Tue, Jan 29, 2013 at 10:26 AM, Web Admin > wrote: > >> I've used audience-targeting and custom permissions on documents used for >> the reports. >> >> Never really played around with metadata in 2010 yet. :\ >> >> >> On 27 January 2013 14:15, Ajay wrote: >> >>> Can we specify metadata for the reports/dashboard published >>> to SharePoint.. e.g. create new fields like owner for the report/dashboards. >>> Which users can view.. e.g. the report owner.. in case they have a >>> feedback. >>> >>> I have just started looking into this.. if someone has done this or has >>> any idea.. will be great to hear >>> >>> Cheers, >>> Ajay >>> >>> ___ >>> ozmoss mailing list >>> ozmoss@ozmoss.com >>> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >>> >>> >> >> >> -- >> Regards, >> >> Paul Noone >> >> SharePoint Farm Admin/Developer >> Infrastructure Team >> CEO Sydney >> >> p: (02) 9568 8461 >> f: (02) 9568 8483 >> e: paul.no...@syd.catholic.edu.au >> w: http://www.ceosyd.catholic.edu.au/ >> >> ___ >> ozmoss mailing list >> ozmoss@ozmoss.com >> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >> >> > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > -- Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@syd.catholic.edu.au w: http://www.ceosyd.catholic.edu.au/ <<330.gif>>___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: SharePoint BI
[?] Confusion.. I didn't meant 2010 metadata.. meant any user defined data. When publish reports to SharePoint.. can we assign additional information for that report like Report Owner, Technical Owner.. On Tue, Jan 29, 2013 at 10:26 AM, Web Admin wrote: > I've used audience-targeting and custom permissions on documents used for > the reports. > > Never really played around with metadata in 2010 yet. :\ > > > On 27 January 2013 14:15, Ajay wrote: > >> Can we specify metadata for the reports/dashboard published >> to SharePoint.. e.g. create new fields like owner for the report/dashboards. >> Which users can view.. e.g. the report owner.. in case they have a >> feedback. >> >> I have just started looking into this.. if someone has done this or has >> any idea.. will be great to hear >> >> Cheers, >> Ajay >> >> ___ >> ozmoss mailing list >> ozmoss@ozmoss.com >> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss >> >> > > > -- > Regards, > > Paul Noone > > SharePoint Farm Admin/Developer > Infrastructure Team > CEO Sydney > > p: (02) 9568 8461 > f: (02) 9568 8483 > e: paul.no...@syd.catholic.edu.au > w: http://www.ceosyd.catholic.edu.au/ > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > <<330.gif>>___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
Re: SharePoint BI
I've used audience-targeting and custom permissions on documents used for the reports. Never really played around with metadata in 2010 yet. :\ On 27 January 2013 14:15, Ajay wrote: > Can we specify metadata for the reports/dashboard published > to SharePoint.. e.g. create new fields like owner for the report/dashboards. > Which users can view.. e.g. the report owner.. in case they have a > feedback. > > I have just started looking into this.. if someone has done this or has > any idea.. will be great to hear > > Cheers, > Ajay > > ___ > ozmoss mailing list > ozmoss@ozmoss.com > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > > -- Regards, Paul Noone SharePoint Farm Admin/Developer Infrastructure Team CEO Sydney p: (02) 9568 8461 f: (02) 9568 8483 e: paul.no...@syd.catholic.edu.au w: http://www.ceosyd.catholic.edu.au/ ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
SharePoint BI
Can we specify metadata for the reports/dashboard published to SharePoint.. e.g. create new fields like owner for the report/dashboards. Which users can view.. e.g. the report owner.. in case they have a feedback. I have just started looking into this.. if someone has done this or has any idea.. will be great to hear Cheers, Ajay ___ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss