PROFESSIONAL EXPERIENCE:

Confidential

Implementation and Financial Transformation Lead

Responsibilities:

• Focused on Financial Reporting, Consolidation and Financial Planning.
• SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience working with SAP BPC MS versions.
• Global Deployments in different Continents in both Planning and consolidation.
• Deployment of Analysis for Office and EPM Add - In for Embedded Model of BPC, and migration to SAP HANA Optimized in progress.
• Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1 and SAP BPC 11.
• SAP BPC Security on SAP BW, Test Scripts,, Citrix Deployment using BOBJ Data Repository.
• Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.
• VBA and BPC customizations for dropdowns, save, prompts, complex calculations for labor and capital, multiple selections, queries with multiple selection of merge variables, complex workbooks, with multiple aggregation levels, copy functions.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for BPC Planning, Workbooks, VBA code for BPC, Planning Functions.
• Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold, Cost of Sales, P&L, B/S reporting, and architecture design and integration with Japanese Operations.
• SAP BW DTPs, Data Transformations, Mappings, conversions.

Confidential

Implementation and Financial Transformation Lead (EPM/HANA Architect)

Environment: SAP EPM 10.0/SAP BPC 10.1 on HANA with BW4 with SAP ECC S/4.

Responsibilities:

• Focused on Financial Reporting, Consolidation and Financial Planning.
• SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience working with SAP BPC MS versions.
• Global Deployments in different Continents in both Planning and consolidation.
• Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC.
• Migration of SAP BW Tax data to SAP HANA and included as part of the SAP
• Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Reporting, Consolidation and Planning.
• Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial Consolidation, Investments: short-term and long-term debt, Balance Sheet Planning, Income Statement, and others.
• Planning and Consolidation project, with global in different locations onsite in Europe and USA.
• Development of BEx queries, workbooks, key figures and variables, DTS, QDPs, Info Providers, ODS, Composite Providers, Info Cubes, Multicubes.
• Reports using Crystal Reports, Dashboards, WEBI, Analysis for Office, and direct connection of MS Excel to HANA platform.
• HANA migration and enhancement of reporting:
• Update of S/4 HANA Reporting using BOBJ, Crystal Reports, and Web Intelligence.
• Update of SAP HANA from SP06 to SP12 for Graphical Views.
• Working with SAP HANA security and Analytic Privileges
• Creating and enhancing Analytic, Attribute, and Calculation Views for BOBJ4 reporting using Universes.
• Creating customized calculations using SQL, Calculation Engine and SAP HANA Expression Editor.
• Creating Decision Tables for Sales Analysis and Discounts
• Replicating SAP ECC tables into HANA, and enhancing and combining SAP BW cubes (migrated to SAP HANA) and Third-Party sources into the same Calculation views.
• Creating Input Parameters and calculated values on the fly.
• Transporting SAPHANA objects between systems.
• Integration with SAP BPC for master data on the fly replication from SAP ECC, and alignment with the SAP EPM Embedded model.
• Migration of SAP EPM 10 to 10.1 on HANA objects.
• Replicating SAP ECC data into HANA and exporting into SAP BW for reporting.
• Data provisioning replicating SAP ECC data into HANA using SLT, and working with BW on HANA to enhance BW cube information and combine it with HANA Calculation Views.
• Working with Analytical Views Join, Aggregation, Projection, and Union for SAP and Non-SAP data.
• Extensive reporting using the Universal Journal and ACDOCA to combine analysis of CO-PA, Assets, FI, CO, and Statistical Journals in order to provide real time financial reporting.

Confidential

SAP BPC NW 7.5/SAP BPC 10.1 Lead/with HANA integration

Responsibilities:

