Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Avi Perez
Admin
AviPerez
"making the sophisticated simple"
Everywhere
www.pyramidanalytics.com
Follow
Joined
Sat Jul 30 23:34:10 UTC 2016
1194
posts
144
likes received
16
followers
Badges
7
1
Company
Pyramid
Country
Namibia
Latest Posts
Re: Concatenate dimension values
What technologies are you using? Did you build the model via Pyramid's modeling?
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: custom login page
Have your developers contact support to help you through this process.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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).…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Relation between discoveries
Build a "list" out of the products and reuse it in both discovery reports.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 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.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: How to add text in the header or footer of a publication?
The master page concept is based on more advanced layout tools and design applications, where people need to create layout concepts of various things that go well beyond simple headers and footers.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
Imbar's suggestion is how to resolve your issue. You need to construct a list/set of the top N items - sort that as you want with the List builder (you can use any element in the model to drive the…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Change Discovery Column Label without Changing the Measure Caption throughout the system
Please see the response here.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Unit of Measure
This technique, via the Discover, sets it for yourself only. To set it for users (by role), you should do it through the admin in the data source manager.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: Unit of Measure
Currency is the regional locale of your data. So it likely defaults to "$". To create any other unit simply use the custom format option and type it in. To set it up for Euro's type: "€" #,#
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
1
4
5
6
7
8
12
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
View all topics