Planning Analytics

 View Only

PAfE doesn't send data in DBSS formula until it has been run a few times

  • 1.  PAfE doesn't send data in DBSS formula until it has been run a few times

    Posted Fri June 24, 2022 09:59 AM

    Hello I was hoping that some of you might have had the same issue.

    We're trying to upload some numeric and string values via DBS and DBSS. We have an IF formula that only runs the DBS and DBSS in each cell if the sheet is changed to "Send". First time we hit send all numeric values was send and we could see it in the cell and the cube. When I stopped sending again and then changed to send again, the DBSS values was only send on one of the columns. The last column with string values was also send when we did the same procedure again. The data is being sent to a string measure in the cube with a picklist. All string values is present in the picklist as it is comitting the data after a few runs.

    It's abit annoying that we have to check all the DBS/DBSS cells to see if they have been sent. Has anyone tried this before as it's like PAfE is chewing the data send over in bits?
    FYI: There's a few macros in the sheet.
    The formula looks as following:
    =@IF(AND($F$2="SEND";E9<>"");DBSS(E9;$B$1;$C$2;$C9;$C$3;$B9;AF$8);"")



    ------------------------------
    Lucas Dresler Bækmark
    ------------------------------

    #PlanningAnalyticswithWatson