BiXAnalytics

BiXAnalytics designs and publishes your reports and dashboards with ease.

It runs in Excel and follows the same standards as your spreadsheets, enabling fast learning curve for all user levels.

You are guided by assistants throughout the design or refresh of your reports and always benefit from the full Excel feature range.

BiXAnalytics brings autonomy to users across levels and line of business. Controllers, Analysts, Directors of Sales, Heads of Marketing or Supply Chain Managers can all benefit from instant indicator access, analytics capabilities and easy publishing.

You are empowered to apply your business logic while keeping underlying cube integrity intact thanks to the definition of calcs and report template within BiXAnalytics without touching the cube structure. You also gain consistency by leveraging BiXAnalytics powerfull tool set and avoiding getting into complex and error prone cell based spreadsheet developments.

Reporting Efficiency is dramatically improved from start to finish. You can leverage templates you created for each new analysis. Report refresh and filtering is made seamless with dropdown selectors for the dimensions of your choice. Publication of your analysis to spreadsheet or a web page is then just 1 click away.

No more repetitive copy-paste, vlookups or complex macros. Your documents are kept lean and accurate and flexible to accomadate the constantly evolving requirements of your job.

BiXAnalytics leverages user-defined “Infosets” where you choose the point of view and the information set you want to analyze or report from in your spreadsheet.

Your data now safely lives in Excel. Dataset selection can either be static, dynamic or controlled as you open the document. Datasets can be enriched with comments, formats and also write-back to cube when granted access.

As you refresh or expand selections, Bix never overwrites your formulas, or comments and makes room by inserting rows and columns if needed.

Your formulas and filers are not based on fragil cell references but leverage solid cube logic for fast and sustainable calcs.

You can also work with several Infosets at the same time. This innovative feature empowers you to bring together information from different aspects of your business within one single spreadsheet and connect data together to deliver breadth and depth in your analysis.

Readers will then access the reports you built without any technical prerequisits and just browse through your documents naturally.

With BiXAnalytics, your reporting becomes simple, intuitive, reliable and efficient.

BiXWeb

BiXWeb takes BiXAnalytics power to the web.

With BiXWeb, you can easily build your reports in your favorite browsers (Internet Explorer, Firefox or Google Chrome).

As you navigate through your data, you can also add your own data and write back to the cubes within a secured framework.

Your Excel or web documents can then be made available in a web portal for instant and secure reporting.

BiXPublisher

Automate your reporting process with BiXPublisher

BiXPublisher is the perfect companion for BiXAnalytics. It automates the internal or external distribution of your reports and dashboards. Publication can be made in several media types, such as printouts (booklets, memos…), web pages on a portal, emails to targeted consumers, PowerPoint, etc.

BiXPublisher also provides mechanisms for automating repetitive publishing tasks either controlled by the user or by a task scheduler.

 

BristolReport V6

We are pleased to announce the official launch of a new  MAJOR version (V6) of BristolReport.

Two completely new modules enrich BristolReport offering. The attached document details the innovations and improvements in this new version.

In summary, gere are some of these innovations :

  • Bristol FormatDesigner (the first new module) to format your reports exactly the way you want
  •  The Axis Selector (the second new module) to filter multiple dimensions at once. It takes the ease and power of the existing dimension selector to extend filtering capabilities of BristolReport
  • Parentheses in the selector to impose evaluation order filters
  • “External” Selections: new filtering principle to garantee consistency of all states of reporting
  • Totals, subtotals and grand totals as a single option box
  • Comments related to data
  • Calculations on named filters
  • Document Calculations
  • The List display mode
  • etc…

All this improves as well the ease of daily use and addresses the needs of the most advanced reporting.

We thank all our customers who participated in the Beta program BristolReport 6 and tested this version in their environments.

MC DONALD’S

BristolDecision, Business Intelligence and Reporting Performance ISV, announced that the group of fast food McDonald’s chose BristolReport to analyze and distribute its financial information.

Established in France for over 25 years, McDonald’s employs more than 44,000 people under his banner. McDonald’s serves an average of 1.2 million customers every day in 1085 restaurants in France, including 860 franchises. In 2006, VAT total sales in the McDonald’s France amounted to 2.7 billion euros.

