In Pyramid Analytics, we can translate almost everything - formula names, attribute names, metadata, even auto generated insights can be matched to the user's default language. 

But chart titles work a little differently. They stay set to the original saved name we gave to the chart. That means, even when your dashboard language changes, your chart title might not. Unless, you handle it dynamically.

✅ Switch from Static Titles → Dynamic Text

Here’s a clean way to make chart titles automatically match the selected application language:

1. Turn OFF the default chart title field in the presentation layer 

2. Insert a Text Box instead, positioned where the title would normally go

   

3. With the Text Box Selected

   1. Click on the Text Ribbon on the top left

   2. Click on Dynamic Text

4. In the panel that will show up

   1. Select a grid - ideally something simple and is used by the dashboard. Your dynamic text won't work without making a selection here.

   2. Enter your logic using a case statement to match the application language to what the title should be

   

5. Repeat as needed for all your titles

💡Taking it further

You can further simplify this by uploading a data table that contains all the names of charts in all the languages you need. That way, you can create a grid and use that to match the application language to the corresponding title in the table instead of manually typing in the formula box.

✨ A pretty simple tip but I hope its useful. Happy building!

sudo systemctl restart pyramidAgent
sudo systemctl restart pyramidRTE
sudo systemctl restart pyramidRTR
sudo systemctl restart pyramidWeb
sudo systemctl restart pyramidTE
sudo systemctl restart pyramidIMDB
sudo systemctl restart pyramidNLP
sudo systemctl restart pyramidSOLVE
sudo systemctl restart pyramidFs
sudo systemctl restart pyramidAI
sudo systemctl restart pyramidPG (only if you are using the Pyramid Postgres as a repository)

You can also use one command to restart all of the Pyramid services:

sudo systemctl restart pyramid*

To stop the services, use these commands:

sudo systemctl stop pyramidAgent
sudo systemctl stop pyramidRTE
sudo systemctl stop pyramidRTR
sudo systemctl stop pyramidWeb
sudo systemctl stop pyramidTE
sudo systemctl stop pyramidIMDB
sudo systemctl stop pyramidNLP
sudo systemctl stop pyramidSOLVE
sudo systemctl stop pyramidFs
sudo systemctl stop pyramidAI
sudo systemctl stop pyramidPG (only if you are using the Pyramid Postgres as a repository)
sudo systemctl stop pyramid*

To start the services, use these commands:

sudo systemctl start pyramidAgent
sudo systemctl start pyramidRTE
sudo systemctl start pyramidRTR
sudo systemctl start pyramidWeb
sudo systemctl start pyramidTE
sudo systemctl start pyramidIMDB
sudo systemctl start pyramidNLP
sudo systemctl start pyramidSOLVE
sudo systemctl start pyramidFs
sudo systemctl start pyramidAI
sudo systemctl start pyramidPG (only if you are using the Pyramid Postgres as a repository)
sudo systemctl start pyramid*

To check the services' status, use these commands:

sudo systemctl status pyramidAgent
sudo systemctl status pyramidRTE
sudo systemctl status pyramidRTR
sudo systemctl status pyramidWeb
sudo systemctl status pyramidTE
sudo systemctl status pyramidIMDB
sudo systemctl status pyramidNLP
sudo systemctl status pyramidSOLVE
sudo systemctl status pyramidFs
sudo systemctl status pyramidAI
sudo systemctl status pyramidPG (only if you are using the Pyramid Postgres as a repository)
sudo systemctl status pyramid*

To ensure Pyramid installs Python correctly, please allow access to the following URLs:

For Pyramid 2023.15 onwards allow this links:

https://conda.anaconda.org/
https://conda.anaconda.org
https://pypi.org.
https://files.pythonhosted.org
https://bootstrap.pypa.io

For Pyramid versions below 2023.15: 

• For Windows:

https://repo.anaconda.com/miniconda/Miniconda3-py39_23.5.2-0-Windows-x86_64.exe

