Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Transaction Log in Workspace

    Posted 08/11/21 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

    Posted 08/12/21 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
    ------------------------------



  • 3.  RE: Transaction Log in Workspace

    Posted 08/12/21 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

    Posted 08/12/21 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
    ------------------------------



  • 5.  RE: Transaction Log in Workspace

    Posted 08/12/21 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

    Posted 08/12/21 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
    ------------------------------



  • 7.  RE: Transaction Log in Workspace

    Posted 08/13/21 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


Related Content