When the group decided in 2007 to strengthen its analytical tools to retain only one solution in its various financial departments, the choice is Microsoft Analysis Services, introduced by the IT Department for sales analysis, purchasing and payroll, a few years ago.

If data consistency justifies this choice, financial services demanding better reporting of results in Excel, as did their former financial analysis tool. After market research of reporting solutions that work with Microsoft Analysis Services and restoring data in Excel, the choice is BristolReport.

“BristolReport is known to be the most efficient product on the market for reporting in Excel,” says Alain David, Head of Controlling of McDonald’s France.

BristolReport was chosen to bring in one document information from Group multiple Financial cubes: company restaurants finance, overhead, franchise network cost of real estate, consolidated finance and finance group of restaurants and mid-group and mid-franchises restaurants. The documents will then be posted on the Intranet and each may, depending on its needs, extend his analysis in Excel.

“The advantage of BristolReport is that each user can create new key performance indicators (KPIs) to meet its analyzes and compare data from multiple cubes in different fields,” says Josine Seramy, Project Manager at McDonald’s France. “The old tool used by controllers do not allow this or only for very experienced power-users. We won in functionality and ease of use, “added she.

More complete, BristolReport can provide a multidimensional view overall all fields, which will be available later for management.

Originally intended to finance teams, BristolReport use was extended to Business Analysis Measurement Department to analyze sales and impact marketing operations. Comprehensive reports will soon be provided to Heads of Product Marketing.

Payroll administrators also use BristolReport to analyze payroll and will be able to refine their analyzes themselves, without relying on IT. Pay Sensitive data will be kept in the service, for more privacy.

In total, one hundred users receive BristolReport licenses.

Trained in January 2008, the Business Analysis Measurement people are the first to use BristolReport. Payroll administrators will be trained in April 2008 and the controllers and financial analysts in May 2008.

AUCHAN

Auchan chooses BristolReport of BristolDecision as multidimensional reporting solution for financial controlling project of the Holding Auchan.

BristolDecision, BI analysis and reporting of performance ISV, today announced that Groupe Auchan has chosen BristolReport for Excel solution as multidimensional analysis and reporting for AUCHAN financial controlling project.

Family business unlisted Auchan has a policy of gradual and controlled international growth, and focuses its investments on priority development areas: Western Europe, Central Europe and East and Asia. Auchan has 296 hypermarkets in 12 countries or regions.

In 2007, Auchan Department of Business Intelligence has conducted a review of technical choice to select a front multidimensional analysis solution for Microsoft Analysis Services 2005. The choice was made on BristolReport to Excel for group financial controlling project in addition to Microsoft ProClarity for other projects requiring web deployment.

BristolReport to Excel has been very effective against other solutions on the market aspects, as follows :

  • Its seamless integration into Excel
  • Its overall simplicity of use
  • The possibility of producing asymmetric reporting
  • The ability to create reports from multi-cubes and synchronize dimensions from different cubes with each other

Financials controllers like the Excel interface but enjoy as much autonomy with which they can handle BristolReport to create their own indicators.

SAS

SAS announced the porting of the BI Analytical Reporting solution BristolReport on SAS® OLAP Server

Offers complementary to better take advantage data from SAS® OLAP Server

SAS, the leader in business intelligence, today announced the porting of the BI Analytical Reporting solution BristolReport on SAS® OLAP Server directed by BristolDecision, with the support of SAS.

All features that make the originality of the solution BristolReport on OLAP databases are now available on SAS® OLAP Server. At the forefront of these features, especially appreciated by users for their ease of use :

  • Design business reports and advanced analytics from one or more SAS ® OLAP cubes
  • Selection or multi-step filtering by successive refinements
  • User definition of new metrics or KPIs

“This complementarity between our two offers is part of the new strategy of openness of our society,” said François Koukerdjinian BristolDecision CEO. “We are very pleased with this partnership with SAS, a recognized leader in the business intelligence market. Existing and futures users of the SAS platform will benefit from the added value of the BristolReport solution.”

