× Discuss on Insight, business intelligence and reporting, Regulatory, Risk, Financial & Performance, Monitoring with Systar, T-Risk, ALCO Reporting, etc…

DW integration

  • SandroK
  • Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 12
  • Thank you received: 3

SandroK created the topic: DW integration

Dears,

R14/tafc/JBase/Linux.
Quite often we use simple listings like:
LIST FBNK.LD.LOANS.AND.DEPOSITS WITH VALUE.DATE EQ 20200531 WITH CATEGORY GE 21050 AND WITH CATEGORY LE 21074 BY CURRENCY BY CATEGORY BREAK-ON CURRENCY BREAK-ON CATEGORY TOTAL AMOUNT TOTAL LOC.CNT DET-SUPP HDR-SUPP
that generates the report like:
CURRENCY  CATEGORY  AMOUNT.............  Count

             21050             36643.55     48
             21053             125961.4    137
             21057            108611.52     10
             21058             24084.59    245
             21064               125000      1

Is there any simple way to integrate such data into tools like PowerBI?

Thanks a lot
Sandro
#22784

Please Log in or Create an account to join the conversation.

Time to create page: 0.132 seconds