• SAP HANA design and migration from previous SAP BPC 7.x platform to SAP BPC 10.1, to migration and conversion to SAP HANA.
• Development of SAP BW cubes for Tax data, and migration into SAP HANA.
• Conversion and redesign of SAP extractors based on SAP Simple Finance, and the requirements changes for S/4 HANA.
• Development of Analytical Views, tables, Attribute Views, Calculated Views.
• Working with SLQ Script and Projections in data merging of views for Actual and PBF data.
• BPF: definition of process templates, activities, activity performers and activity reviewers, working and configuring process instances and tasks. Deploy Hyper Links for Planning and Consolidation scenarios, and as part of month-end closing. Working with Actions after expirations and deadlines, and linking BPFs with Work Status updates, and deployment and trouble shooting. Setting up Reviewers and Owners logic following BPC security. Attaching Data Management Packages, Reports, Input Templates, to improve and control and monitor the planning and consolidation process for year end.
• Modeling of HANA Live Views and reporting based on customized HANA models in SAP BO Web Intelligence and SAP Lumira and analyzing in IPad (mobile devices).
• Working with SAP Business Suite on HANA with predefined HANA Live views and creating real time operational report based on HANA views.
• Integration with SAP BPC EPM10 and SAP S/4 HANA with Simply Finance Implementation.
• Working and developing Private Views, Reuse Views, and Query Views.
• Reporting using SAP Lumira, Universe Designer, Bex queries, and Crystal Reports.
• Data modeling and ETL design integration with BW, SAP EPM 10 and HANA using SAP and non-SAP data sources.
• SAP BPC NW 10 and 10.1 upgrade preparation activities due to improvements in functionality, and improved stability in the system performance.
• Blueprinting and requirements gathering. Interaction with Planning, Consolidation, Forecasting, and Consolidation.
• Security Roles, Task profiles, and User Security.
• Migration of legacy systems into SAP BPC NW 7.5 Planning, Budgeting, Forecasting, and Consolidation, preparation to migration for SAP BPC NW 10.
• Allocations, custom script logic, Dynamic Parameters, and lead role of BADI development for burdening, allocation, and distributions.
• Finance model design for Cost Center/WBS/and Orders.
• Lead Architect, Blueprinting, Assessment,, and deployment to include Consolidation and Management Reporting environment.
• Integration of SAP BI/ SAP ECC, Inbound and Outbound legacy systems such as UI Planner, Hyperion, Reval, Power Plant.
• Focused on Financial Reporting, Consolidation and Financial Planning.
• Migration of financial reporting from Legacy into SAP BPC NW 7.5/BPC NW 10
• Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial Consolidation, Regulatory Reporting (FERC), Investments: short-term and long-term debt, Balance Sheet Planning, Cash Flow, Income Statement, and others.
• Dual Reporting in US GAAP, IFRS, and Common Accounts.
• Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.

Confidential

SAP BPC NW Lead and Migration from SAP BPC 5.1 to SAP BPC NW 7.5

Responsibilities:

• Migration of financial reporting from Legacy and SAP BPC 5.1 to SAP BPC NW 7.5.
• Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.
• Script Logic development of custom programs.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Assessment, Blueprinting, and migration path from SAP BPC 5.1 to SAP BPC NW
• Hierarchies, G/L account groups, SQL updates to SAP BPC 5.1 database commands, and SAP BPC NW 7.5 upload, transformation, and loading.
• Reports, EVDRE, report migration from SAP BPC 5.1 to SAP BPC NW 7.5.
• Journal Entries, and top side adjustments
• Currency translation and adjustments
• Consolidation, Budgeting, Forecasting, and Planning.
• Integration with third party systems and migration design to SAP ECC and SAP BI
• Capital Expenditures (CAPEX), Operational Expenditures (OPEX), Production Planning (PROD), Overhead and Cost Center Planning, Rolling Forecast.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Income Statement, Balance Sheet, Cash Flow design for SAP ECC and EVDREs.

Confidential, North Carolina

SAP BPC Lead

Responsibilities:

