Latest Activity

Best Practice for Isolating Self-Service Workloads in a Single Installation

Hello PA-Team, I'm looking for advice on a common enterprise challenge: how to ensure the stability of my critical corporate reports in a mixed-use environment where self-service users are also…

• Answered

Clarification regarding the model_name column

Hello PA Team! While exploring the Pyramid repository database, I came across something I'd like to clarify. I noticed that in the public.server_log_transaction table,…

Dynamic formulation for full year / rolling 13 months

Hello everyone, We currently use the following formulations to ultimately display the rolling last 13 months ("Rollierend") or the entire year ("Gesamtjahr") via a button in the dashboard.…

• Answered

Adding Security to a Dimensions so only a small group of users can see and use it

Hi is there a way to have a dimension that only a small group can see and us it? I want to use a dimension in a report but I want to be the only person to be able to select it.…

• Answered

When search for contains, how to specify?

Just say I have a dimension, "Model" and within Model there is an element "THIS IS AN EXAMPLE". I want to be able to search for "IS" without "THIS" being shown as a result.…

• Answered

Tooltip-Designer

Hello everyone, I would like to create a tooltip in a dashboard. The font size is set to 120. If I reduce this to the desired font size (e.g. 12), this is done with one click.…

• Answered

Prioritize the Discover level over the Presentation layer when displaying or hiding specific dimensions using the Runtime Settings

There are specific scenarios where we may want to swap a chart's dimensions using only certain predefined dimensions. To achieve this, we use the Runtime setting at the discovery level for that…

• Answered

Specify an indicator on a specific dimension's element.

Is it possible to use a KPI as an indicator only on selected elements within a dimension? Currently when I drag the KPI into the indicator, it will apply it to all the elements.

• Answered

Limit dates in a slicer to after the last date selected in a date range filter

I have a calendar-type slicer. When I select a date range representing opening dates during that period, I want another slicer for evaluation dates to show only dates that are on or after the last…

Reset query context on a click action

Is it possible to use a click action or something similar to reset the query in Present? I've got two visualisations controlled by a mini tab - if the user selects an element on chart 1 it filters…

Like for Like reporting

Hi, I'm trying to do some like for like reporting - i.e. if one of our locations wasn't open more 365 days ago, we need to exclude the location from our report.…

Suggestions for Tabulate Excel Export Formatting and Multiselect Slicer Settings

Hi Community! I have attached a step by step procedure to almost have an excel export with formatting using Themes. But having issues (i.e) while saved and run,…

'Average' line that has no data points

Hello, When I add an 'Average' line it has data points for each full month name. I want it to have no data points despite the other data on the line graph having data points.…

• Answered