Hierarchy not updating?

[VisioX]

Hi there,

I have a hierarchy, built out of two tables (Regions/Locations). Whenever we add new regions and/or locations, the hierarchy get updated, fine!
Yesterday we changed a record in our region file, but the hierarchy still shows the old value.

Is there any way to refresh or update the hierarchy?

Thanks

running on FM 8.1

[almeids]

Not sure what you mean...where is the hierarchy "not updating"?
When a report runs, it reads whatever is currently in your database.  If something changes in the db, the report must be rerun to reflect that.
Sorry if I'm missing something subtle here...

[VisioX]

Maybe I should put some more infos here :-)

table 1 on sql-server -> dRegionFile
one of 40 records...
ZRCMP|ZRRGN|ZRNAME|                       ZRTEXT|         ZRMGR
SS       500     ALBUQUERQUE RGN          ABQ               ManagerName

Yesterday we changed this record from "RIO RANCHO RGN" to "ALBUQUERQUE RGN" (as shown)
But all my reports (Report Studio), where i use the hierarchy, still show "RIO RANCHO RGN". Even a "test" inside FrameWork-Manager gives me the old value.

Location Hierarchy
Overall Company
State
Region---------- ZLIRGN _businessKey
City            |----ZRNAME _memberCaption
Branch

[rockytopmark]

Grab the Native SQL from your Test in FM and process it in a SQL query directly against the RDBMS ... this shold give you a clue.

[VisioX]

Can't find the native SQL. All i do is right-click -> test

[bus_pass_man]

Click on the query and response links.   They have the Cognos SQL and native SQL listed.   The response has lots of interesting stuff too.   

[almeids]

Just a wild guess, but does your environment include separate production and reporting databases?  Perhaps the change needs to be propagated to the database FM is pointing to.

[VisioX]

@bus_pass_man
I can't find "query and response link" in FrameworkManager. Maybe you can give me a hint...

@almeids
Server 1: MS-SQL server for the DB
Server 2: FrameworkManager, Metric Studio, Event Studio, Query Studio, Analysis Studio and Report Studio
Server 3: Web-Gateway
Server 4: Cognos Planning
Propagated... that's what I'm looking for, but how? If i use the 2 files (regions and locations) in RS, everything is fine, but when I use the Hierarchy, which is build out of these two files, I get the old (wrong) data.

Thanks