-
Can you change the headers of the columns?
When displaying data in a grid, the column headers are based on the attribute names in the model. Is there a way to rename these columns in the grid?
- Answered
-
How to create date ranges and aggregate them?
Is it possible to create a date range with Start and End dates? If so, can we aggregate the range to show the values as Average or Sum?
- Answered
-
How to get the Content Path from the Pyramid Repository in Usage Reporting
In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- Answered
-
Passing Parameters to Stored Procedures
If we have a Stored Procedure in the database server to which I need to pass a decryption key (string/text) in order to decrypt the numeric sensitive data,…
- 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
-
Dynamic Date Parameters
Are you able to make the maximum year in a date parameter dynamic? So that right now it would give options up to 2020 – but next year, it would automatically update to 2021 without requiring us to…
- Answered
-
Pyramid Office Hours 4/16 - Setting Data Based Colors
In the Color options, is there a way to "hard code" which colors I want for which values? For example, I want everything > 5 to be red, everything <= 5 to be green, can we do that?
- Answered
-
Do interactions work with Actions?
Can I use Interactions along with Actions? How does it work together?
- 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
-
YTD Functions
For the YTD to work properly, do you need to have a date field in your model? Or can it also work on 'text fields' set as your periods?
- Answered
-
Marketplace Scripts in Modeling and Formulate Modules
The Marketplace shows up in the Data Modeler module and the Formulate module. The question is what is the purpose of the marketplace in both modules, as they appear to be different?
- Answered
-
How to launch dashboards via Actions?
Is it possible to use an action to open another dashboard? For example, I’d like a summary dashboard to link out to a detail dashboard to drill down, essentially.
- Answered
-
Pyramid Office Hours 4/16: How do you view the underlying query for a Discover Report?
Could you show how to view the mdx?
- Answered
-
Do publication triggers check slicer values, one by one?
If I have slicers configured for a publication, do the triggers check the slicer values as part of the evaluation process?
- 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
-
How to add two members together?
Let's say that we have a report that contains a list of countries. Is there a way to combine two or more countries into a new aggregate value. For example, Canada + USA = North America?
- Answered
-
Pyramid Office Hours 4/16: Using advanced analytics in the Discover Module
We had two questions on this topic: Is it possible to obtain the model diagnostics? for example, how do we identify which products have been assigned to each cluster? Generally in Linear Regression,…
- 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
-
How to add text in the header or footer of a publication?
I would like to add header and footer text to my publications. Is there a way to include titles and page numbers?
- Answered
-
Pyramid Office Hour 4/16: Can context calculations use free form text?
Can you have user defined formulas using free form text when creating context calculations
- Answered
-
Pyramid Office Hours 4/16: Creating Animated Visualizations
Do you have an option of a play button on a scatter plot?
- Answered
-
How to remove the descriptive text above a Discover Report
When you work with a grid in Discover, there is a text thread above it that contains all of the selected values in the query. Is there a way to remove this from the view?
- 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