FXLDataUrlFact() - Revision history

Grahamcassidy at 13:07, 30 July 2025

2025-07-30T13:07:53Z

Grahamcassidy at 13:07, 30 July 2025

2025-07-30T13:07:31Z

Vmurrell at 10:57, 5 August 2024

2024-08-05T10:57:15Z

Vmurrell: Created page with "Category:Functions Reference FXLData ƒ_''x'' =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse sty..."

2024-07-22T12:18:53Z

Created page with "Category:Functions Reference FXLData ƒ''x'' =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse sty..."

New page

[[Category:Functions Reference FXLData]]
ƒ''x'' =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table 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 [https://en.wikipedia.org/wiki/Star_schema 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] '' )

{| class="wikitable" style="width:70%;"
|-
! !!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
|-
| 2||MaxSeries || The maximum number of series to return || 1000 || Optional Defaults to 100 series
|}

@@ Line 16: / Line 16: @@
 | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series
 |-
-| 3||TimeFormatFrequencyId || Text If the optional TimeFormatFrequencyId argument is set to 'D', the plugin will convert TIME_PERIOD values to a daily format—provided the original frequency is less granular than daily || D|| Optional Defaults to the underlying time format if not used.
+| 3||TimeFormatFrequencyId || Text If the optional TimeFormatFrequencyId argument is set to 'D', the plugin will convert TIME_PERIOD values to a daily format—provided the original frequency is less granular than daily || D|| Optional Defaults to the underlying time format if not used
 |}

@@ Line 6: / Line 6: @@
 '''Syntax'''<br>
-<small>=<strong>FXLDataUrlFact</strong>( ''Url , [MaxSeries] '' )</small>
+<small>=<strong>FXLDataUrlFact</strong>( ''Url , [MaxSeries], [TimeFormatFrequencyId] '' )</small>
 {| class="wikitable" style="width:70%;"
@@ Line 15: / Line 15: @@
 |-
 | 2||MaxSeries || The maximum number of series to return || 1000 || Optional<br>Defaults to 100 series
 |}

@@ Line 12: / Line 12: @@
 ! !!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
 |}

FXLDataUrlFact() - Revision history

Grahamcassidy at 13:07, 30 July 2025

Grahamcassidy at 13:07, 30 July 2025

Vmurrell at 10:57, 5 August 2024

Vmurrell: Created page with "Category:Functions Reference FXLData ƒ''x'' =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse sty..."

Vmurrell: Created page with "Category:Functions Reference FXLData ƒ_''x'' =FXLDataUrlFact() returns the selected resultset as a [https://en.wikipedia.org/wiki/Fact_table data warehouse sty..."