-
Automated Export/Extract to SQL Server
This is a unique client request that I am trying to assist with. The need is to export directly from a Pyramid Discovery to a SQL database. My thought was to connect SQL SSIS job and induct a CSV…
- Answered
-
Subscribe to 1 dashboard in a presentation
Good afternoon, Is it possible for a viewer to subscribe to only one dashboard in a presentation and not the whole presentation? Thanks, Natalie
- Answered
-
Building Custom Filters
Hello, I am trying to create a custom filter for my queries using the Filter() function that I have read documentation on. I believe this will be useful for what I am trying to use it for.…
- Answered
-
Ability to hide the "start new conversation" option when using custom workflows
Does anyone know where the setting is that allows us to determine if both custom workflows and conversations can be used on a particular dashboard? We were able to control this in the past but I…
- Answered
-
Setting dimension elements to a secondary axis
Hi, I don't know if the following is even possible using an OLAP cube model. I'm looking to create a graph to view the YoY data with the percentage change overlaid on the secondary axis as a line…
- Answered
-
Improve Search Functionality of Data Elements
When using the search function (via the magnifying glass icon) for data elements, such as searching for elements when creating a Formula, the output for the search only contains items that begin with…
- Answered
-
Displaying a 0 instead of a blank cell where there's no data for a given date
Hi. This is related to the How To article that Moshe Yossef kindly provided a while back - https://community.pyramidanalytics.com/t/p8hv3sr/how-to-create-a-dynamic-set-of-dates.…
- Answered
-
Content Master Page | Copyright Year
We need to show a copyright year on every slide of our presentations. Currently when we create a new presentation, we add in a dynamic text that shows the year onto the Content Page:…
- Answered
-
Experience on Ipad's
Hi Community, for us it is currently quite challenging to get a good Pyramid experience with an Ipad. We would like to use the pyramid app as it is easier to deploy on multiple Ipad's centrally.…
- Answered
-
How to find weighted average using formulate to be able to use it in reports
Hi Team, I am aware of several measure like sum, average being available.Can you share how i can calculate weighted average? I have a usecase which has several such calculations and to migrate the…
- Answered
-
Obtaining accurate summations in a Many-to-One Relationship
I am having trouble grouping lines correctly so that I can get accurate totals. The basic premise is as follows: We are trying to transition away from buying item A and instead encouraging buying…
- Answered
-
Publication - Use Parameters to determine a selected date range
Good Morning, We have a publication that needs to be repeated by State and Category - this is working well. We also need the client to be able to select a Start Date and End Date to determine what…
- Answered
-
number formatting: negative numbers in parentheses
In Excel, it is standard for us to represent negative numbers such as -123456 in the form (123,456), i.e., negative numbers are printed in parentheses, and there is a comma every three digits.…
- Answered
-
Waterfall Chart to show the actual growth split by category
We need to build a waterfall chart that shows the LY Sales as the first bar, then shows the Actual Growth split by category, then shows the resulting CY Sales figure.…
- Answered
-
Clear distinction between what a Pro user versus Analyst user can do
New to Pyramid and I wondered if I can please get a clear distinction between a pro user and Analyst user- What a pro user can do that an Analyst cannot do.…
- Answered
-
Show an average of the selected members of a filter.
Hi, I would like to be able to show the average of some measures I have calculated. My scenario is as follows: I have some measures shown in a line graph over time.…
- Answered
-
Feature Request: Reversing Axis Value Order in Attached Image
Dear Team, I am reaching out to address a recurring issue we have encountered regarding the axis value order in our charts. In the attached image, we've observed that the axis values commence from…
- Answered
-
Use one chart to filter (not just highlight) other charts
My presentation has the following plots: Overall totals are shown for the current period (gauge) and trended over time (line). These are at the top of the presentation.…
- Answered
-
Measure Waterfall chart operational in version 2020
Hello all, I'm working in version 2020 and I am struggling to get the custom visual measure waterfall chart to behave. Is there a bug within this object.…
- Answered
-
How to include all Context in Action when Jumping from Present to Discover
I want to create a jump to content item action on a Present that carries over all filter values placed on a Discover in the Present. In a Present, I have a Discover with multiple slicers interacting…
- Answered
-
IMDB Setup on a Kubernetes deployment
Hi there, wondering if there is any specific information about setting up the IMDB (in memory database) source server specifically in a kubernetes environment.…
- Answered
-
Option to change the data format to the Europan format: 1.234,56
Hello, it would be helpful to be able to change the data format from 1,234.56 to 1.234,56 as this format is used in Europe. This could either happen in the profile of each user,…
- In review
-
Is it possible to toggle between 3 different date fields on a Present
I have a present with discovers that all are based on time. They show information about loans that have been created over the past X amount of time. This is grouped by a total for each past…
- Answered
-
Question on distinct count for each value
Hello, our business users display campaigns to their customers. When they buy a contract they get a discount. Sometimes a campaign contains more than one discount (i.e.…
- 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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help