• For Linux: 

https://repo.anaconda.com/miniconda/Miniconda3-py39_23.5.2-0-Linux-x86_64.sh

Step 1: Obtain an API Key

To begin using GPT-4, you'll need an API key from OpenAI.
Visit the OpenAI product page, and click "Start Building."

Step 2: Sign Up and Verify Your Account

Choose a signup method and complete the verification process, which requires access to a phone that can receive texts.

Step 3: Create Your API Key

Once your account is verified, create your API key by following these steps:

• Hover over your profile icon in the top right corner and select "Your Profile"

  

• Navigate to the "User API Keys" tab and Generate a new API key

  

4. Save Your API Key

• Give your API key a name
• Click the copy button to copy the key to your clipboard
  
  Note: It's recommended to copy the key to a Notepad document for easy access and safekeeping. Once you close the lightbox, you will not be able to view your key again. If it gets lost, you will need to recreate it for this project.

For further help with regards to Open AI, reach out to their support as below.

Click on "Help" at the bottom left.

 It will allow you to open their support chatbot.

This session will show how ChatGPT can categorize and summarize workflow conversations.

Pyramid allows users to start a dialogue against a particular data point. I have added some comments to a conversation workflow and assigned it to a colleague or a group. The conversation flow and history can be viewed in Pyramid or other collaboration platforms. All conversation data can be directly queried and shared with business users.

Here, we are using text aggregation to consolidate conversations per data model and then applying ChatGPT to summarize key insights from the conversation history.

I can view the number of conversations by data point by selecting a data model. I can also see the conversation history by date and time.

Here, we have used the text aggregation measure to view the entire conversation in a single sell.

By selecting one of these conversations, Pyramid will use our OpenAI integration to provide insights into the data. OpenAI will respond with three aspects. The first shows the main subject categories discussed in the conversation. The second is a conversation summary, and the third classifies if this conversation led to a resolution to the problem or not.

See how to use ChatGPT for workflows in this video

In this session, we have shown how Pyramid can uniquely track workflow conversations by data point, consolidate the text using its text aggregation feature, and then apply ChatGPT to provide insights.

If you have questions or need step by step instructions for this solution, please leave a comment below. Or reach out to Calvin Fuss

How can you share Pyramid Reports and Dashboards in Microsoft Teams

1. Choose the Team where you want to add new Channel with the Report or Dashboard.  Choose the + Sign to add content.

   

2. Select Website and then Name the Channel and paste the URL of your Pyramid Environent into the Field.

   

3. Now your Channel has direct Access to your full Pyramid Content.

   

4. If you want to show a particular Report or Dashboard in the Channel, please access the Asset in the CMS and Copy the link as shown here:

   

5. Proceed as above and copy the Link into the Channel. Now you have the Asset directly in the Channel.
   Note: The content will be accessed with the credentials of the end-user accessing the linked content, which may require an initial login

   

And here is the Video

How to add Pyramid Content to Microsoft Teams

Again a big Thank You to Ove Sandau who came up with this easy solution. For more Tips&Tricks, subscribe to this section of the Community and Check out our Youtube Channel 

Let us know your ideas and comment below

However, if the data sources are not available, you can follow these steps to move IMDB models:

1. Locate the irdb file of the relevant database on the source environment, which is usually found in C:\Program Files\Pyramid\repository\Imdata.

2. Copy the irdb file to the same folder on the target environment.

3. Export the model definitions file from the source environment.
To do this, select the model that you want to transfer and then, click "Export" as follows:

4. Next step would be to "Recognize" the model in the Target system (Data>Source Manager)

5. In the Target environment, locate the database under Admin>Data>Source manager, It should be listed under “Security”.
Ensure that the database has read access to the required roles.

6. Next, go to Admin>Data>Source manager select the IMDB database and click  "Import"  to import the model definitions file exported in step 3.

7. Finally, refresh the page to view the model.

If you haven't done so already, you will need to create a shared folder in Windows.

