RSS Feed
Knowledgebase
This article refers to A La Carte Reporting suite 2011 ALC Cube Reporting Workshop 22 Oct 2012 covered the following topics: * Create a new Cube report from scratch (Variance Report) * Add Cube and Excel Calculations * Add and Amend Styles (...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Click here to download the document of Adjusting Column Widths [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s1885212f8ae4b24b
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document of Advanced Use - Create & Protect Multiple Cube Reports (in a single worksheet/book) [1] Links: ------ [1] https://excelinbusin...
ALC GALLERY FOLDERS Once installed there will be several folders in your GALLERY as well as each user having their own personal folder that only they can access (no other user can see or open reports/workbooks from your personal folder). Users will be ab...
INTRODUCTION By paging your report, you can limit the number of rows that the report will load at a time as well as what you can see on the screen. When creating a Cube or SQL report in ALC, which returns a large number of rows or columns, it is going to...
SAVING AN ALC REPORT WORKBOOK The entire workbook (and not just the report, dashboard or sheet) is saved using the save tool the A La Carte tab. There are two ways in which you can save an A La Carte workbook: TO GALLERY and AS STATIC. SAVING ALC REP...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. INTRODUCTION When creating an A La carte Cube Report you may want to add some comments to some specific area (specific data (cell) or heading for the specific select...
INTRODUCTION Using the A La Carte Reporting Suite you can save reports to gallery. The Gallery is a directory stored on the server where different users can save their reports, workbooks and dashboards. The benefit of using the gallery is that it allows ...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Confusion in the View Dimension document and Cube Reporter Helper: 'Annual Budget' - the total budget for the whole year = "Mvt Bud F/Y" so it appears alphabetica...
(Applies to A La Carte Financial Intelligence version 2013) In order to include the AUTO MAPPING facility in the scheduled Finance Cube Update, the Financial Intelligence module should be installed on the same server where the scheduled Update will...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 1) Open Up SQL Server Management Studio 2) Log Into Database Engine 3) Select the (your company)_FINI database 4) Right Click -> Tasks -> Back Up... 5) Bro...
(Applies to versions of A La Carte Financial Intelligene and Reporting 2011, 2013) Click here to download the document on Basic use of Cube Report Format & Styles [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s71825e6a05944ee9
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the Basic use of standard Cube Reports Document [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s11574227e1946e58
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Click here to download the document of Basic use of Tabs or Ribbons in Excel [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-scb23c6473a245a38
(Applies to versions of A La Carte Financial Intelligence 2011) The following step-by-step instructions are to upload a version of Budgets or Forecasts by posting code in the rows and by periods for a selected year in the columns. The template for t...
(Applies to versions of A La Carte Financial Intelligence 2011) ALC FINANCIAL INTELLIGENCE: IMPORT BUDGET SPREADSHEET EXPLAINED * The best way to capture new budgets from scratch (client needs ALC access) with interactive views of actuals and e...
There are a few things that need to be considering when importing a budget or forecast into A La Carte: * the company code assigned to each of your companies which can be found in the company list under the finance tab (listed as Cxxx such as C001,...
When uploading budget or forecasts into Sage they will, by default, be applied to the year that is currently open. For example, if you uploaded a budget intended for 2014 but before the 2013 year was closed then A La Carte would read this budget as ...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) The following process is used to change the title (as well as rename the Column Headers) Select the TITLE CELL, (or in the case of a column header, the cell of co...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. Click here to download the "Changing Drill to Detail Layout" document. [https://excelinbusiness.sharefile.com/d/se15de2a3c024103a]
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Date fields are displayed in a confusing format in SQL reports. To overcome this issue create a calculated field using this formula: convert(varchar,_SourceDateFiel...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) NOTE: THE BELOW ONLY APPLIES TO BUDGET VARIANCES TAKEN FROM EXISTING CUBE DIMENSIONS (E.G. VAR C/P), MANUALLY CREATED VARIANCES MUST BE CORRECTED IN THE CALCULATION ...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the Cube Process Options document [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s7f904bd90434bcfb
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. Click here to download the "Publishing & Opening a Cube Report Definition" document. [https://excelinbusiness.sharefile.com/d-sfd5b52ad08e496bb]
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) You run a report based on a Finance Statement that was working before. The Report Validation Errors window comes up - why? In short - it only appears when something ...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the instructions to create an Actual Budget Outlook report [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s8eac8c8356a4d76b
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 This Document is designed to help you build a report from the "Report Layout" panel in Cube Reporter, explaining when/how to use: * Current Period Concept (from t...
(Applies to A La Carte Cube Reporting 2011, 2013 - Finance Cube) The Finance Cube's View dimension and hierarchy contains fairly cryptic names. Data View members are relative to selected accounting period - actual / budget, movement / balance / ave...
Distributions copy and paste a significant amount of data. When running multiple distributions this can create an Issue if you are connected to your A La Carte application via Remote Desktop (RDP). When using RDP by default it splits the clipboard b...
Q: WHEN I AM CHANGING THE FORMAT AND I PUBLISH - DOES IT DO IT FOR ALL REPORTS OR JUST THE ONE I AM WORKING ON? A: All your reports currently have level based formatting applied so any changes made to the default formats i.e. rowlevel1,2,3 etc which...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) When the SQL server is shut down and restarted, Analysis Services does not automatically restart - it needs to be done manually. It may only become apparent when a u...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) When updating a statement design or updating a cube, the "progress form" (dialogue box) for this task can get stuck behind Excel, causing what seems to be a crash th...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document of Explanation of Standard & Trail-Ballance Reports [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sf19ac87b30f45...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) If the Reporting Database option under the Finance tab/ribbon is grey it means the connection to the server is lost. Before contacting your IT department, the A L...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Process to add new COA Analysis groupings (: all activities from the FINANCE tab) > > > > > > > > > > > > > > > > IMPORTANT NOTES BEFORE EMBARKING ON THE COA ANALY...
For those using ALC Financial Intelligence 2011: Click here [1] for the Overview Click here [2] for the Checklist Click here [3] for the Detail For those using ALC Financial Intelligence 2013: Click here [4] for the full document Clic...
When creating calculation lines in the Statement Designer there are a few things that need to be considered to ensure that errors are not encountered. 1) Once the Chart of Accounts has been applied it is important to remember that, when creating ...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Within the A La Carte Financial Intelligence, Statement Designer - formula for the P&L checksum. As part of the recommended Period End Process and to facilitate Pro...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 The linked document explores the specific task within A La Carte Financial Reporting and Period End Processing that involves Adding a missing post code to the statemen...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 When the base Financial database(s) (Sage) are not on the same server where ALC is installed, the Cube Update (load) process fails. Here are instructions how to configure th...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011 & 2013) When multiple companies have been added and yet do not share a common calendar this can cause errors with balances (mainly opening) as well as impact those months t...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document on How to Add & Remove from a Cube Report [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s69a0b6748c34e13a
Applies to versions of A La Carte Financial Intelligence an Reporting 2011, 2013. Click here to download the document on How to add your own styles to A La Carte [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sff3491f1c4d41c1b
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) HOW TO AVOID CLIPBOARD ISSUES WITH TEAMVIEWER Step 1 - From the Teamviewer Home window, Select Extras | Options Step 2 - Select Advanced | Click on button "Show adva...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) This article will outline the steps required to create a shortcut to a workbook in the A La Carte Gallery. STEP-BY-STEP * Right click on the desktop and selec...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) It is possible to change what fields are displayed and rename the headings for the Transaction Listing when you drill through to transactions from an Actual (movemen...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. INTRODUCTION The Periods Names are uploaded directly from SAGE / Shipnet. However, if you wish to change them into more meaningful names for you, you may do so in A L...
(Applies to versions of A La Carte Financial Intelligene and Reporting 2011, 2013) Click here to download the document on How to Copy Criteria to Dashboards. [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sb6771fe4cbd4e819
Applies to versions of A La Carte Financial Intelligence 2013, 2014 (but is based on ALC 2014). To download the Aged Debtors/Creditors Report Document click here. [https://excelinbusiness.sharefile.com/managefolder.aspx?id=fo044f48-2d3b-44b6-81c1-b53dec...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) This article explains 2 commonly used SQL reporting capabilities: multiple listings in a single worksheet or -book and grouping data (by column). Click here to do...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document on How to create or add a calculation or formula in Cube Report [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sa...
Applies to versions of A La Carte Financial Intelligence 2011, 2013 Click here to download the document of How to Perform a Manual Cube Update [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s674069e2df74c4d8
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) (note-As with Excel, any A La Carte calculation that divides by 0 will cause the result to be "infinity" - better than earlier Excel releases when it either simply c...
To raise a ticket, you can either click here [http://excelinbusiness.kayako.com/Tickets/Submit] or select the GET HELP section from the A La Carte tab followed by selecting SUPPORT. A La Carte will take you to the entry page of the support site. If you ar...
When creating a new Cube Report, you may notice that when selecting a particular member for the columns in the Report Layout Designer, the columns automatically autofit to the width of what is in that column. To remove the autofit function: * From th...
Applies to A La Carte 2013 & 2014 Depending on whether you require an item to be renamed permanently or just temporarily there are different options available. The usual method is to publish a renamed name to the gallery (global change). This item (ty...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document on How to rename things in Cube Reports [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sf5c32055e0342b7b
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) If an A La Carte ribbon disappears from Excel, here is a possible method to retrieve it after Excel has had a problem of whatever kind - Inside Excel do the follo...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document on How to save a Static Report [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sfbf9740d56b492da
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document on How to Submit a Help and Support ticket [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s48f72dc539446858
If you find that your Cube Report has blank rows, like below, by using the zero suppression function, it will remove the empty rows. * On the "Cube Report" tab, click on "Filter" located in the "Filter, Sort & Total" section. * From the dropdown,...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download document on How to use 'Vlookup' to get data from Cube or SQL Report. [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s33e2eecb...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) NOTE: SOME BASIC CUBE REPORTING KNOWLEDGE IS REQUIRED. There are TWO types of calculation which can be inserted into ALC Cube Reports, and each should be used in ...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 with the product number 2013.1.1.15 or greater. If you are interested in using organisation structures and require an update please contact us. Please click here to downl...
Applies to A La Carte Financial Intelligence 2013 This document below explains and describes the load process to get budgets, revisions or forecasts in to the Finance Cube in A La Carte Financial Intelligence. Click here to download detailed docu...
(Applies to versions of A La Carte Reporting Suite 2011, 2013) NOTE: SOME BASIC KNOWLEDGE OF CUBE REPORTING AND REPORT DISTRIBUTION IS REQUIRED TO UNDERSTAND THIS ARTICLE. E.G. YOU MUST BE AWARE OF CRITERIA AND HAVE BUILT AT LEAST ONE DISTRIBUTION P...
There are 2 ways in which you can insert a calculation into ALC Cube Reports. Excel Calculation: This type of calculation allows you to insert any standard/native Excel formula into an inserted row (or column). This calculation is then aggregated acro...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) If your A La Carte install was implemented after 01/01/2012 you should have this document on your server with all other necessary files for a client installation on ...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Please click here to download the PDF document covering Financial Reporting and Period End Processing for 2011 [1] Please click here to download the PDF document ...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Click here to download document on Linking Reports-Basic Cube to Cube (Same Dimensions) [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-se4a085bec5e4cbd...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Click here to download document on Linking Reports-Basic SQL to SQL linking (Same Dimensions) [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s26ae7adf6...
Applies to all versions of A La Carte when migrating servers. When migrating A La Carte accross servers, depending on the naming convention in place it may be necessary to redirect Analysis Services to look at a different source. For example, this is li...
This article refers to A La Carte Reporting suite 2011 & 2013 ------------------------- When creating a Cube or SQL report in ALC, which returns a large number of rows or columns, ALC will sometimes page this report. This means that not all the dat...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the explanation of navigating/changing and setting defaults in A La Carte [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s6666...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Before a new user can see or use the supplied standard A La Carte report workbooks and other options, you need to assign him/her to the correct ROLE in the Server Ad...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 Click here to download the document of Opening/Saving (publishing to Gallery) A La Carte reports [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s771a99...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. By paging your Cube Report, you can limit the number of rows that the report will load at a time as well as what you can see on the screen. Clicke here to download t...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document of Period End Processing - Checklist [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s57e1c7ea88e4b17b
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the Document explaining Period End Processsing with an overview flow diagram [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s7...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document of printing (settings) in A La Carte report [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-sec987dab12c4e53a
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) If you are having to log in/have an error appear saying that A La Carte cannot find your server everytime you open a report, this means your Analysis services OLE is...
Applies to versions of A La Carte Financial Intelligence 2013 and 2014. You must first have opened and logged into your Reporting Database ('Finance' tab-> 'Reporting Database'-> 'Open'; select database and enter password). * In the 'Finance' tab, sel...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Click here to download the document of Profit & Loss standard reports - Criteria, Columns, Rows [1] Links: ------ [1] https://excelinbusiness.sharefile.com/d-s83d12...
(Applies to versions of A La Carte Reporting Suite 2013) If you have renamed a column or row member in your ALC report, you are able to publish this name in ALC. By publishing the name, you are renaming that member for all existing and future report...
Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013 BACKUPS ARE CRUCIAL! A La Carte information needs to be backed up regularly to safeguard the Reporting Cube(s) and it's intermediate data and even more importantly...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) If you wish to change the OLAP cube which your current report is connected to follow these steps: (Be wary of top level formatting and Blank rows and columns when...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) DRILLDOWN is available on all cube dimensions in the rows/columns that have a structure over them (eg centre hierarchy: countries into into counties into sub regions...
Applies to versions of A La Carte Financial Intelligence and Reporting 2013 and 2014. To reset the drill to detail, you need to have a data cell selected on your cube report. On the CUBE REPORT tab click the 'LAYOUT' button and then click 'CUSTOMIZE ...
There may be occasion when working with data values in your reports that you are required to show values as thousands (with a note to that effect shown somewhere on the report). As with native excel, this is achieved by applying a custom format, howeve...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) This article outlines how you can set-up and use a workbook where the Save prompt message is disabled on workbook close. This will give your reports a more professio...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) To make your analysis services module on SQL server http connection ready follow this MSDN guide: http://msdn.microsoft.com/en-us/library/gg492140.aspx [1] Once t...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) Q: WHEN DO I SAVE, WHEN DON'T I SAVE? A: If you make a change that you want to keep next time you open the report i.e. Criteria change or add a new member to the ...
This article refers to A La Carte Reporting suite 2011 & 2013 ------------------------- When the A La Carte Gallery gets too "untidy", you may want to delete some reports and / or make an 'archive' folder to move some old reports into. ** WARNING...
(Applies to versions of A La Carte Financial Intelligence and Reporting 2011, 2013) This article outlines the steps how to set up a group & outline report to automatically drill to level n on open. PRE-REQUISITES In order for the Auto drill do...
Most popular articles 
 
Newest articles