• SAP BPC NW 7.5 upgrade due to improvements in functionality, and improved stability in the system performance from SAP BPC NW 7.0.
• Lead Architect, Blueprinting, Assessment,, and deployment for 40 business units in 30 countries, to include Consolidation and Management Reporting environment.
• Focused on Financial Reporting, Consolidation and Financial Planning.
• Complete migration of financial reporting using Business Objects and SAP BPC from legacy environment with reports such as: Shareholder’s Equity, Cash Flows, Income Statements, Balance Sheet, Intercompany, Budgets, Statement of Operations with monthly, variance, and YTD values, Management Reporting, Profit and Cost Centers, using Period and Calendar Reporting and others.
• Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.
• Development of input schedules, templates, DTS packages, upload and download programs, scripts, EVDRE Reports and Dynamic templates, Application Sets, property and member maintenance.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.
• Capital Expenditures (CAPEX), Operational Expenditures (OPEX), Production Planning (PROD), Overhead and Cost Center Planning, Rolling Forecast.
• Transition from a multiGAAP to a IFRS as secondary reporting applying adjustments to the base data automatically to allow the dual reporting and changes stored in the same application set.
• Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.
• Currency Translation Adjustments (CTA) and interaction with Ernst & Young, and Deloitte as internal and external auditors to match their recommendation on financial reporting, due to the current limitations of their different Legacy Systems on financial visibility, accuracy, and transparency.

Confidential, Ohio

SAP BPC/ Business Objects Corporate Lead Architect

Responsibilities:

• Lead Architect, Blueprinting, Assessment,, and deployment for 60 business units in the mining, exploration, and coal extraction.
• Focused on Financial Reporting, Consolidation and Financial Planning.
• Sales and Operational Planning (SOP) and using SAP CRM extractors using trade promotion management (TPM), Bdocs, and SAP BW Adapter.
• Complete migration of financial reporting using Business Objects and SAP BPC from legacy environment with reports such as: Shareholder’s Equity, Cash Flows, Income Statements, Balance Sheet, Intercompany, Budgets, Statistical Key Figure reporting, Statement of Operations with monthly, variance, and YTD values, Sales and Cost Planning by G/L Account, Profit and Cost Centers, and others.
• Transformation, Conversion and Loading files, and G/L Account conversion and migration.
• Financial and Operational Planning, which includes CAPEX, OPEX, Revenue Planning, and Cost Center Planning.
• Development of input schedules, templates, DTS packages, upload and download programs, scripts, EVDRE Reports and Dynamic templates, Application Sets, property and member maintenance.
• IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports. Working on US GAAP Joint Venture reporting and IFRS modifications for revenue recognition, capitalization of intangible assets, inventory valuation, and service contracts based on percentage of completion basis.
• Transition from a multiGAAP to a IFRS as secondary reporting applying adjustments to the base data automatically to allow the dual reporting and changes stored in the same application set.
• Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.
• Development of Business Objects Universes, Xcelsius Dashboards, and Web Intelligence Reports. Queries and architecture design from SAP BI Cubes and BEx reports, Slice and Dice, Cross-Tab and Tabular Views, Tree Control, Data Provider Viewer, Hierarchies, Attributes, Universe Designer, Web Intelligence Reports with Time Dependencies, Single Sign On, reports and subreports in Crystal.
• Security, teams, roles, user ids, SAP BPC Web, BPC Excel, Word and PowerPoint interfaces.
• Design and Accessing BOBJ Universes from BI, Xcelsius, Query as a Web Service, Crystal Reports, Web Intelligence.

Confidential

SAP BI/BPC 7.0 SP03 Global Lead Architect

Responsibilities:

