Office Hours Question

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

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

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

Percent of Parent Calculation

How do you create a % of parent calculation in script mode?

• 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

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

What resources are currently available for users looking to start building ML models in Pyramid?

• Answered

Do interactions work with Actions?

Can I use Interactions along with Actions? How does it work together?

• 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

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

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

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

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

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

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 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

Can you create statistical test on the fly such as Chi square test or F-test?

The example formula I am after is this: (expected-actual)^2/(expected) The challenge is the exponent value. How do I add that?

• 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

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

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: How do you view the underlying query for a Discover Report?

Could you show how to view the mdx?

• Answered

Pyramid Office Hours 4/16: Creating Animated Visualizations

Do you have an option of a play button on a scatter plot?

• Answered