Skip to main content
User Community
Pyramid
Help
Learning Hub
Support
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Questions & Answers
Explore Pyramid
Product
News & Events
Member Lounge
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
VP Product Management
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
1325
posts
486
likes received
18
followers
Badges
3838
48
10
1
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Reset query context on a click action
No reply after two months, so setting status to answered.
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
19 hrs ago
Questions & Answers
Reported - view
Re: "Last N Weeks" Function in Calendar Slicer is Misleading
Hi @TKH TKH If you consider this to be a bug, then please open a support ticket on this topic. If you are making an enhancement request, please repost in the Current Product Ideas Forum.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
19 hrs ago
Questions & Answers
Reported - view
Re: Workflow Versioning
@Stefano Sena If you edit a Data Model and simply save it as new version, then you are simply saving your edits to the Model and not overwriting the previous version.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
22 hrs ago
2
Questions & Answers
Reported - view
Re: Service Instance Memory Limits
Hi @Mad Amruthur ,@Surya Sankar Note also that there are limits to what can be exported to Excel based on the capacity of the client machine connected to Pyramid.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
yesterday
Questions & Answers
Reported - view
Re: Can I have list of all the cshids used to divert help button
Hi @Nandita Gupta I'm not sure what you are asking for. Can you explain a bit more? Thanks, Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
yesterday
Questions & Answers
Reported - view
Re: Workflow Versioning
Hi @Stefano Sena Read this Help page and come back here if you have any further questions. Generally, Save as New Version will do exactly that, it will create a new version and NOT overwrite the…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
yesterday
Questions & Answers
Reported - view
Re: Hide or Unhide Slicers
Hi @Linda Cowie ,@Ove Sandau Ove is right, this is the right way to approach this. Take a look at this Help page for more detailed examples of how to set it up. Hope that helps! Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
2 wk ago
Questions & Answers
Reported - view
Re: Binary Code to HTML in Pyramid
Hi @RAJESH Gonuguntla This is not currently possible. Sorry about that. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
3 wk ago
1
Questions & Answers
Reported - view
Re: Minimum Date
Hi @Daniel Quinonez You can create these Measures directly from your Date Attribute. Right click on your Date, select Aggregate, then Min or Max. This will generate the min or max date for anything…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
3 wk ago
1
Questions & Answers
Reported - view
Re: Is there a way to show a measure only once when we have repeating dimension values?
Hi @Robert Clark Make sure your subtotal settings are set to AGGREGATE and not SUM and it should give you the right answer. Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
3 wk ago
1
Questions & Answers
Reported - view
Re: Minimum Date
Hi @Daniel Quinonez The easiest way to achieve this is to create a Measure from your Date dimension in your model and use the Minimum aggregation method.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
3 wk ago
1
Questions & Answers
Reported - view
Re: Using Regular Expressions to replace
Hi @Stefano Sena Not directly in the Replace block. As you illustrate, you can use Regular Expressions to search for strings, but not use them to replace.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
3 wk ago
Questions & Answers
Reported - view
Re: PYTD vs YTD Comparison , while Not Showing Dates
Hi @Luke Dyer Is the PYTD from the beginning of last year up to the same date as today but last year? Or up to Today's date? If the former then these two code snippets should work,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
4 wk ago
Questions & Answers
Reported - view
Re: How do I upload my corporate font?
Hi @Ricky Melamed You need to be able to access the admin console and use the Custom Fonts option under the Design section: You can then add additional fonts,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Move the rows header column to the right?
Hi @Ricky Melamed Only for Tabular grids, i.e. just columns, no rows: Unless of course you are comfortable working in Hebrew or Arabic, LOL. Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
1
Questions & Answers
Reported - view
Re: Execution Solve Order Explanation
Hi @Darren Tuffs Excel has the same problem / solution, https://excelk.com/en/solve-order-en/ Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
2
Questions & Answers
Reported - view
Re: Attach pdf as an attachment in email node
Hi @Raveena Mariappan Just to clarify: Published “document” outputs can be sent as links (standard) or attachments in an email based on a switch which is separately licensed.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Can Supabase be used for the Pyramid repository?
BTW, If you want to use Supabase as a data source, use the PostgreSQL connector but use the connection details for transaction or session pooler. It works fine: Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
2
Questions & Answers
Reported - view
Re: Can Supabase be used for the Pyramid repository?
Hi @Robert Clark No. We only support vanilla PostgreSQL, Oracle and SQLServer as database servers for the Pyramid repository. Supabase may well claim that they are simply PostgreSQL as a service,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Choose which 6 options are available on the popup
Hi @Ricky Melamed I'm not sure I understand what you are asking. By turning off the options in the Runtime Settings, you are choosing what shows up. Do you mean can you create your own options and…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Attach pdf as an attachment in email node
Hi @Raveena Mariappan If you are creating and sending an email using Publish, then there is no option to attach a document to the email. Analytic content is generated in the body of the email as…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Choose which 6 options are available on the popup
Hi @Ricky Melamed You can use the Runtime Settings dialogue to turn off options: Hope that helps. Ian
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Clarification regarding the model_name column
Hi @TKH TKH As a general rule, Pyramid does not support nor encourage investigation of the structure of the underlying repository schema. Apart from the published "usage" model,…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
1
Questions & Answers
Reported - view
Re: Best Practice for Isolating Self-Service Workloads in a Single Installation
Hi @TKH TKH Currently you cannot allocate a specific runtime engine to a specific data source. You could have multiple IMDB servers though and reserve one for your production solutions and the…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
1 mth ago
Questions & Answers
Reported - view
Re: Best Practice for Isolating Self-Service Workloads in a Single Installation
Hi @TKH TKH It's not clear from your description whether you are running a single Pyramid instance on one server, or a single Pyramid instance across multiple servers.…
Ian Macdonald
Admin
VP Product Management
Ian_Macdonald
2 mths ago
Questions & Answers
Reported - view
1
2
3
4
5
28
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Highlights
Product Ideas
Current Product Ideas
Archived Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Install / Upgrade / Cloud / License
Model
Performance
Present
Publish
SAP
Security
News & Events
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
Member Lounge
View all topics