Avi Perez's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid

Country

Latest Posts

Security Notice: Linux Installations 2020.00-2020.05

Issue Level: MEDIUM-HIGH Overview The password for the internal system account used with Pyramid installations on Linux servers is not being set correctly to a random value during installation.…
- "making the sophisticated simple"
- AviPerez
- updated 5 yrs ago
- 69
- Security
Re: External Actions / Workflow
No, we don't
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Top N - List
@Nicholas Campbell You can try wrapping the tail function in GetElement, which will return a member and not a set or list. Another idea is to simply remove the tail and replace it with the last…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Data model Hierarchy - Tree slicer
If you are in 2020, change it to a "regular" hierarchy. Drill path does not offer this functionality.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Concatenate dimension values
The "formula" tool delivers semantic calculations - which roughly means calculations off the aggregated results - which is not what you are after. Its a complicated discussion,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Concatenate dimension values
What technologies are you using? Did you build the model via Pyramid's modeling?
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Notification for failure of scheduled model refresh?
@Kim Southwood The published help on this set of topics is light. There is a big upgrade in help coming in a few weeks which starts the process of covering all these items in far greater detail.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: custom login page
Have your developers contact support to help you through this process.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Notification for failure of scheduled model refresh?
@Kim Southwood You can set the conenctor to "success" or "failure", and attach the appropriate email on either end. if you turn on the SMS system, it can also go to your phone.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: custom login page
You need to license the white labeling options if you want to replace logo's etc in the application. If you want to build a custom login mechanism, you need to use the APIs.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Top N - List
@Nicholas Campbell Instead of hard coding the last element, use a function instead. There are various ways of doing it, but the simplest and most direct is the "Tail" function (see help here).…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: custom login page
This question has no context. Please provide an exact explanation of what you are trying to achieve.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Notification for failure of scheduled model refresh?
Yes. If you are in 2020, turn on "Master Flows". In the widget menus on the left, you'll see options for sending email and SMS messages as part of the flow (if messaging has been enabled in the…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Top N - List
Yes - very doable, but you'll need to do it with some PQL/MDX script. The overall solution works regardless of which data technology you use. The example below uses the "PQL" track for SQL databases.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Authentication by Azure Active Directory (AAD)
The system supports AD (Native and Azure), SAML (which you can use from Azure too) and LDAP (almost any type). You can also build your own security layer using the APIs.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Complex report table
In a few weeks. Its currently in beta. You can contact support or sales to join the beta program if you want.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Columns position in Discover Tablix
You cannot. The Smart Discovery is all about AI-driven visualization, where the user does not make specific adjustments to the visual. Use the Discover Lite/Pro for this.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Down in an inner dimension of two nested ones
@Markus Loy it should to go into the ideas list for voting by the community.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Drill Down in an inner dimension of two nested ones
This is very similar to the new eliminations option coming in 2020.10 (its the same "ragged" querying technique). But the way it works in Excel is slightly different - in that it creates a "virutal…
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Complex report table
If you re referring to formatting - yes, you can achieve most of it in 2020.0 on wards. The more advanced grid formats give you this control now and this functionality gets stronger again in the…
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic formatting of table headers
Member level formatting is applied on a custom member/measure (both from the cube and Pyramid). In Pyramid, you would set these up in the properties of the custom member (aka "Formula") designer in…
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic formatting of table headers
We only support data formats, foreground and background colors from the cube. You can turn that on from the Query tab with "Model Colors" and "Model Formats". Font settings are ignored.…
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Down in an inner dimension of two nested ones
We don't see such behavior in Excel - it works like Pyramid. Can you upload some screen shots of what you see and what you're doing. Also, what data source etc.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Relation between discoveries
Build a "list" out of the products and reuse it in both discovery reports.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view
Re: Can you change the headers of the columns?
FYI: As of 2020.10, you can make overlay changes for all users if you are an admin.
- "making the sophisticated simple"
- AviPerez
- 6 yrs ago
- Questions & Answers
- Reported - view

1 5 6 7 8 9 13

Back to top

Home

View all topics