0

Failed while creating Formula

I am facing below issue while creating formula for particular column.

failed run sql query in model source. model: SELECT SUM([_AddInfosMoves_Allowed_].[ID_AddInfos]) [SUMmzrAddInfosMovesA6mw09sKFNR]
FROM [AddInfosMoves_Allowed] [_AddInfosMoves_Allowed_]
LIMIT 20000001, query: 10000000-0000-0000-0000-000000000111|Tech- K|752b6e6f-c6c7-4a39-a757-e73cd2c22bd3|

 

Please See below screen-shot:

1 reply

null
    • imbarmarinescubar_pyram
    • 4 yrs ago
    • Reported - view

    Hi mangesh desai ,

    It looks like connection/modeling issue - no problem with the formulation but the actual data doesn't connect.

    Can you run a query against that model? Maybe open a discovery for it and add the "id addinfos" measure to a grid to see if you get a result.

    Also, I'm assuming you are trying to get the last 2 letters of the caption of that element, right?

    Then you should use [Inventory_CP].[Physical_stock].[1: 0-30].caption.

    What you used is getting a numeric value of that member and not the caption of it.

     

    Thanks,
    Imbar

Login to reply

Content aside

  • Status Answered
  • 4 yrs agoLast active
  • 1Replies
  • 26Views
  • 3 Following