“The integration of Bristol Report on SAS® OLAP Server platform demonstrates the openness of the platform that meets the standard MDX OLAP market. This integration will provide our customers with additional capabilities for advanced reporting in Microsoft Excel for users as analysts profiles who need to assemble indicators developed from several data marts. It also allows BristolReport users to benefit from a powerful OLAP technology and portable to Windows, UNIX, Linux and OS/390,” said Marcel Lemahieu, Head of SAS BI.

Philippe Nieuwbourg interview

Does it remain a place for a Reporting Independent Software Vendor?

We talk about it with François KOUKERDJINIAN, BristolDecision CEO.

BristolDecisions plays Gaulish village. But a Gaulish village who speaks internationally and has already begun to win customers located in many countries. Yes, there is a place on the market of reporting tools, clearly explains François Koukerdjinian. And he knows about Business Intelligence! Those who already have some gray hair will remember he was working already in BI in the 80s when the star of the time was called IRI Software, PC Express which became Oracle Express. But BristolDecision is far from the archaic references. The product is currently one of only compatible tools with five major BI platforms structuring the market in 2008, and its editor now opens the door for open source.

Philippe Nieuwbourg

BristolReport and the five major OLAP engines

BristolDecision, Analysis and Reporting ISV, announces porting BristolReport on the five major OLAP engines.

After the recent consolidations of the BI market, OLAP engines are now concentrating on five platforms (in alphabetical order) IBM, Microsoft, Oracle, SAP and SAS.

BristolDecision is pleased to announce the availability of BristolReport on all these platforms. “All the innovative features that our users appreciate, such as the simple design of unsymmetrical reporting, multi-step filtering, data definition on the fly, when necessary, of new KPI, and finally, the wide diffusion capacity of these reports are now available for all OLAP servers. BristolReport optimizes queries generated based commands supported by each OLAP servers”, says co-founder BristolDecision.

In addition, it is now possible for a user connected to different platforms depending on the nature of the consulted information (Finance, Commercial, HR, etc.) to have a single interface to access information. In addition, in case of the migration of the BI Ingormation System from one platform to another, the user retains the same reporting software. This facilitates change management. This new version of BristolReport becomes the universal OLAP reporting solution that addresses end user to bring him autonomy and responsiveness.

The first tests running on Mondrian also seem promising.

ANPE

BristolDecision, a Business Intelligence ISV, announces that the National Agency for Employment has chosen BristolReport for his Study services and Activity Controlling. The ability to bring together data from multiple cubes, multi-stage filtering and aggregating demand, data from several employment areas, were key factors in this choice.

ANPE used for several years Business Intelligence technologies. Thus, the BI Information System is responsible for providing management tools for all levels of management at ANPE, from the Agency Director to the General Directorate, meaning 4500 users .

In 2005, those responsible for the DSS seek a solution to be more responsive to the growing demands of its users, instead of its internally developed solutions. The SAS BI solution is chosen, which will facilitate the rapprochement with Unedic foreseen in the program of the current government, as Unedic is already provided of SAS solutions.

However, if this solution is ideal for executives ANPE additional needs remain unfulfilled in terms of studies and further investigation on the part of some services at Headquarters, Regions and Departments. Thus the intersection of data from multiple OLAP cubes was necessary to better understand ANPE network activity, its results and achievements.

After reviewing several solutions, the solution BristolReport is retained by a panel of thirty users, representative of the entire target.

Our users have been immediately seduced by the possibility of reports with data from different multidimensional cubes in BristolReport with ease. In addition, the tests showed our viable performance over 200 million records (forms job seeker service, Job …). With this tool, our controllers, the project managers of departmental directorates and regional audit service, will cross the data to the finer analysis of actions ANPE,“explains Pascal Durand, project Head of the management project of the control system. “The installation is simple: just connect BristolReport with SAS BI and the tool works. We derive the benefits immediately.

Thus, all target users from ANPE (analysts, statisticians or controllers) can use BristolReport from February 2008, date of production.

BristolReport can build reports with business intelligence management controller,” adds Paul Vidal, Director of DSS.

We are pleased that sophisticated and demanding users choose the solution BristolReport, after reviewing and comparing several solutions on the market. This shows  the advance of our solutions, fruit of an ambitious program of innovation and R & D“, says François Koukerdjinian, cofounder of BristolDecision.