-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Motion ranking
Hello all, very new to Pyramid (day2) and I've got a bar chart with date driving motion and am trying to sort the display order of the bars to always be descending (so they may have to swap places…
- Answered
-
Data model Hierarchy - Tree slicer
Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…
- Answered
-
change start of week in Data Flow (Advanced Time Intelligence)
Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…
- Answered
-
Concatenate dimension values
Hello, Is there a way to concatenate two dimension values, like customer number and customer name, in a formula? As an example we have customer number "123" and customer name "ABC Appliances" and we…
- Answered
-
custom login page
Hello, How do I send the login credentials from a custom HTML login page with the link to the specific dashboard URL? Thanks
- Answered
-
Notification for failure of scheduled model refresh?
Is there any way to send a notification when a schedule model refresh fails?
- Answered
-
Creating a calculation to provide difference between two columns of numbers
We have reports that use named sets to provide four years of data and need to show the difference between the last two. We've done it with a quick calc using data points but we find that these hard…
- Answered
-
Top N - List
Hi We have a list of days which are numeric but not a measure. the values range from 0 to 900. We want to only show the element where they are greater than a specific value set by a continuous…
- Answered
-
Get notified if Pyramid Services go down
We have had sporadic instances where some of the Pyramid Services crash. It gets reported in the logs. Is there a way to have Pyramid notify our admins when this happens so they can restart the…
- Answered
-
Date Parameter Slicer Issues
I’m new to Pyramid 2020, coming into it from BI Office and struggling to create parameters for date selection. In most of our BI Office reports we created an Advanced Data Set from a Date Hierarchy…
- Answered
-
What is required for my company to use Pyramid on mobile devices?
I want to use Pyramid on my mobile device. How do I get access to it? Is the functionality included or does it cost extra?
- Answered
-
Do Desktop and Mobile dashboards use the same URL link?
When I convert the desktop dashboard to a mobile dashboard then do we keep the same link for both the dashboards or there are two different links to access the dashboard?
- Answered
-
Authentication by Azure Active Directory (AAD)
Dear Pyramid, on behalf of my company's system admin I would like to ask the following question: Are there any plans to support native Azure Active Directory Authentication using Microsofts…
- Answered
-
Unique Customers count that bought multiple items at a site
Okay, banging my head and it hurts. While the actual data is patient centric around different codes styles of Veterans Administration will ask it in sales terms.…
- Answered
-
How to use ML to categorize or classify comments?
I have a comments field that people want to classify into around 10 different values. Is there a built in algorithm that would help with this type of text classification?
- Answered
-
Is it possible to use SSAS Tabular models as sources for other Pyramid models?
Can SSAS Tabular models be used in the Data Modeler as a data source?
- Answered
-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
Greater Than Filtering in a Discovery
I am looking to do Greater Than filtering rather than Top N, where I want to include a set of values where any one of those values breaches a threshold,…
- Answered
-
How to import multiple Excel files in Data Modeler?
Is there a way to loop through multiple Excel spreadsheets with the same format and load the data into the in memory database?
- Answered
-
Changing Slicer Settings
I've noticed that when I change a slicer from Single Select Tree to Multi Select Drop Down that it places my Single Select Tree selection into the background and does not change the Slicer Type.…
- Answered
-
Do interactions work with Actions?
Can I use Interactions along with Actions? How does it work together?
- Answered
-
Can dynamic texts be used for creating click actions?
If I add text objects to a dashboard, can I add actions to them?
- Answered
-
Can you create Actions in Pyramid 2020 if the source is a SSAS model?
Are actions available for models built in SQL Server Analysis Services or is it just for Pyramid In-Memory Databases and SQL models?
- Answered
Got stuck with a report? Start a discussion or help others to move forward.