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
Ian Macdonald
Admin
Ian_Macdonald
Senior Director of Product
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
996
posts
321
likes received
13
followers
Badges
17
3
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Selection set under Data Point not possible
Hi Maaike, What is the formula you are trying to create? A data point or Tuple or Record cannot have a list of members as an argument. If it did it would effectively represent a set of data points,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: blank row in between different values
Hi Nicholas, Yes. Here's an example. I've created a custom measure called null, set to null. A few things to note: I've used specific row formatting for the null custom measure,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
1
Questions & Answers
Reported - view
Re: Measures/Dimensions caption translation
It also shows up when use the Values Chip in the filter Drop Zone:
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Just noticed you're using OLAP cubes. I retested and it works exactly the same for OLAP. Do make sure though that you have checked the "Use Security and Metadata overlays" option on the…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, I have no problem doing this using 2020.20. Create Role, Italian, add that Role to the model settings, make user a member of that Role, set Net Margin to be Margine netto for that role…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Export/Publish to google spreadsheets
Hi Olaf, Not currently. Please make an entry in the product Ideas forum for this enhancement request and we can gauge the popularity from the votes there. Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Marking this as answered since there has been no response to requests for further information.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Calculate a dimension value (numeric)
Marking this as answered since there has been no response to requests for further information.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Measures/Dimensions caption translation
Marking this as answered since there has been no response to requests for further information.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Presentation has no charts due to measures calculated
Marking this as answered since there has been no response to requests for further information.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: How Do I Use A Small Font Size In Questions And Answers?
Marking this as answered since there has been no response to requests for further information.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Calculating a CLV measure
Marking this as answered since there has been no response.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Scheduled Model Refresh not showing under Schedule Listing
Hi Dan, David, Can you please let us know what version of Pyramid you are using where you see this behaviour? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Date Parameter Slicer Issues
@Jon Wright Great!
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Adding Hyperlink to text in Publish
Hi Aaron, Use the HyperLink() function in dynamic text: I know you said "no code", but this is very simple! You will need a query associated with the dynamic Text,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Date Parameter Slicer Issues
Hi Jon, Apologies that this has gone unanswered for so long. Is this still relevant or have you resolved your issues? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Hi Markus, Please retest in the current version (2020.20). Regards, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Calculate a dimension value (numeric)
Hi Nicholas, It's been some time since you posted, is this still relevant to you? If you can relate your currency and date and value to convert, then yes, it should be straightforward calculation.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Rotate table header text?
Hi Adam, Unfortunately this is not yet supported. Make an entry in the Product Ideas forum. In
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: interactions across column charts
Hi Robin, We do not support "brushing" in the way that you describe it, but you should be able to set the interactions so that if I select the cost on a set of products,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Analysis Services Dynamic Management Views as IMDB Data Source
Hi Alistair, Unfortunately what you are asking for is not currently possible in Pyramid. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: How Do I Use A Small Font Size In Questions And Answers?
Hi Elizabeth, Can you explain a bit more what you are trying to achieve and in which part of Pyramid? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Display weather on map with data points
Hi Rob, You should be able to pass the address(es) to a weather mapping sites via their API using Dynamic Text to construct the URL with arguments to open that website in a a web panel on a…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Measures/Dimensions caption translation
Hi Sergio, Can you supply the requested information? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Presentation has no charts due to measures calculated
Hi Kate, Can you supply the requested information? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
1
12
13
14
15
16
21
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