Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Drill-through to datasource type other

    Posted 02/28/19 09:40 AM
    I'm struggling with setting up a drill-through to details that are in a csv file.

    The developer documentation on setting up drill processes is very, very weak on the datasource type of other. When this datasource type is chosen it will open up a new TI process where the only options are 'none', 'cube view' or 'odbc'. I have tried with none and setup the source for the process in the prolog;

    pFilePathName = 'D:\Sourcefiles\TransactionData.csv';

    DatasourceNameForServer=pFilePathName;
    DatasourceNameForClient=pFilePathName;
    Datasourcetype='CHARACTERDELIMITED';

    When I execute the drill from Architect I get an error message 'Drill object was successfully built but did not return a valid handle.'

    For some reason it is not possible to use a drill with this datasource type in PAW where the drill name does not show up.

    Any ideas are much appreciated.

    Rgds,
    Jesper

    ------------------------------
    Jesper Poulsen
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Drill-through to datasource type other

    Posted 02/28/19 10:08 AM
    Hi Jesper,

    There maybe limitations with Drill Through with PAW - Here is what is available:

    Drill through PAW

    1. Drill through / Excel - https://www.youtube.com/watch?v=wsgWFBTBCYw or https://www.ibm.com/communities/analytics/planning-analytics-blog/analyze-detailed-data-by-using-drill-throughs-in-ibm-planning-analytics-for-microsoft-excel/ ""
    2. Drill through / PAW - https://www.ibm.com/communities/analytics/planning-analytics-blog/drill-through-in-pa-workspace/ "Drill Thru to a View or a Relational DB is now supported in Workspace "
    3. There are plans to offer drill through via websheets. There is no target date for websheets.


    ------------------------------
    paul YOUNG
    ------------------------------



  • 3.  RE: Drill-through to datasource type other

    Posted 02/28/19 10:23 AM
    I guess the documentation (at least the developer guide) has not yet been update regarding this 😏

    ------------------------------
    Jesper Poulsen
    ------------------------------

    Original Message


  • 4.  RE: Drill-through to datasource type other

    Posted 03/19/19 11:58 AM

    Perspectives Drill Through

    In Planning Analytics Architect / Perspectives or TM1web when a drill through for a view is selected it takes the user to the Drill Through View which has previously been setup.

    PAX Drill Through

    When you do a Drill through in PAX it opens up a empty cube view. Is this correct and the way PAX will be handling drill through to cubes in the future?



    ------------------------------
    Herman Moller
    ------------------------------

    Original Message


  • 5.  RE: Drill-through to datasource type other

    Posted 03/20/19 07:56 AM
    Here is link to what is available with PAW and Drill Through https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_prism_gs.2.0.0.doc/t_paw_drillthrough.html
    Ibm remove preview
    View this on Ibm >


    I will leave up future of drill through with offering management.

    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 6.  RE: Drill-through to datasource type other

    Posted 03/20/19 01:18 PM
    Hi Herman
    When I drill in PAX, it opens the same predefined view as if I do this in Architect or PAW. In my case, all selected elements are reflected in the view so it aligns with the source for drilling.
    Rgds,
    Jesper

    ------------------------------
    Jesper Poulsen
    ------------------------------

    Original Message


  • 7.  RE: Drill-through to datasource type other

    Posted 03/21/19 11:07 AM
    ​Hello Jesper,

    I have been working through the Drill Through in PAX.

    It seems to be the drill through works fine when you have a fixed view but we use a  number of drills which use a method of creating the view on the fly via the Drill Through process. This method works fine in TM1web / Perspectives but isn't recognised in PAX.

    Regards

    Herman

    ------------------------------
    Herman Moller
    ------------------------------

    Original Message


  • 8.  RE: Drill-through to datasource type other

    Posted 03/21/19 11:23 AM
    Jesper,

    After a bit more of an investigation we found the issue.

    Drill through in PAX works only if you have Dimension in Row and Column . In our scenario we only had a dimension in Row and hence not retrieving anything. This means we can use our existing Drill Through but need to tweak the TI process to ensure we always have a dimension in the Rows / Columns.

    Regards

    Herman

    ------------------------------
    Herman Moller
    ------------------------------

    Original Message


Related Content