fanie.dry
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by fanie.dry
-
-
Hi Guys,
I have a DW with more than 200 000 records in them. Each record being a financial transaction on different merchants. The objective is to create a summary report for a specific merchant. The merchant being our biggest and having more than 200,000 transactions.
I've created a Domain from the Data Source for just the specific merchant, to see if I can get the domain as small as possible to work from, but alas the transaction count is still over 200,000. So from the domain I have attempted to create an ad hoc view, which I can create just fine, but can't export it as PDF or use it to create a report, even though the data it returns from the domain is just a summary, group by month, counting the number of transactions per month. So the resultset really is only 1 line per month, which from this data source is only 3 months worth of data. Still it complains about the 200,000 limit.
Anyway to get around that?
Thanks in advance,
Fanie.
-
More than 200 000 transactions
in Products
Posted
Thanks. Also, realized that if I want to make the change permanent I have to make a change in the applicationContext-semanticLayer file.
TThanks.