-
How to remove special characters from a string in Data Modeler?
Sometimes when you are importing data from a source, a column may have non-alphanumeric characters (aka special characters). How can I remove these characters? For example,…
- Answered
-
Smart report bursting with triggers and repeaters
As described in my previous blog post, bursting static analytic reports to recipients is still a very common “real-world” requirement—and it’s still a headache for many BI developers and…
-
[Publication] Page repeat children of filtered/selected member
Hello, I am wondering if it is possible to filter a Publication and having a page repeater export the children of the filtered member. For example: I would like to export a publication for Europe,…
- Answered
-
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
- Answered
-
Delivering impact: Report bursting and distribution with Pyramid
Bursting analytic reports to recipients is still a very common “real-world” requirement—and it’s still a “real-world” headache for many organizations who depend on published reports to communicate…
-
Dynamic Scaling of Analytics with Pyramid on Kubernetes
Pyramid’s multi-tiered service architecture is a perfect fit for Kubernetes-based container deployment, allowing distinct services to scale and shrink dynamically to match demand.…
-
Adding "All" to a slicer
HI this seems like it should be straightforward. I have a tick box slicer with numerical values which allows me to pick an "all" option. But I have another Drop Down which is Text items and does not,…
- Answered
-
Hybrid Data Connectivity via Pulse
With increased cloud choices, and distributed servers, it is common for many organizations to have a BI server in the cloud, remote data sources, and end-users in different locations,…
-
Gaining control of your data with Master Flows
Data preparation processes (ETL) frequently require workflow capabilities to conditionally trigger other processes and send notifications (email, text, etc.) when a task has completed.…
-
Faster processing and reduced resource consumption with incremental data refreshing
It’s very common for organizations to possess large datasets that only require periodic updates on a smaller subset of the data. In other words, only new data or data that has been recently updated…
-
How dynamic KPIs provide better views into constantly changing datasets
KPIs play a crucial role by providing an instant and intuitive graphic view of a business’s key performance metrics. In order to effectively create KPIs,…
-
Embedding with native HTML5
Companies increasingly need to include analytical content into their own applications and workflows, instead of having to access a separate application.…
-
Action - Jump to Content. Hide the background slicers?
Ok so an Action is applied to open a discovery in a pop-up. The functionality works great as it takes the context in the cell which is right-clicked and uses that in the pop up.…
- Answered
-
What's this called please? ("Actions")
I have a discovery table in a presentation, DimensionA vs DimensionB with a measure in the values. I'd like the user to be able to select a cell in that table,…
- Answered
-
Accidentally pressed "Auto Interact"...
OK so I've made this mistake before, but this time it's really ruined my presentation. I have saved since as hadn't even realised I pressed it. Is there a way to undo all the knitting it has done…
- Answered
-
Authenticating with ADS when Pyramid Analytics hosted on AWS
Hello, Does anyone have tips on setting up Active Directory Services (ADS) authentication in Pyramid Analytics running on AWS. ADS is running on local network and Pyramid Analytics is running on AWS.…
- Answered
-
Parse excel doc
I want to parse excel document to lists in Python. Is there a python library which is helpful for this action? And what functions are relevant in that library?
- Answered
-
Python and Excel
What is the best way to read Excel (XLS) files with Python (not CSV files). Is there a built-in package that is supported by default in Python to do this task?
- Answered
-
Adjust difference between slicers in Discover & Present
We are missing "Combined Elements" as a type in the "Present" slicer At this moment we are using the slicer we made in "Discover" and drag the slicer to "Present", but this is a trick,…
- Answered
-
Best method for displaying four measures on the same visual
We have previously upgraded our Pyramid version from 5 to 2020.10. We used to use funnels to show four related measures on multiple reports, however, as we have seen in the help documentation,…
- Answered
-
Discover - Viewer - Descriptions
Is it possible for users with the viewer license to see any of the metadata associated with Discover? I'd like the viewers to at least see the description text.…
- Answered
-
Pyramid 2020.15 Released
Pyramid 2020.15 has been released and includes primarily a collection of functional fixes and important security upgrades. Software The main installer files can be downloaded from the Pyramid…
-
Python
I have a question regarding to python. I want to add the list below into a column and append it to my existing excel file list = [2,3,4,5] Original: After: I have converted my excel to panda ...
- Answered
-
Customisable Linear Regression Line Scatter Chat
Hi we have a scatter chart and we are looking to create a line which is Y (Premiums)= X (Claims) so that anything below the line is a loss and anything above the line is profit.…
- Answered
-
Ranking a measurement linked to more than one dimension
Hello The rank statistical feature returns the rank of a member in the specified list. The list used must be a list or set of elements from the SAME hierarchy as the member in the model.…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community