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.