• Lead architect, Blueprinting, Assessment, Manuals, and Business Units evaluation of planning methodologies.
• Financial Planning and Consolidation Activities.
• Development and implementation of SAP BPC 7.0 Net Weaver Platform with SAP BI 7.1
• Corporate Analysis of current phasing out technologies and planning strategy with more than USD in cost savings in the first 2 weeks of work.
• Global planning of SAP BPC Global Architecture for Marketing, Mining, Refining, and Extraction Operations of Stainless Steel, Diamonds, Titanium, Aluminum, Oil, Iron Ore, Gold, Silver, and Uranium in South Africa, USA, Europe, Australia, and South East Asia.
• CAPEX,OPEX, Planning and Forecasting models, depreciation and tax planning.
• Design of Security Architecture, Process Mappings,, Dimension Logic, Web Reporting, EVDRE Reports, Formulas, Application Sets and Application Development, Blueprinting, and Scripts.
• Sales and Operational Planning (SOP) and using SAP CRM extractors using trade promotion management (TPM), Bdocs, and SAP BW Adapter.
• Cube Extraction, Validations, Transformations, Conversions, and Installation Review.
• IFRS/USGAAP Under IAS 16 adjusting differences in asset componentization guidance to track and account for property, plant and equipment at more disaggregated levels.
• Integration of M&A Transactions to easily be part of the dual reporting process.
• Separation of the load processes using IFRS loads and USGAAP in two separate Charts of Accounts in order to allow the dual reporting, and the adjustments of the G/L accounts.
• Input Schedules, EV Functions, Budgeting and Forecasting, Visual Basic Buttons, Currency Translations, Balanced Sheet, Income Statement, Cash Flow, Excel and Advanced Logic, Process Chain Data Manager Packages, EBooks, Journal Entries, Working with the new SAP BPC NW 7.0 Planning and Rate ApptSets, Master Data Extraction from BI into SAP BPC using both custom procedures and standard functionality.
• Development of Business Objects Universes, Xcelsius Dashboards, and Web Intelligence Reports. Queries and architecture design from SAP BI Cubes and Bex reports, Slice and Dice, Cross-Tab and Tabular Views, Tree Control, Data Provider Viewer, Hierarchies, Attributes, Universe Designer, Web Intelligence Reports with Time Dependencies, Single Sign On.

Confidential

SAP BPC Consultant

Responsibilities:

• Initial Product Evaluation and Assessment: includes blueprinting, architecture design, requirements gathering, and communication of ASAP and SAP BPC implementation methodology to users, managers, and developers.
• Blueprinting, requirement gathering, product specification, security design and roles definition, integration with SAP BI.
• Reporting and Legal Consolidation that includes Currency Translation, Live Reporting, Web Reporting, Security
• Definition of application sets, Formulas, Dimension Logic, Data Manager (DM)
• BPC for Excel, Word, and PowerPoint
• End-user, development of EVRE reports, and scripts, dimension and worksheet logic.
• IFRS 8 reporting using Segment Reporting for different vertically integrated operations, applied to debt or equity, applying multidimensional views of financial statements.
• Consolidation of non-Balance Sheet Entities, and modification of Income Statement, Cash Flow, and Balance Sheet. Business Rules to recognize deferred tax assets and liabilities
• OLAP Business Universes, and working with Reports running Slice and Dice processes in Cross-Tab and Tabular View formats. Working with Web Intelligence and Xcelsius to migrate components previously running in BEx, SEM-BPS and SEM-CPM. .

Confidential, Jackson, MS

SAP BI Lead Consultant

Responsibilities:

