Planning Analytics

 View Only

  • 1.  Transaction Log in Workspace

    Posted Wed August 11, 2021 08:07 PM

    Is there a way in Workspace to explore the Transaction Log? I haven't been able to find a way, so I default to going into Architect.



    ------------------------------
    Adam
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Transaction Log in Workspace

    IBM Champion
    Posted Thu August 12, 2021 01:06 AM
    Hi Adam,
    AFAIK, there is no way currently. You can only download the logs then use a text editor to trawl them.

    Outside of PAW and Architect, Marius posted a TM1py sample that may help.

    ------------------------------
    George Tonkin
    ------------------------------

    Original Message


  • 3.  RE: Transaction Log in Workspace

    Posted Thu August 12, 2021 03:29 PM

    Hi George,
    Thank you for taking the time to respond.
    This only works after a save ... what if I don't want to save but look at what users are doing? 
    I guess there's no way to do that in Workspace presently.
    Thanks!



    ------------------------------
    Adam
    ------------------------------

    Original Message


  • 4.  RE: Transaction Log in Workspace

    IBM Champion
    Posted Thu August 12, 2021 04:13 AM
    It's currently listed on the roadmap as something to be introduced in Q4:

    "Transaction Log Query in Workspace | Query and filter the TM1 transaction log without TM1 Architect or Perspectives"

    ------------------------------
    Declan Rodger
    Technical Director
    Spitfire Analytics
    ------------------------------

    Original Message


  • 5.  RE: Transaction Log in Workspace

    Posted Thu August 12, 2021 03:30 PM
    Hi Declan,
    I appreciate you taking the time to reply.
    I didn't know to check there. I'll bookmark it for easy future reference.
    Thank you!

    ------------------------------
    Adam
    ------------------------------

    Original Message


  • 6.  RE: Transaction Log in Workspace

    IBM Champion
    Posted Thu August 12, 2021 10:54 AM
    We've implemented a few solutions where we load the logs into a relational database for querying.  In theory you could also load them into a PA cube (assuming the volume of records isn't too high).

    As Declan pointed out, it's on the roadmap and I believe one of the last things that you can do in Architect that is yet to be implemented in PAW :)

    ------------------------------
    Brian Simpson
    ------------------------------

    Original Message


  • 7.  RE: Transaction Log in Workspace

    Posted Fri August 13, 2021 08:54 AM
    I can confirm the transaction log query is still on the to-do list for Workspace modeling.

    We should provide a single transaction log UX that is accessible from both the Workspace TM1 model tree, similar to Architect,  and the cube viewer.  For the cube viewer, we should support transaction log queries from leaf cells and tuples (row and column headers with leaf level members). 

    It is possible to query the TM1 Servers transaction log using the ODATA API with a tool such as Postman.   Here is an example of an ODATA API call against the Planning Sample model:

    /api/v1/TransactionLogEntries?$filter=TimeStamp%20gt%202021-08-12T04:00:00Z%20and%20TimeStamp%20lt%202021-08-13T12:51:51Z%20and%20Cube%20eq%20'plan_BudgetPlan'%20and%20Tuple/any(t:%20t%20eq%20'42201')%20and%20Tuple/any(t:%20t%20eq%20'FY%202004%20Budget')

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message