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: Motion ranking
In this scenario, we are wanting to keep the query as generated by creating the grid, with Manufacturers sorted within each month. By placing Manufacturers into the colour drop zone,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Last updated date & time
@Fadiel Ras Last Process date is available as a system field in v2020.10.xxx due a on a couple of weeks' time. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Motion ranking
Make sure the Category drop zone is empty. Items (Manufacturers in my case) chip in Colour and Months in Motion for the Column chart.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Motion ranking
Hi Adam, Your post needs to be approved by the moderators of the forum before it appears in the Q&A, so that's why your post does not appear immediately.…
Attachment
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Unique Customers count that bought multiple items at a site
Quick clarification. You say guns, bows, ammo etc are attributes. Is that correct or are they members of a product attribute, like say product category?
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Drill Through within Measure?
Angela, I'm currently writing up a blog on this topic, I'll post a link here when it is ready. Meanwhile, I notice from your example report that you are connecting to a SQLServer Analysis Services…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
2
Questions & Answers
Reported - view
Re: Blank Pages
Hi Wayne, Yes there is. Take a look at Page Triggers in Publications. This allows you to test on values in a grid and then decide whether or not to print that page.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Load a whole folder and append multiple same-structure CSV file
Hi Gauthier, I've moved this post from the BI Office (our old platform) Q&A to the Pyramid Q&A as you had accidentally posted it to the wrong Forum! The functionality you want exists today in the…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
2
Questions & Answers
Reported - view
Re: Find Difference between two dates
Hi, There is a Pyramid function DateDiff() that can be using in formulate to calculate the difference between two dates in various units. See https://help.pyramidanalytics.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Stacked Visualizations
Hi, Please try this again. Later releases of Pyramid have enhancements to many chart formatting requirements, including multiple stacked measures: Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Cube measure format options
Yes, just click into the text box and type your own format string.
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Horizontal bar chart with two values
Certainly it is possible in V2020. I believe this was supported in one of the later 2018 releases. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Usage statistics
Hi Jared, You can find details on how to implement this at https://community.pyramidanalytics.com/t/m2a7cd/pyramid-usage-model-and-analysis Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Sqoop import to HCatalog/Hive - table not visible
Hi Priyanka, Are you sure you have submitted this question to the right vendor product forum? It doesn't seem to be anything to do with Pyramid Analytics! Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Can you drill down by column instead of cell?
Hi Nicholas, If I understand you correctly, you are wanting to effectively swap the Attribute from Years to Quarters to Months etc., and show all the Years, Quarters, Months etc.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: How to set default value to Slicer(Filter) ?
Hi Chris, Are you wanting to default the slicer to the specific value 47 or the latest (last) value dynamically? Yes, there are ways to achieve the filtering requirements you specify.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Sort multi-select Slicer
Hi Chris, Create a List of the dates you require, then sort the list descending and save it. Then use the List to populate the slicer: Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Is there any way to get notified when a scheduled Model Data Flow fails?
Hi Aryat, The functionality you are looking for is available in Pyramid 2020, known as Model Flows. Depending on the outcome of the processing in the example below,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
1
Questions & Answers
Reported - view
Re: Can you rename "Default Section" in a presentation?
2020.02.084 is available now from the customer portal. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Continuous date table
Hi Olga, We are currently developing this feature for a future release, so keep your eye on the product announcement forum for this in the coming months.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Multiple Members Search
You can run multiple searches and add the results together using the "Found Elements" and "Selected Elements" panels. In this example, I have search for Zip codes containing 123 and selected them…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Calculation turns wrong after drill-down
Hi Markus, Please retest in the new release, 2020.01.121. There is a fix in there described as follows: Fixed an issue where the Percent Of Total context function had an incorrect format when using…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Cell bars are displayed incorrectly in case the Grand Total is switched on
Hi Markus, Please resubmit this into the Ideas forum. Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Rank
Hi Nicholas, As Imbar says, with regards to the Rank() function, this is currently only available within the “Common” functions, not the semantic model functions.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
Re: Connecting multiple Excel selections to Python script 'easily'
Hi Frank, Just duplicate the Python Block and connect it to each of the select blocks for each of your Excel tabs. Multiselect block is designed for when you have multiple tables of data upon which…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
4 yrs ago
Questions & Answers
Reported - view
1
15
16
17
18
19
20
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