If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

No rows being pulled up

Started by Arsenal, 05 Mar 2007 11:23:41 AM

Previous topic - Next topic

Arsenal

Hi all,

I have a report which was running just fine this morning. In the afternoon, the database was updated with some new dummy data, and ever since then, the report is not pulling up any rows at all

The database didn't have any new columns added-just rows of data

The report validates fine, and even runs but no rows are displayed. I checked the filters (there were none) to see if there was any error there.

I tried copying the report to clipboard, creating a new report via the clipboard, and then running but same thing

Just beats me how a working report won't return any rows after a database update

Any help will be gratefully appreciated

Arsenal

doh ::)

forgot to check for filters in the tabular model...somehow a filter for a particular date had been applied, so obviously no rtows were being pulled up

the report still isn't pulling up all the rows
>:(

MFGF

Hi,

My advice is to check each query and each tabular model to check what filters are defined.  To temporarily turn them off, you can disable them (in properties) rather than deleting them.

If your report is still not returning the correct results after that, it may be that the updates to the database added rows to one table but no corresponding rows to another.  If the tables are linked using an inner join, then you'd expect to see results that exist only in both tables.  Could that be part of the problem?

If this is not it, can you provide some more details of what data you'd expect to see reported but which is not being displayed?

Best regards,

MF.
Meep!

Arsenal

Hi MFGF,

I really appreciate you spending the time helping me. The whole day today, I've been struggling with another report, so I'll go back tomorrow and look at the report.

But the very day I made the post about removing the filter and getting back some rows, I believe I had checked the tabular model and not found any more filters.

I had also recreated the report, and the new report had worked as expected. So, there's no question of all related columns not having been updated.

Like you, I too think that somehow, somewhere there's a filter or two that's preventing the rows from being pulled up. What beats me is how even the filter i found and removed came around(since I had run the report 20 minutes before i was told to run another report on the updated database) , leave alone more filters.

Basically, I'm expecting to see more rows in the report(I have about 10 columns in the report), so that the grand totals match the one I was told to excpect(as it did on the report i recreated)

I'm going to look at the variable conditions that were created in the report once more...but as far as I could tell, the variable explorer just showed red highlights to the summary totals when certain conditions were met.