XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Main Page"
 
(70 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
{{DISPLAYTITLE:<span style="display:none">{{FULLPAGENAME}}</span>}}
+
__NOTOC__
 +
=XLCubed Help **FOR LEGACY VERSIONS ONLY, to 10.0.157**. Rebranded to FluenceXL in May 23 =
  
−
{{MainBox|Welcome to the XLCubed Online Help|
+
XLCubed is an Excel add-in that allows users to quickly and easily create reports from various data sources, addressing the issues of Excel and extending its capabilities to deliver a powerful analysis, reporting and dashboard solution. Any XLCubed report developed in the Excel client can be published to XLCubed Web for easy access and distribution of data connected and interactive reports, respecting corporate security.
−
XLCubed is an Excel add-in that allows you to quickly and easily create reports from various sources, primarily Analysis Services cubes but with the introduction of Version 7 [[http://www.xlcubed.com/products/version7]] now a wide range of [[SQL|relational]] data sources.
 
  
−
XLCubed delivers a powerful analysis, reporting and dashboard solution that unites rich OLAP capabilities centred in the familiar environment of Excel. Combined with Microsoft SQL Server Analysis Services, other ODBO OLAP servers and OLE DB compatible data sources, XLCubed through its Excel and Web Editions provides:
+
View the links below for guidelines on getting started with XLCubed, or see the list of [[User Manual|all help categories]].  
  
−
*the security and integrity of an enterprise BI deployment needed to maintain a single version of the truth
+
<div class="card-container">
−
*the familiarity, flexibility and freedom of spreadsheet reporting and analysis but directly connected to data reducing spreadsheet risk
+
{{Card|Excel Edition|
−
*modern data visualization capabilities to deliver maximum contextual insight into the hands of the business users
+
[[Managing Connections|Connecting to your data]]
−
*true thin client delivery of authored Excel reports for interactive dynamic content on the Web
 
  
−
XLCubed has been designed to allow you to quickly produce basic PivotTable-style reports ([[Grids]]) without compromising performance, while still letting you access the complexity of a full OLAP implementation using [[Formula Reporting Overview|Formula-based reports]]. For a brief comparison of these styles of reporting, see [[Grid vs. Formula-based Reporting Key Differences]].
+
[[Grid Reporting Overview|Adding a grid]]
  
−
XLCubed requires Excel to be running before it can be used, and its functionality is available through the XLCubed menu option within Excel or through the XLCubed toolbar, once the add-in has been installed. Whenever a copy of Excel is started with the Add-in, you will see XLCubed in the Excel ribbon or menu.
+
[[Dimension Slicers|Slicers]]
 +
 
 +
[[Calculations Overview|Calculations]]
 +
 
 +
[[Charting and Dashboards|Charting and Data Visualisation]]
 +
 
 +
[[Ranking, Sorting and Filtering]]
 +
 
 +
[[:Category:Formula Reporting|Formula Reporting]]
 
}}
 
}}
−
<br>
 
  
−
{| width=100% |
+
{{Card|Web Edition|
−
|-
+
[[Web Publishing|Web Publication]]
−
!colspan="3" style="background: #ffdead;padding:3px 3px; margin:0px; border: 1px solid #AAA;" | Getting Started
 
−
|-
 
−
|colspan="3" style="margin:0px; border: 1px solid #AAA;"|
 
−
{{:Getting Started Summary}}
 
  
−
|-
+
[[Web HomePage]]
−
|width=33% valign=top|
+
 
−
{{SubBox|OLAP|
+
[[Web Parameters]]
−
{{#dpl:
+
 
−
  category=Getting Started|
+
[[Multi-sheet Web Printing]]
−
  mode=userformat|
+
 
−
  listseparators=,*[[%PAGE%]]\n,,|
+
[[PowerPoint export]]
 +
 
 +
[[SQL Repository]]
 +
 
 +
[[Scheduling]]
 
}}
 
}}
−
}}
 
−
|width=33% valign=top|
 
−
{{SubBox|SQL|
 
−
{{#dpl:
 
−
  category=SQL Getting Started|
 
−
  mode=userformat|
 
−
  listseparators=,*[[%PAGE%]]\n,,|
 
−
}}
 
−
}}
 
−
|width=33% valign=top|
 
−
{{SubBox|DAX|
 
−
{{#dpl:
 
−
  category=DAX Getting Started|
 
−
  mode=userformat|
 
−
  listseparators=,*[[%PAGE%]]\n,,|
 
−
}}
 
−
}}
 
−
|}
 
  
−
<br>
+
</div>
 +
 
 +
==Other Resources==
 +
===Videos===
 +
*[[Grid Introduction Video|Grids]]
 +
*[[Dimension Slicers Videos|Slicers]]
 +
*[[Formula Introduction Videos|Formula]]
 +
*[[Ranking, Sorting and Filtering Videos|Ranking, Sorting and Filtering]]
 +
*[[Publication Video|Web Publishing]]
  
−
{| width=100%
+
<small>[[:Category:Videos|See all]]</small>
−
|-
 
−
!colspan="2" style="background: #CFC;padding:3px 3px; margin:0px; border: 1px solid #AAA;" | Latest Updates
 
  
−
|-
+
===Tutorials===
 +
*[[Tutorial: Getting Started|Getting Started]]
 +
*[[Tutorial: Grid Calculations|Grid Calculations]]
 +
*[[Tutorial: Creating A Responsive Navigation Bar|Creating A Responsive Navigation Bar]]
 +
*[[Business Rules#Example|Using Business Rules]]
 +
*[[Tutorial: Vertical Waterfalls with Variances|Vertical Waterfalls with Variances]]
  
−
|width=50% valign=top|
+
===Useful Links===
−
{{SubBox|News|
 
−
<rss>http://www.xlcubed.com/index.php?option=com_content&view=category&layout=blog&id=1&Itemid=97&format=feed&type=rss|short|date|max=5</rss>
 
−
}}
 
−
|width=50% valign=top|
 
−
{{SubBox|Blog|
 
−
<rss>http://blog.xlcubed.com/rss2|short|date|max=5</rss>
 
−
}}
 
  
−
|-
+
*[https://www.xlcubed.com XLCubed Main Site]
−
|width=50% valign=top|
+
*[https://blog.xlcubed.com XLCubed Blog]
−
{{SubBox|Troubleshooting|
+
*[https://www.youtube.com/xlcubed XLCubed Video Library]
−
Useful pages for common support queries:
 
−
{{#dpl:
 
−
|category=Troubleshooting
 
−
}}
 
−
}}
 
−
|width=50% valign=top|
 
−
{{SubBox|Videos|
 
−
{{#dpl:
 
−
|category=Videos|ordermethod=firstedit|order=descending|count=7
 
−
}}
 
−
}}
 
−
|}
 

Latest revision as of 12:40, 19 August 2024

XLCubed Help **FOR LEGACY VERSIONS ONLY, to 10.0.157**. Rebranded to FluenceXL in May 23

XLCubed is an Excel add-in that allows users to quickly and easily create reports from various data sources, addressing the issues of Excel and extending its capabilities to deliver a powerful analysis, reporting and dashboard solution. Any XLCubed report developed in the Excel client can be published to XLCubed Web for easy access and distribution of data connected and interactive reports, respecting corporate security.

View the links below for guidelines on getting started with XLCubed, or see the list of all help categories.

Excel Edition

Connecting to your data

Adding a grid

Slicers

Calculations

Charting and Data Visualisation

Ranking, Sorting and Filtering

Formula Reporting

Web Edition

Web Publication

Web HomePage

Web Parameters

Multi-sheet Web Printing

PowerPoint export

SQL Repository

Scheduling

Other Resources

Videos

See all

Tutorials

Useful Links

Retrieved from ‘https://help.xlcubed.com/index.php?title=Main_Page&oldid=11215’