Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
samane_ramezani
Creator
Creator

how manage large data in Dimension field in Direct Discovery Method

Hi

I have Table in my app that have 40 billion records (it is about bank's transaction)

I loaded this table by Direct Discovery Method

(Direct Query

Dimension

        Account_ID,

        Transaction_Date

  Measure

        Amount

From MyTable)

but have problem with Dimensions because the Dimension Data volume is about 60 million records for Account_ID Dim

and the Reload time is more than 20 hours !!!!!!

and the app is too slow

thanks for new data model or suggestions

1 Reply
Anil_Babu_Samineni

May be try this?

DIRECT QUERY

DIMENSION

Account_ID

Transaction_Date

MEASURE

Amount

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)