edge
====

Overview
--------

Property             Value
-------------------  -----
Culture              -
Compatibility Level  -
Data Source Version  -

1. Data Sources
---------------

This model contains 2 loaded tables, 3 measures, 1 relationship.

Table            Source Type  Source
---------------  -----------  ----------------------------------------
Sales            Web API      Web API -> https://example.com/api/sales
Lookup (hidden)  SQL          SQL -> srv -> db

Not Loaded
~~~~~~~~~~

None.

2. Table Details
----------------

Sales
~~~~~

Source: Web API
URL: https://example.com/api/sales

Columns

Column  Type       Format      Summarize By  Source Column  Sort By  Description  Hidden
------  ---------  ----------  ------------  -------------  -------  -----------  ------
Key     Integer    -           none          -              -        -
Date    Date/Time  yyyy-mm-dd  -             -              -        -
Amount  Decimal    #,0.00      -             -              -        -

Key Column: Key

Measures

Measure  Format  Description  Hidden
-------  ------  -----------  ------
Margin   0.0%    -
Units    -       -
Plain    -       -

Margin

    SUM(Sales[Amount]) * 0.1

Units

    COUNTROWS(Sales)

Plain

    1

Lookup
~~~~~~

Source: SQL
Server: srv
Database: db

Hidden: Yes

Columns

Column  Type     Format  Summarize By  Source Column  Sort By  Description  Hidden
------  -------  ------  ------------  -------------  -------  -----------  ------
Key     Integer  -       -             -              -        -

Column Format Strings (4 total, 3 unique)

Format String  Count  Columns
-------------  -----  -------------------------
(none)         2      Key (Sales), Key (Lookup)
yyyy-mm-dd     1      Date (Sales)
#,0.00         1      Amount (Sales)

3. Measures
-----------

Finance\Margins
~~~~~~~~~~~~~~~

Measure  Table  Format  Description
-------  -----  ------  -----------
Margin   Sales  0.0%    -

Margin

    SUM(Sales[Amount]) * 0.1

General
~~~~~~~

Measure  Table  Format  Description
-------  -----  ------  -----------
Plain    Sales  -       -

Plain

    1

Volume
~~~~~~

Measure  Table  Format  Description
-------  -----  ------  -----------
Units    Sales  -       -

Units

    COUNTROWS(Sales)

Measure Format Strings (3 total, 2 unique)

Format String  Count  Measures
-------------  -----  ----------------------------
(none)         2      Units (Sales), Plain (Sales)
0.0%           1      Margin (Sales)

4. Functions
------------

No user-defined functions defined.

5. Relationships
----------------

From Table  From Column  To Table  To Column  Cardinality  Cross Filter  Security Filter
----------  -----------  --------  ---------  -----------  ------------  ---------------
Sales       Key          Lookup    Key        manyToOne    oneDirection  oneDirection

6. Security Roles
-----------------

No security roles defined.

7. M Parameters
---------------

Parameter   Type  Value  Used By
----------  ----  -----  -------
BlankParam  Text  -      -
Region      Text  EU     -

Only direct parameter references in connector calls are shown.
Parameters used in conditional logic or computed expressions may not appear here.

8. Model Statistics
-------------------

Category              Count  Items
--------------------  -----  -------------
Loaded Tables         2      Sales, Lookup
Hidden Tables         1      Lookup
Calculated Tables     0      -
Field Parameters      0      -
Measures-Only Tables  0      -
Calculation Groups    0      -
Not Loaded            0      -
Relationships         1      -
Measures              3      -
Calculated Columns    0      -
Columns               4      -

Generated by tmdl-lens
