-
Paging for long tables
Hi, We are in the process of converting a legacy system to Pyramid and are facing a challenge regarding long tables over 30K rows. We don't want to show long table and are looing for a way to load…
- Answered
-
Make maps less that 180x180
How can I override the bottom limit on the size for view on the canvas. It appears that it automatically goes to a BAN when the width or height is <=170 px.…
- Answered
-
Matrix Grid multiple rows not expected
In the table shown, there is only one value (quintile) for each row (State) and column (Type). Why does each state have multiple rows? How can I get it to only show populate cells?…
- Answered
-
Remove dimension from data label in tile plot.
I want to edit the data label to only show the State abbreviation. I don't need to show the dimension Quintile Name in the tiles. It is picking this up bc it also defines the color.…
- Answered
-
How to get export of Excel file which is getting used in the report.
Hi, I have a demo report. In the model of that demo report, they are using one dataset. I want to export that data file which is in Excel.
- Answered
-
How to create group headers for certain columns in Discover
What are the steps to create grouped/merged column headers in discover for Name and Address in Row 1? the discvover has 20 columns so adding just a text box in Present doesn't work well with the side…
- Answered
-
Sorting with Trellis
Hi, I have a trellis graph and I want to be able to sort values descending on both graphs separately. At the moment it half sorts the graphs, as you can see below it picks up the largest value…
- 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
-
How to restore a deleted workflow?
- 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
-
Possible to use publication outputs an input to model?
Hi A Publish can only publish files to email and internal, not a shared folder as far as I'm aware. I'm in a situation where I'm using a publication to extract a lot of data,…
- Answered
-
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
-
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
-
Difference actual week- week prev year
Hello, we would like to calculate the difference of an KPI actual year vs Previous year on weekly base (KW this year - KW prev Year). We have time attributes for Date, KW (i.e.…
- 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
-
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
-
First time buyers
Hi I have a data set that has retailers, sales value and sales date starting from Jan 2022 to current month and I would like to do the following: Firstly - I would like to determine the date the…
- 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
-
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
-
Table of Contents UI
Hi, When I export a dashboard which includes a table of contents from the dynamic text feature, the contents list isn't included. Are there any settings which need to be selected to include this?…
- Answered
-
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
-
Customize a Breadcrumb Subtitle
Hi. Is there a way to customize the breadcrumb in a subtitle on a Presentation such that only the slicer values are displayed, and displayed in the order they appear in the presentation?…
- 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
Got stuck with a report? Start a discussion or help others to move forward.