Skip to Content
0
Mar 29, 2011 at 04:10 PM

BICA Retaining deleted query elements

21 Views

Hi All,

I'm currently trying to do something in BICA (SSM7.5 SP7 and SP8) but I'm not understanding what is happening. Let me explain:

- Create query in BW with some metrics and a single dimension

- In BICA do the import of that query

- The PAS database is updated and metrics are create correctly BY that single dimension

- In BW change the query to have an extra dimension

- Remove the create metrics from PAS database

- In BICA import the query

- The PAS database is updated and metrics are create correctly using the two dimensions

- In BW change the query and remove one of the used dimensions (so the query only have one dimension)

- Remove the create metrics from PAS database

- In BICA import the query

- The PAS database is updated but metrics are create incorrectly using the two dimensions !!!!

This seems to be some sort of cache. I believe is not a PAS cache because I kill all the connections to the database after changing the BW Query. Did BICA have some sort of cache? How can I delete that?

In the "Best Practiceu2026 The BI Connector in SSM 7.0 Version 1.00 u2013 July 2008" pdf file I discover the following information:

In early versions of the BICA Tool (pre 6 June 2008), if you did an Import Schema using BICA then changed the query definition in BI then tried to re-import schema using BICA (or even import schema to a brand new PAS Model) then the BICA may not have recognized the new query definition. This is because the old query definition is still in the Work Database of the PAS user that the BICA tool uses to connect to PAS. From BICA version 6 June 2008, u201CFORCEu201D has been added to all of the IMPORT commands so this should no longer be a problem. The other solution is to restart the extended listener (to close the work database of the PAS User) and then use the BICA to re-import the new query definition. Note that if you are working in PAS directly you would just issue an exit clear command and re-enter PAS u2013 the new query definition will then be available to you.

Because I'm using SSM 7.5 SP7 (I also test in another machine using SP8) I believe this should not happen, but...

Did any one had this problem before? How can I solve it?

Thanks in advance

Regards

Pedro