Omnilens · Self-service reporting

Build any report by dragging in your data.

The report that took four hours now takes four drags.

Omnilens connects to your database. Drag in the fields you need, then act on what the report shows. It works like an Excel PivotTable, in a web browser. Omnilens builds the query, runs it against your SSAS Tabular model and shows the result.

  • 10Pivot tables in one report
  • 50,000Rows on screen
  • 10 lakhRows in one CSV download
  • 50Recipients per scheduled email

Try it

Four drags. Try them yourself.

This is the pivot builder at the heart of Omnilens, on a small sample model. Drag fields into the boxes, or tap them, and watch the table build.

  1. Bring your data

    Here, a sample model is already loaded.

  2. 2

    Drag in fields

    Tick or drag fields into Rows, Columns, Measures and Filters, the way you would in an Excel PivotTable.

  3. 3

    Omnilens runs it

    It checks your access to every field, builds the query, runs it and shows the result. No code, no exports, no ticket queue.

  4. 4

    Save, share, schedule

    Save the report in a folder, assign it to colleagues, pin it to the Dashboard or email it on a schedule.

Generate Report · Energy sales

Measures

Dimensions

Drag a field into a box, or tap it.

FiltersDrag fields here
ColumnsDrag fields here
RowsDrag fields here
MeasuresDrag fields here
No drags yet

Put Category in Rows and Consumption in Measures, or press Show me.

The problem it solves

Your data, without the specialist tools.

Omnilens puts your SSAS Tabular model behind a browser, and adds what an organisation needs to run reporting at scale: users and roles, per-table access, saved and assigned reports, emailed schedules, KPI dashboards, a self-service model builder and a full audit trail.

  1. 01

    SSAS data is locked behind specialist tools.

    Querying a Tabular model normally needs Excel with the right drivers, Power BI, or hand-written queries.

    With OmnilensOmnilens puts the same model behind a browser.

  2. 02

    Access control is coarse.

    Native SSAS roles are managed by DBAs.

    With OmnilensOmnilens grants access per user, per model and per table, enforced on the server so it cannot be bypassed from the browser.

  3. 03

    Building a new model is slow.

    Standing up a Tabular database normally takes a BI developer.

    With OmnilensModel Builder lets a granted user upload Excel or CSV files and get a working model with tables, relationships, measures, hierarchies and KPIs.

  4. 04

    Reports are hard to distribute.

    With OmnilensSaved reports can be assigned to colleagues, organised in folders, and emailed on a daily, weekly or monthly schedule as Excel attachments.

  5. 05

    No one knows who looked at what.

    With OmnilensEvery login, query, access change and model edit is recorded in an audit log, including why an action failed.

Model Builder

From spreadsheets to a working model, the same day.

Standing up a Tabular database normally takes a BI developer. Model Builder lets a granted user create one from Excel or CSV files.

  1. 01

    Upload your files

    Add tables from Excel or CSV. Merge more rows into a table later, as new months arrive.

  2. 02

    Tag facts and masters

    Tag each table as fact or dimension. Masters are built from the codes in your data, and Sync masters shows how many new codes are waiting.

  3. 03

    Relate and measure

    Link the tables, add measures with a suffix such as kWh, and hierarchies for drill-down. A shared calendar from 2005 to 2050 is ready to link.

  4. 04

    Set KPIs, then report

    Give measures a target and status bands; Current Month, Previous Month and MoM % are generated for you. Everyone with access can now slice, chart, schedule and share it.

Modules

From the first report to the audit trail.

Pick a module to see it at work, or choose who you are to see the modules you would use.

Show modules for
Generate Report · Energy sales
FiltersFiscal year = 2025-26
ColumnsQuarter
RowsCategory
MeasuresConsumption (MU)
Showing 5 rowsFull data (CSV)Run

Every user

Generate Report

The pivot builder. Tick or drag fields into Rows, Columns, Measures and Filters, Excel-PivotTable style.

  • Filters pick values from a list; units or load use a From / To range
  • Drill-down hierarchies, for example Year › Quarter › Month
  • Up to 10 pivot tables on one page, saved as one report
  • 50,000 rows on screen; a full CSV of up to 10 lakh rows

In practiceA business user drags fields into Rows, Columns and Measures, applies filters, and gets the answer in seconds, with no code, Excel add-in or IT ticket.

Omnilens is multi-tenant: each client organisation has its own users, models, reports and admins, kept fully separate.

Access, security and speed

Everyone sees only what they should, and every action is on record.

Access you control

  • Per user, model and tableA user cannot see or query a table they have not been granted, even through the API.
  • View and run onlyPeople a report is assigned to can run it, not change it.
  • Nothing lostReports on a removed model stay and show “no access” until access returns.

