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

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

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

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

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

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

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

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