Latest Activity

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

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

Complex report table

The tutorial videos show only simple tables, which are perfect for dashboards. My customers need more complex table reports like the attached. Is it possible to build a this report by only one…

• 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

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

Drill Down in an inner dimension of two nested ones

Dear Pyramid-Team, assuming the following situation: Two dimensions are nested in the rows of a table grid (e.g. Customers as outer dimension and Products as inner dimension).…

• Answered

Columns position in Discover Tablix

In smart discover how can i Switch between the columns position in tablix/Matrix

• Answered

Dynamic formatting of table headers

Dear Pyramid-Team, when using OLAP-Cubes of MSAS, Pyramid is able to use the Measure formats defined in the cube. As far as I know, this definition can also be dynamic (e.g.…

• Answered

Relation between discoveries

My question is : At first, I create new discovery as A, in A I choose product codes using some filters and measure, as a result, I have 100 product with their sale.…

• 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

PQL for dynamic text

Hi, I am struggling to write a PQL part for dynamic text to show the last day of the previous month based on current date. is it possible and anyone able to assist? many thanks

• 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

Custom sort ordering - order by top N but leave "other" at bottom

Hi I have a table which shows the top N brokers, and then has the rest in an "other" bucket.. this works brilliant but I need to sort by the top N by premium but leave the "other" bucket at the…

• Answered

Change Discovery Column Label without Changing the Measure Caption throughout the system

Hello, For different discoveries we would like to have different titles on the columns. However, if we go to a measures properties and change the caption it changes it for all reports.…

• Answered

Snapshot of Incomplete Encounters

Instead of a rolling number of open encounters from mth to mth, I am trying to capture a snapshot of mth to mth of open encounters to show a trend. Any ideas on the formula?

• Answered