• Development of reports and consolidation system using SAP BPC to build a costing model that required:
• Legal Consolidation, Ad hoc reporting, intercompany elimination, Application Sets, Application functions, business rules, dimension and members, working with SAP BPC for Web, Excel, and Word; defining security, status, roles, work status, Business Process Flows.
• Budgeting system implementation.
• Consolidation using Legal Consolidation, Intercompany Elimination, data upload from subsidiaries, currency translation, report building, formula calculations, Business Process Flows and web reports.
• Security, Task and Profile Management.
• Formula calculation, Data Manager, Dimension Calculation, Data Loads
• Report building using BPC Excel interface, Word, and Power Point Interfaces
• Review of requirements and reports
• Extraction from SAP CRM using SAP BW of Trade Promotion Management and Sales Operational Planning (SOP).
• Development of an advanced Data Mining application for payment of Sales Representatives in order to dynamically calculate commissions based on constantly changing conditions. This Costing Model involved more than 200 sales representatives all over the world using SAP Business Intelligence 7.0.
• CO-PA, FI, SD, MM, and CO support
• BI Business Content including extractors, master data, and reports.
• Basic ABAP experience to support ABAPERS in the program development.
• Configuration and maintenance of GL postings.
• Development of custom extractors and BEx Reports replicating reports and cubes based on Hyperion/Essbase migration to replicate those reports with information in SAP.
• Activation and development with Business Content
• Interaction with SAP Basis to fix data transfer problems, flat files problems with the system, RFC connections, Web integration, and suggestion of system upgrades to match the latest SAP requirements.
• This project was a “cleaning operation” after IBM Global Consulting Services left the project, leaving multiple problems to the client.
• Billing Documents, Controlling Areas, Operating Concerns, cost center standard hierarchy, activity types and statistical key figures.
• CO-PA Planning Layouts, Planning Versions, CO-PA Reporting (Forms and Report Line Structures).
• Consolidation experience: definition of versions, hierarchies, ledgers,consolidation groups and frequencies, assign hierarchies to chart of account, move balances forward, consolidation monitor and task definition for inter-company elimination, manual posting, data transfer definition, dimension definition, deletion of transactional data, definition of FS Items, Currency Translation, Elimination of Profit/Loss on Sale of Fixed Asset to Subsidiary.

Confidential, Tampa, FL

Lead SAP BI Consultant

Responsibilities:

• Demo and review of the new SEM (SAP Business Planning and Consolidation) version 4. Basic information regarding SAP Business Planning and Consolidation (Outlooksoft) architecture and infrastructure, reporting, application set creation, consolidation and planning.
• Migration from BW 3.5 to BI 7.0, and general system installation review and roles update.
• BI Business Content including extractors, master data, and reports.
• BW Security and Roles development
• Material Management, Point of Sales Data, Shipping Points, Billing Documents, Inventory Movements, Goods Issue status, Sales Orders, Material Status and Back Orders Reports.
• Business Reporting using WADs and Business Explorer Queries, workbooks, formula calculation, calculated key figures.
• Development of customized extractors, reusing SAP Delivered Business Content
• Data Mining Development and forecasting models for materials management and financial analysis.
• Integrated Planning (IP), planning functions, planning sequences, filters, real-time InfoCubes, aggregations, trace function, planning cockpit, Fox formulas.
• Support and configuration of payment program configuration including Company Code Data, Paying Company, Vendor Master, and payment methods.
• Accounts Receivable: configuration of reason codes, account determination, customer master records, and customer groups.
• Review and update of consolidation hierarchies, hierarchies, ledgers, chart of account, move balances forward, redefinition of tasks and scheduling for updates, configuration and definition of FS Items, inter-company elimination, AP/AR Intecompany elimination, Loan Elimination of intercompany, intercompany movements elimination.

Confidential

SAP BI/BPC/SEM/FI/Strategic Consultant, New York

Responsibilities:

