Difference between revisions of "FXLDataUrlFact()"
Jump to navigation
Jump to search
(Created page with "Category:Functions Reference FXLData ƒ<sub>''x''</sub> =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse sty...") |
|||
| Line 12: | Line 12: | ||
! !!style=max-width:4em | Argument!! style=max-width:4em | Description !! style=max-width:4em | Examples !! style=max-width:4em | Required? | ! !!style=max-width:4em | Argument!! style=max-width:4em | Description !! style=max-width:4em | Examples !! style=max-width:4em | Required? | ||
|- | |- | ||
| − | | 1||Url|| A complete and fully-formed SDMX data query URL || <nowiki>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id</nowiki> || style="background-color:pink;" |Mandatory | + | | 1||Url|| A complete and fully-formed SDMX data query URL || <nowiki>=FXLDataUrlFact("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id",100)</nowiki> || style="background-color:pink;" |Mandatory |
|- | |- | ||
| 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series | | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series | ||
|} | |} | ||
Latest revision as of 03:57, 5 August 2024
ƒx =FXLDataUrlFact() returns the selected resultset as a data warehouse style fact table with one row per observation including all series and observation attributes. As this is conceptually just the fact table of a star schema, only code IDs are returned - code labels are not available.
Use Case
This version of the function is designed for data analytics involving observation attributes. The fact table model also works well with Excel's standard Pivot Table features.
Syntax
=FXLDataUrlFact( Url , [MaxSeries] )
| Argument | Description | Examples | Required? | |
|---|---|---|---|---|
| 1 | Url | A complete and fully-formed SDMX data query URL | =FXLDataUrlFact("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/ECB,EXR,1.0/A.CAD+HUF+INR...E?round=2&labels=id",100) | Mandatory |
| 2 | MaxSeries | The maximum number of series to return | 1000 | Optional Defaults to 100 series |
