Pyramid Open AI Evaluation

Hey there,


we are currently discussing the open ai integration in pyramid to integrate and therefore need to test that functionality upfront. I cant find the open ai integration in the pyramid explore server and the documentation is not clear about the exact features (where it can be used, what it can do etc..). Is there a way to test it somewhere? Or to get more details and examples about it?


Thank you,


7 replies

    • NPANS
    • 3 mths ago
    • Reported - view

    If you go to online help, and search for "OpenAI" you'll find all the details you are after.  It's pretty clear, explicit and enumerates every feature that is currently offered.

    • Fabian_Frank
    • 3 mths ago
    • Reported - view

    I dont think so, the only doc being a candidate like that is https://help.pyramidanalytics.com/Content/Root/Guides/AI/GenerativeAIintegration.htm?Highlight=openai in my opinion., But its lacking the description to query data in Tabulate or Discover, which I found out today is available?

      • Nkhensani_Khoza
      • 2 mths ago
      • Official response
      • Reported - view


      The document you reference explains where you can use OpenAI and where it is available for you to use. Yes OpenAI is also available in Tabulate and Discover. You can test it in the explore server, it is available there!

      You can also spot  OpenAI by the chatGPT logo:  The below examples are completed in the Explore server.  

      1. in Discover here is an example in the Explore server. 


      as stated in the help guide, it is also available in other areas in discover . These values generated by OpenAI can be used and integrated with your data


      2.  In tabulate is available in generating scripts to build spreadsheet formulas 

      Kind Regards 

      Nkhensani Khoza 

      • Fabian_Frank
      • 1 mth ago
      • Reported - view

      thanks for your help :)

    • Fabian_Frank
    • 1 mth ago
    • Reported - view

    can someone tell me how to use the discover function efficiently and refer to data? it seems that chatgpt does not have any clue about the data. Is that even possible?

      • Fabian_Frank
      • 1 mth ago
      • Reported - view

       An example use case would be "what is the highest population" and add that in a dataset.

      For example like in pandas alike:

      df["AI Driven Value Year (7)"] = df["Population"].max()
      • imbarmarinescubar_pyram
      • 1 mth ago
      • Reported - view


      The ChatGpt function within the Formula designer does not have any context that is not given to it directly.
      Also, like any other Formula, it is calculated in the scope of the datapoint that you are looking at.
      So, you can write something like this:

      chatGpt("what is the capital? for: " + [customers].[Country].currentmember.caption)

      Which will inject the country from the grid, producing:

      To do something like maximum population, use the Max function wrapping a chatGpt population question:

      max([customers].[Country].allmembers, chatGpt("What is the population size? for: " +[customers].[Country].currentmember.caption + ". Return result as a number"))

      (I have USA in the bottom of the grid)

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 7Replies
  • 90Views
  • 4 Following