• Review of SAP BPC, and creation of structures and MS Excel reports for the client to evaluate the possibility of a migration to this technology. Both structures and reports were created using SEM and BPC, and to users to deploy the application.
• SAP CPM Implementation: Balanced Scorecard and CPM Cockpit
• BEX Reports and Excel Style sheets.
• User Authorizations and Roles.
• BI 7.0/ BW 3.5
• Measure and Value Driver Tree.
• BSP Configuration of financial reports and BEX reports.
• Formatted and configured the Planning layouts and Fox Formulae.
• Extraction and modification of layouts.
• Planning Layouts, Planning Folders, Planning Functions, Planning Sequences, Packages, Variables, Authorizations, and working with functions such as Copy, Distribute, Delete, Repost, Forecast, and others.
• Complete deployment of the application around NY State electrical facilities. End-User, Technical, and Managerial .
• CO-PA reporting and data extraction in R/3 to BW, Data Sources, and Data Maintenance.
• BEx and MRP Reporting, including extraction and master data using Business Content.
• BW statistics, selective deletion, aggregations, hierarchies, checking indexing, query properties, compression and partitioning.
• Integrated Planning (IP), planning functions, planning sequences, filters, real-time InfoCubes, aggregations, trace function, planning cockpit, Fox formulas.
• Consolidation experience: definition of versions, hierarchies, ledgers, consolidation groups and frequencies, assign hierarchies to chart of account, move balances forward, consolidation monitor and task definition for inter-company elimination, manual posting, data transfer definition, dimension definition, deletion of transactional data, definition of FS Items, Currency Translation, Elimination of Profit/Loss on Sale of Fixed Asset to Subsidiary.

Confidential, San Francisco, CA

SAP BW/ SAP CPM Consultant

Responsibilities:

• SAP CPM Implementation: Balanced Scorecard and CPM Cockpit
• Measure Builder
• BEx Reports
• Measure and Value Driver Tree.
• SEM SAP and BPS
• Involved in modeling of transactional info cubes for aggregation of Plan data.
• Formatted and configured the Planning layouts.
• Integrated Planning (IP), planning functions, planning sequences, filters, real-time InfoCubes, aggregations, and Fox formulas.
• Worked with Chart of Accounts, Company code configuration, house banks and bank account determination.

Confidential, NJ

SAP FI CO PA Consultant

Responsibilities:

• Planning Layouts and Profiles, FOX code
• Worked with Planning Functions
• BEx and InfoCubes Design
• BPS implementation with Planning Layouts, Planning Folders, Planning Functions, Planning Sequences, Packages, Variables, Authorizations for budget planning and cost center accounting.
• Profitability Analysis and CO-PA reporting
• Extraction and integration of Cost Center Accounting info with SAP BW-BPS.
• Web Templates and Web Application Server
• Configuration of GL Accounts, creation and assignment of Cost Centers, Profit Centers and Hierarchies.
• Investment Management and Profit Center Accounting.

Confidential, Chicago, IL

SAP SEM/BW Consultant

Responsibilities:

• InfoObjects, InfoSources, InfoCubes, Aggregate, Star Schema Multi-cubes, ODS Objects, ETL, Generic data extractor, application specific extractor: such as CO-PA.
• BEx Analyzer, BEX Query Designer, BW Report Agent, Web Reports, Web Application Designer.
• Administrator Workbench, Metadata Repository, PSA (Persistent Staging Area).
• Aggregates and Multi-Cubes.
• Data Warehouse Modeling,
• Cost Center Accounting: organizational structures, cost element accounting, cost center groups, categories, assessment and distribution, activity types, actual postings.
• Profitability Analysis: operating concerns, costing based- and account-based reporting, maintain characteristics, value fields, assigning operating concern to controlling areas, flows of actual values, variable and forms in R/3 reporting, and transports

Confidential, Florida

SAP BW Consultant

Responsibilities:

• Responsible for System Design, analysis, development and the implementation of Business Warehouse using SAP BW 2.0B and SAP 4.6C
• The product architecture involved custom info sources, InfoCubes and ODS, as well as enhancement of SAP standard Business Content in MM, SD and PM modules.
• Responsible for program specifications for development, maintenance and enhancements.
• Diagnosed and resolved basic to moderately complex program problems within the Business Warehouse application.
• Used BEx Analyzer for normal Query Definition and InfoSet query for reporting.
• Profitability Analysis: operating concerns, costing based and account-based reporting, maintain characteristics, value fields, assigning operating concern to controlling areas, flows of actual values, variable and forms in R/3 reporting, and transports
• Used BEx Analyzer for normal query definition and variance.
• Used the functionality for defining variables, conditions, filters and exceptions for BEx queries.
• Used calculated key figures and restricted key figures.