Difference between revisions of "Publishing PowerPivot Reports"
(Created page with "From XLCubed v7.5, XLCubed Web Edition allows you to take PowerPivot reports that you have created in Excel and share them with other people in your organisation - without any ne...") |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (8 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | From | + | From FluenceXL v7.5 users can take FluenceXL workbooks which connect to PowerPivot data, and publish these to FluenceXL Web Edition. This enables sharing of the reports or dashboards with non-PowerPivot users through FluenceXL Web Edition and also provides increased scalability and security options. |
| + | |||
| + | The publication process moves the data model directly onto the specified Tabular Analysis Services instance, and dynamically changes the data connection on the published report. The publication process does not require SharePoint or Excel services. | ||
==Requirements== | ==Requirements== | ||
| − | * | + | * FluenceXL Web Edition v7.5 or higher Enterprise Edition with the scheduling feature set up |
| − | * Microsoft Analysis Services 2012 in | + | * Microsoft Analysis Services 2012 or higher in Tabular mode |
==Overview== | ==Overview== | ||
| − | + | FluenceXL can monitor one or more directories on the Web Edition server, usually in the Web repository. When an appropriate set of files is created or updated in that directory, the PowerPivot connections are published to Analysis Services: | |
* The connection file is uploaded to a common network share | * The connection file is uploaded to a common network share | ||
* The information is copied to an Analysis Services database | * The information is copied to an Analysis Services database | ||
| − | * The | + | * The FluenceXL report is modified to point to the newly created database |
==Configuration== | ==Configuration== | ||
| − | A new configuration file must be created in the | + | A new configuration file must be created in the FluenceXL Web Edition repository: |
{{Code|\Repository\__xlcubed__\__scheduling__\monitor.xml}} | {{Code|\Repository\__xlcubed__\__scheduling__\monitor.xml}} | ||
This configuration file is an XML file containing one or more powerPivot elements, enclosed in a single monitor element: | This configuration file is an XML file containing one or more powerPivot elements, enclosed in a single monitor element: | ||
| Line 18: | Line 20: | ||
<monitor> | <monitor> | ||
<powerPivot | <powerPivot | ||
| − | folder="C:\inetpub\wwwroot\ | + | folder="C:\inetpub\wwwroot\FluenceXLWeb\Repository\PowerPivot Reports" includeSubfolders="true" |
server="as2012server" uploadShare="\\as2012server\powerPivotFiles\" serverLocalPath="C:\powerPivotFiles" | server="as2012server" uploadShare="\\as2012server\powerPivotFiles\" serverLocalPath="C:\powerPivotFiles" | ||
allowOverwrite="true" | allowOverwrite="true" | ||
| Line 37: | Line 39: | ||
; allowOverwrite | ; allowOverwrite | ||
: Defines whether any existing database should be overwritten. Can be set to true or false. | : Defines whether any existing database should be overwritten. Can be set to true or false. | ||
| + | ; roleMembers | ||
| + | : A semicolon delimited set of usernames and groups to give access to the new database. | ||
| + | ; notificationEmail | ||
| + | : An email address to send the notification to when a new database is uploaded. Optional; uses the first available SMTP server. | ||
| + | |||
| + | If the server is on the same machine as FluenceXL Web Edition, then {{Code|uploadShare}} and {{Code|serverLocalPath}} can both be left blank, and the scheduler will just use the workbook where it is. | ||
| − | + | Note that the scheduler user must have permissions on the Analysis Services server to restore a database. Any messages, success or failure, will be written to the standard error log (See [[Scheduling with the File-based Repository#Finding the Scheduling Error Log|this article]] for file-based repositories, and [[Scheduling with the SQL Repository#Finding the Scheduling Error Log|this article]] for the SQL repository). | |
| − | + | ==See Also== | |
| + | * [[Scheduling with the File-based Repository]] | ||
| + | * [[Scheduling with the SQL Repository]] | ||
[[Category:Web Edition]] | [[Category:Web Edition]] | ||
[[Category:Installation]] | [[Category:Installation]] | ||
Latest revision as of 08:31, 4 July 2023
From FluenceXL v7.5 users can take FluenceXL workbooks which connect to PowerPivot data, and publish these to FluenceXL Web Edition. This enables sharing of the reports or dashboards with non-PowerPivot users through FluenceXL Web Edition and also provides increased scalability and security options.
The publication process moves the data model directly onto the specified Tabular Analysis Services instance, and dynamically changes the data connection on the published report. The publication process does not require SharePoint or Excel services.
Contents
[hide]Requirements
- FluenceXL Web Edition v7.5 or higher Enterprise Edition with the scheduling feature set up
- Microsoft Analysis Services 2012 or higher in Tabular mode
Overview
FluenceXL can monitor one or more directories on the Web Edition server, usually in the Web repository. When an appropriate set of files is created or updated in that directory, the PowerPivot connections are published to Analysis Services:
- The connection file is uploaded to a common network share
- The information is copied to an Analysis Services database
- The FluenceXL report is modified to point to the newly created database
Configuration
A new configuration file must be created in the FluenceXL Web Edition repository:
\Repository\__xlcubed__\__scheduling__\monitor.xml
This configuration file is an XML file containing one or more powerPivot elements, enclosed in a single monitor element:
<monitor>
<powerPivot
folder="C:\inetpub\wwwroot\FluenceXLWeb\Repository\PowerPivot Reports" includeSubfolders="true"
server="as2012server" uploadShare="\\as2012server\powerPivotFiles\" serverLocalPath="C:\powerPivotFiles"
allowOverwrite="true"
/>
</monitor>
Each powerPivot element defines a repository folder to watch, and information about what to do with new files:
- folder
- The folder to watch.
- includeSubfolders
- Whether to also watch subfolders of the main folder.
- server
- The Analysis Services 2012 Vertipaq server on which to create the database.
- uploadShare
- A shared directory on the Analysis Services server, which can be used for temporarily holding the connection information. The user running the scheduler service must have write access to this folder.
- serverLocalPath
- The same directory as uploadShare, but from the point of view of the server.
- allowOverwrite
- Defines whether any existing database should be overwritten. Can be set to true or false.
- roleMembers
- A semicolon delimited set of usernames and groups to give access to the new database.
- notificationEmail
- An email address to send the notification to when a new database is uploaded. Optional; uses the first available SMTP server.
If the server is on the same machine as FluenceXL Web Edition, then uploadShare and serverLocalPath can both be left blank, and the scheduler will just use the workbook where it is.
Note that the scheduler user must have permissions on the Analysis Services server to restore a database. Any messages, success or failure, will be written to the standard error log (See this article for file-based repositories, and this article for the SQL repository).
