-
How to modify the WHERE clause conditions of SELECT statement before sending the query to database
Hi Assume I have a fact table (FactSales) and two dimension tables (DimDate and DimProduct) setup in a star configuration with following relationships FactSales.Date = DIMDate.Date FACTSales.…
- Answered
-
Using a string variable in sql script
If we use a string variable in PQL editor while creating a SQL Script node, the variable is being enclosed in quotes that is causing the sql to fail. Example: @ColumnList is set to: column1,column2,…
- Answered
-
Azure Conection to Pyramid
How can I remotely connect to a virtual machine in Azure that has Pyramid installed ?
- Answered
-
PQL Dynamic text formatting
Hi, I'm trying to write a PQL for dynamic text, so that when the data value selected in my matrix is equal to or greater than 0 it's formatted as Green.…
- Answered
-
How to register an APP in Azure for OAuth connections to Snowflake or Azure Synapse in Pyramid.
1) Register an App in the Azure portal Required fields: Name: give the app a name Supported account types: choose the option that you require. Redirect URL:…
-
Is there an example of how to use the API's to export a discovery as a PDF?
Hello, I've read that it's possible through the API's to export discoveries. Does anyone have example code of how to export a discovery to a PDF using the API's? Thanks, Rob Clark
- Answered
-
Unable to see discovery in Present
Hi , I am able to see the discoveries in my slide in the design module but it shows some error when i run the Present
- Answered
-
Dashboard Gallery: Service Management
Dashboard Gallery: Service Management This Dashboard condenses a lot of information in one single page. Ideal e.g. for a Manager overseeing operations wo needs quick visible cues and then act and/or…
-
Create general tabs in the My Hub (Home) area
Hello Pyramid, we think the Home or My Hub environment is a great idea. However, we would like this environment to be displayed by default when Pyramid is started.…
- Answered
-
Firewall Settings for Pyramid
When Pyramid is installed across multiple servers and there are internal firewalls between them, the following ports must be opened between all servers. All ports are TCP.…
-
CouchDB No SQL Database as a data source
HI everyone, Is there a way to connect a NoSQL Couch DB database to Pyramid? Thanks, Sonia
- Answered
-
How to create a Pyramid website in IIS after an install.
If you have decided to use the IIS option after the Pyramid installation, you can add the site manually. First, you need to install the following IIS modules :…
-
Learning Live: Pyramid and Embed
About this Video: In this week's learning live, we cover the options that Pyramid gives you, when you plan to set up an embedded environment to provide your customers or other external viewers of…
-
Pyramid Learning Hub: New Pyramid 2023 Courses and Updates
New Courses for Pyramid 2023 and an updated Model Advance Course! With Pyramid 2023 a lot of the content for our courses has changed, we are regularly releasing refreshed courses for this new version.…
-
Dashboard Gallery: Financial Services
Dashboard Gallery: Financial Services Dashboard has been developed as a showcase based on public data. It give you a view into loan data and the connected risks when the loan crisis hit.…
-
Using SQL queries to build reports
Hello, Is there a way to use SQL queries to build the reports themselves? Forgive my unfamiliarness with Pyramid, but I only see the option to query using SQL when creating a data model.…
- Answered
-
Delete vs Purge ???
Recently, we created some content in a Workgroup Content folder and then moved the content to a folder in Public and deleted the content in the Workgroup folder.…
- Answered
-
Revoking Admin/User tokens
Referring to the below REST API reference, the admin token generated using REST API seems valid forever, Is there any way to revoke/invalidate the token once generated.…
- Answered
-
Preset number of Y ticks in advance
Hi, I want to build a line plot in discovery that would have pre-set 5 parts to split into, no matter the data min and max. Meaning, If I have 0 as Mix measure and 100 as Max,…
- Answered
-
Dashboard Gallery: Four Analytics Types
Dashboard Gallery: Four Analytics Types in one view Decision intelligence has four time perspectives when working with the existing data. This Dashboard shows what the different Types are and what…
-
Learning Live: Pyramid with OpenAI and ChatGPT
About this Video: In this week's learning live, we will explore how ChatGPT can be utilized to analyze workflow conversations effectively. Leveraging Pyramid's capabilities,…
-
Creating "1st Month of the Year of the Previous Month" in a list
I have the following as a Range List which is the *First Month of Current Year* until previous month I want to change the start of the list to be the first month of the previous year instead.…
- Answered
-
How to use ChatGPT to analyse workflow conversations
How to use ChatGPT to analyse workflow conversations This session will show how ChatGPT can categorize and summarize workflow conversations. Pyramid allows users to start a dialogue against a…
-
How to add Seasons to your Time Dimension
How to add Seasons to your Time Dimensions When building a data model the Time Intelligence option will automatically additional time based attributes based on any date fields.…
-
Dashboard Gallery: Sales Dashboard
Dashboard Gallery: Sales Dashboard In this Sales Dashboard we find a compact overview about all information a sales leader needs on their fingertips to stay on top of the current development…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help