Planning Analytics

 View Only

  • 1.  Audit Log and Logging generally in the absence of Legacy Clients.

    Posted Tue June 04, 2024 12:36 PM

    Hi,

    A couple of questions around logging and it's viability in the PA only world.

    • The Audit Log - I'm not able to see any Audit Log functionality at present.
    • The Transaction Log - Any intent to provide more advanced filtering and roll back functionality?  Current legacy functionality is critical to BAU admins looking after submission cycles.  Especially the ability to select and roll back by user in a narrow time window.

    Thanks



    ------------------------------
    Steven Rowe
    ------------------------------


  • 2.  RE: Audit Log and Logging generally in the absence of Legacy Clients.

    IBM Champion
    Posted Tue June 04, 2024 02:24 PM

    Hi Steve,

    Audit log is there:

    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/c_paw_nf_sc90_database%20logs.htm

    Transaction Log does allow search and filtering:

    Looks to have same functionality as Architect.

    However, what would be ideal and has always been lacking is the ability to filter on a Change Set.

    Sometimes a user spreads across thousands of cells and ideally you just want that Change Set rather than having to try work everything out to a time window.

    As an aside, I did recently test the logs against changes made to see if they were immediately available in the logs. Often in Architect I could not see the changes until I did a Save Data to commit TM1s.log to disk. No need for this anymore, the search picks up everything.

    Hope that helps.



    ------------------------------
    George Tonkin
    Business Partner
    MCI Consultants
    Johannesburg
    ------------------------------

    Original Message


  • 3.  RE: Audit Log and Logging generally in the absence of Legacy Clients.

    Posted Tue June 04, 2024 02:36 PM

    Hi Steven, George,

    PAoC and PA Local do offer a good logging observations with serches.

    Yet, better filtering for logs is coming soon with some query performance improvment for certain cases.

    Best regards,



    ------------------------------
    Svetlana Pestsova
    IBM Planning Analytics Product Manager
    ------------------------------

    Original Message


  • 4.  RE: Audit Log and Logging generally in the absence of Legacy Clients.

    Posted 30 days ago

    Yes, it is there, but as I experienced only 2 days ago, it is limited to 1500 rows of data.  I was asked to roll back some budget entries, but on 50 accounts, for 60 sites for 12 months, so 36,000 tuples.  These were updated using the old DBS function, and no Change Set was recorded.



    ------------------------------
    Craig Sawers
    ------------------------------

    Original Message


  • 5.  RE: Audit Log and Logging generally in the absence of Legacy Clients.

    Posted 25 days ago

    Thanks all for the comments, glad to see the functionality is already in place.

    • IMO Having the audit log button greyed out when it is turned off would be better, at least you know it's there and don't ask stupid questions!  (In my defence I did look online and all the (that I could find) documents refer to the Server Explorer still).
    • Limiting the transaction log search and roll back to 1.5K records would break the functionality in 90% of the cases I've had to use it in anger.  We don't need to return all the records but being able to roll back all records within a search query is important.
    • The Audit log puts a heavy load on the disc, we only get to see % disc consumed in the agent stats, would be good to be able to see the actual GB too.
    • I'm in RFE territory now but it would be great if we could configure the Audit Log to only record certain activity to manage the size.  If my SOX review is quarterly, there's no chance of me keeping a quarter worth of Audit log files in PAoC.  The main thing I'd like to turn off is the alias change on member names, this tends to happen a lot on a dimension load (once to clear, once to update) and often run multiple times a day on multiple dimensions.


    ------------------------------
    Steven Rowe
    ------------------------------

    Original Message