1. Right-click the folder you want to share and go to Properties.

2. Go to Sharing tab -> Advance Sharing:

   

3. Tick Share this folder and Ok:

   

4. Click Share

   

5. Add Everyone with Permission Level of Read/Write

   

How to  Access a Windows shared folder from Linux using the command line

1. If you don't have it already, you will need to install smbclient, which can be done with the following commands:
           For Ubuntu\Debian: sudo apt-get install smbclient
           For CentOS: sudo yum install samba-client
                                  sudo yum install samba-common-tools
    
2. If you are using a machine that is on a domain, you will need to change the configuration and add your domain by editing smb.conf:
          sudo nano /etc/samba/smb.conf
   And change:
          -security = domain
          -workgroup = WORKGROUP
    
3.  With smbclient installed, you can connect to your Windows share using the command:
          sudo smbclient /PathOfTheSharedFolder -U domain/YourUser
    
4. Enter your user password
    
5. Once authenticated, you are placed at an smb: \> prompt.
    
6. Here, you can use the ls or dir command to list files.
    
7. Use the command get filename.ext to transfer a file named filename.ext from your Windows share to your Linux machine.

NOTE: If the file name contains spaces, make sure to enclose it in double quotes.
For example: get "My new file.txt".

In this case, the requirement is to add an empty column to discovery, in the measures area (For cosmetic purposes)

1.  Create a formula with the word "null" in it and save it as a measure (in the context menu).
    

   

2. Add that formula to the discovery in the Value selection area, and make sure "Show Empties" is turned on.

   

But if another time period is needed and it's available in the model, here is how to show it in your publication.

1. Create discovery and add the period attribute to both Filter and Rows drop zones.
   Once the attribute is placed, make sure that the slicer setting for the "Initial selection mechanism" is set to either "first" or "last" (depending on where the current period is located).

   

   

2. Create a "Dynamic text" element in the publication that will point to the specific Period cell in the discovery.
    

   

   

3. Every time you will publish the publication, the "Dynamic text" will automatically update to show the required time period.
    

   

 "scripting error:Error:package or namespace load failed for ''stringi" was installed     by an R version with different internals"

To fix please follow the below procedure to update R on your Pyramid server(s)

Open the R.exe(run as administrator) which by default can be found here:

C:\Program Files\Pyramid\R\bin\

Then run the below:

update.packages(ask=FALSE, checkBuilt=TRUE, repos="http://cran.case.edu")

Please note that R must be updated on all Pyramid "Runtime" and "Task Engine" servers.

This article currently applies to all versions of Pyramid 2020.

• Version number.
  Some issues may have been resolved over time.
  Knowing your version number can help us reproduce your case and know how to proceed.
   
• Steps to reproduce.
  Detailed steps/actions taken to reproduce your case.
  Background information, like, is the problem user-specific, client machine-specific, Book/Report specific or any other will also be very helpful.
   
• Full-screen image
  A full screen is preferable. In most cases, there are additional details in the background that provide us with more useful information.
  Sensitive data can be distorted/blurred.
   
• Full error or logs
  Click on ‘more info’ to shows the stack trace. (best copied and pasted along with the image).  Even more useful is to retrieve the system logs from the Admin Console. These might revile more information on what happened before the error occurred.
   
• Exported content
  In some cases, we'll need your content (Report/Presentation...)
  These do not contain data. it only contains the report structure and query.
   
• "Structure only" Processed Cube. (.abf file)
  (In a Tabular Model Structure only does not exist. A full processed cube will be required)
  In some cases, where the issue may be related specifically to your data, we'll need along with the exported content, your data.
  Having the cube really helps to reproduce the problem.
  If cube data is required, it can be anonymized/masked cube (with dummy data)
  
  Alternatively, you can download our cube, Pyramid Sales Demo - 278.27 MB
  and try to reproduce the problem.
  Once successful, export and send us the report so we can try to reproduce your case in our labs.