-
Convert measure to dimension & measure
Hello everyone. I'm seeking to create a dimension from a current measure column so that I have this column visible as both a measure and dimension. Cheers, Dave
- Answered
-
Custom column - EPOCH Date
Hi all - Has anyone created a custom column to convert an epoch timestamp into UTC a regular timestamp. I've found several examples like #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0,…
- Answered
-
How to set default value to Slicer(Filter) ?
I have week number Slicer(filter). If my current week is 47 then i want to set 47 in slicer.
- Answered
-
Upcoming features in Pyramid 2018?
Hello, We provide a customised solution built on Pyramid software to our clients. We would be very eager to change into using Pyramid 2018 (we've had some stability issues with BI Office and the…
- Answered
-
Add HTML control to report
How do I add HTML control to a report? More specifically I want to add a hyperlink with an image to a report. Hyperlink will popup a new window and content will be provided by Data Cookbook…
- Answered
-
How to save the Analysis measures.
Hi, I have calculated some measures by using Analysis like Forecast, Regression, Statistics so on. I couldn't able to share(right click -Mark shareable option) the measures.…
- Answered
-
Overlaying columns/bars with integrated variances (IBCS)
Dear Community, the following picture is taken from the IBCS v1.1 (2017). Is there a chance to create something like that with Pyramid? At least something that comes close to it?…
- Answered
-
Previous Month Value
What is the best way to dynamically display the previous month's value in a table based on the displayed value? The available context calculations only allow for difference from previous,…
- Answered
-
Dynamic list that returns latest four months based on current date
Hi there, I currently need help producing a dynamic list that can be imbedded into my 'GAAP Accounting Period' elements list which, based on the current date, selects the last four months.…
- Answered
-
Predictive Modelling Use Case Problem
Hello everyone. I'm having problems working through the Predictive Modelling case study. All is going fine until I get to Step 2. Training The Model, Part 4.…
- Answered
-
Additions to conditional formatting
Hi I reckon this should be a simple one. Essentially it's a combination of the logical band with "positive negative" and the continuous linear function. Say I have a range going from -50 to +200.…
- Answered
-
Moving existing Pyramid 2018 setup to new server
Hi, we'd like to change the server on which Pyramid is installed. What would be the best path to migrate our content to a new machine? Actual setup is using a local Postgre database.…
- 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
-
Making a population pyramid chart - specify total for %, and reverse axis direction
Hi all, i need to be able to create these charts. Percent of total, in agebands split by sex, displayed as a bar chart with one of the sexes using an inverted x-axis.…
- Answered
-
Rolling Average IMDB Model
Hi, Is there any way of creating a 3/6/12 month rolling average in an in memory data base model? I have tried creating a range list between current member and a lagged value but this doesn't seem to…
- Answered
-
Not Displaying formulas in Discovery
Is there any particular reason that all formulas which we have done by using Aggregation Blocks in Formulate-Formula are not displaying in the Discovery? Aggregation Blocks Contain: Aggregation, Sum,…
- Answered
-
best practice for Publication size / amount of pages
Dear community, do you any experience to share when it comes to larger publication objects ? We plan to set up a publication (for PowerPoint output) which may have up to 80 - 100 (!…
- Answered
-
Create Drill through report OR Create Action on column
Hi, How to create drill through report ( Not hierarchy ) on common columns in two separate report ? OR how you can create Action on report ? Thanks Vijay Patel
- Answered
-
Publish email with attchment
Hi team I created an publication and scheduled it. (The output format is pdf or word - still under review which works best). I want it to be send by email and the document to be attached to the…
- Answered
-
Pyramid Analytics API
Good Day. I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
- Answered
-
Parameterised Year To Date
Hi, is it possible to use a parameter to drive Year to Date for current year and previous year? My intention is for the user to select a month e.g. May 2022, this populates two lists.…
- Answered
-
Grand Totals Not Working with Filters
Hi! I don't know if I'm doing something wrong but the Grand Totals are off when you put a filter. It does not recognizes the filtered list, the total is still on the entire data selection.…
- Answered
-
Displaying only yesterdays Date
The data my company collects is a day behind, is there a way to show just the data information from yesterday? Ex: Today is 4/10, the most recent data I have and want to show in the discovery is 4/9?…
- Answered
-
Data Model - ML - Linear Regression
Hi, I'm looking at Machine learning in the Data model section and can't find Linear regression under Machine Learning. Am I missing something? Thanks Jyotsna
- Answered
-
Hiding a Column
Hi, Trying to build a simple report. Are you able to simply hide a column in Pyramid like you would an excel document? For example - Where some columns pull through blank i'd like to simply hide.
- 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