Issue when there is new data in cube

Alex1

Hi experts,

I have a issue when after data is loaded in my cube.

I'm using obiee 11.1.1.5.0 and my database is GreenPlum, (other databases in my rpd works fine when new data is loaded).

Issue that I see in my dashboards is:

Simply if I go to administration rpd and update rowcounts and save RPD my dashboards work perfectly again.

But I don't know if is possible to fix this issue (I can't do that each day, because data is loaded each day).

Any help about it? Is any parameter or something that I have to setup?

Thanks!!

Thomas Dodds

EMC docs show using a Postgre Unicode driver ...

https://www.emc.com/collateral/software/white-papers/h8295-obiee-11g-analytics-emc-greenplum-database-wp.pdf

Alex1

Thanks for your answer @Thomas Dodds, but I can't see anything about my issue.

Do you know about that? If I update row cound from RPD administration all of my dashboards works fine...But I can't do that everytime that I have new data in cube.

Any help?

Thanks!

Alex1

I think that the problem is about UpdateAllRowCount from RPD Administration.

If I'm going to RPD and UpdateRowCount my error disappear and I can see perfectly all of my dashboards.

Is possible to Schedule UpdateRowCounts? Each day are new data on system and I can't to log in to administration tu update data...

Thanks!

Thomas Dodds

You aren't using the same DB driver the documents reference ... this might be why you are having the issue.  Did you try the referenced driver?

Alex1

Ok! could be, but...how Can I get this driver? Is there any web to get it?

Thanks!

Thomas Dodds

Google works splendidly ...

https://community.emc.com/docs/DOC-14023