Security on every request

  • Sessions that endLogout, a password change or 30 minutes idle ends the session.
  • Injection guardsQuery injection guards and an allow-list of filter operators.
  • Rate limits10 failed logins per IP per 15 minutes; 300 requests per IP per minute.
  • A closed bridgeThe link to SSAS accepts only calls carrying its key, from the backend.

Fast, and never stale

  • Results are cached per model version, so a refreshed model never serves stale data
  • After a refresh, the 25 most-requested queries are re-run so dashboards open fast
  • A query stops when you leave the page
  • Each Dashboard card loads on its own
  • Health checks on every service and daily log files

Industries

If it fits in an Excel sheet, it can be reported on.

Omnilens works with tabular data from any industry. A team uploads its files in Model Builder, tags them as facts and masters, adds measures and KPIs, and everyone with access can slice, chart, schedule and share it.

  • Utilities (power, water, gas)

    Data

    Meter readings, consumption, billing, collections, outages

    Typical reports and KPIs

    Consumption by region and category, billing efficiency, collection efficiency, losses, outage duration

  • Healthcare and medical

    Data

    Patient admissions, OPD/IPD visits, lab tests, pharmacy stock, claims

    Typical reports and KPIs

    Bed occupancy, average length of stay, readmission rate, department-wise revenue, drug consumption and expiry

  • Banking

    Data

    Accounts, loans, deposits, transactions, branch data

    Typical reports and KPIs

    Loan disbursals and NPAs by branch, CASA ratio, deposit growth, transaction volumes by channel

  • Finance and accounting

    Data

    General ledger, budgets, invoices, expenses, cash flows

    Typical reports and KPIs

    Budget vs actual, P&L by cost centre, receivables ageing, expense trends, month-over-month variance

  • Insurance

    Data

    Policies, premiums, claims, agents

    Typical reports and KPIs

    Premium collected by product, claim ratio, settlement time, agent performance

  • Logistics and supply chain

    Data

    Shipments, orders, fleet trips, warehouse stock, deliveries

    Typical reports and KPIs

    On-time delivery rate, freight cost per shipment, stock turnover, route and vehicle utilisation

  • Retail and e-commerce

    Data

    Sales, products, stores, customers, returns

    Typical reports and KPIs

    Sales by store and category, top products, margin, basket size, return rate

  • Manufacturing

    Data

    Production output, machine logs, quality checks, raw materials

    Typical reports and KPIs

    Output vs plan, downtime, defect rate, material consumption per unit

  • Education

    Data

    Enrolments, attendance, exam results, fees

    Typical reports and KPIs

    Attendance trends, pass rates by subject, fee collection, enrolment growth

  • HR and workforce

    Data

    Employees, attendance, payroll, recruitment

    Typical reports and KPIs

    Headcount, attrition, payroll cost by department, time to hire

  • Government and public sector

    Data

    Scheme beneficiaries, grievances, project spend

    Typical reports and KPIs

    Beneficiaries by district, grievance resolution time, budget utilisation

Questions

What teams ask first.

Does my team need to write queries or code?

No. Users tick or drag fields into Rows, Columns, Measures and Filters, and Omnilens builds the query, runs it and shows the result.

Do we need Excel or Power BI installed?

No. Omnilens works in a web browser. Results can still be exported to Excel or CSV.

What data can Omnilens report on?

Any tabular data from any industry: an existing SSAS Tabular model, or Excel and CSV files uploaded in Model Builder and turned into a reportable model. If it fits in an Excel sheet, it can be reported on.

How do we control who sees what?

Admins grant each user only the models and tables they need. Access is enforced on the server, so an ungranted table cannot be seen or queried, even through the API. Every login, query, export and change is in the Audit Log.

How large can a report be?

Up to 50,000 rows show on screen, with “Showing the first N rows of M”. A Full data (CSV) download streams up to 10 lakh rows. Reports over 50,000 rows per table cannot be scheduled; add filters first.

Can reports be emailed automatically?

Yes. Schedule a saved report daily, weekly (on a weekday) or monthly (on a day of the month) at an IST time, to up to 50 recipients. Every table of the report goes as one Excel attachment, and every run is kept with its failure reason.

What happens when a field is removed from the model?

A banner names the field in any report that uses it and blocks Run until it is removed, in one click.

Can one platform serve several organisations?

Omnilens is multi-tenant: each client organisation has its own users, models, reports and admins, kept fully separate.

See your own reports in Omnilens.

Book a demo and we will walk you through the pivot builder, the Dashboard and Model Builder.