Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: VisioX on 28 May 2008 01:04:01 PM

Title: Hierarchy not updating?
Post by: VisioX on 28 May 2008 01:04:01 PM
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
Title: Re: Hierarchy not updating?
Post by: almeids on 28 May 2008 02:39:11 PM
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...
Title: Re: Hierarchy not updating?
Post by: VisioX on 28 May 2008 02:51:58 PM
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

Title: Re: Hierarchy not updating?
Post by: rockytopmark on 28 May 2008 04:35:07 PM
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.
Title: Re: Hierarchy not updating?
Post by: VisioX on 28 May 2008 05:32:16 PM
Can't find the native SQL. All i do is right-click -> test
Title: Re: Hierarchy not updating?
Post by: bus_pass_man on 28 May 2008 09:13:23 PM
Click on the query and response links.   They have the Cognos SQL and native SQL listed.   The response has lots of interesting stuff too.   
Title: Re: Hierarchy not updating?
Post by: almeids on 29 May 2008 08:35:14 AM
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.
Title: Re: Hierarchy not updating?
Post by: VisioX on 29 May 2008 04:11:40 PM
@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
Text only | Text with Images