Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: How to define a common scale for primary and secondary Y-axis?
Hi @Michael Daun You are correct. However there is a workaround whereby we show the stacked measures and single measures together on the primary axis. In fact,…
- Senior Director of Product
- Ian_Macdonald
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Case Statement in model
Hi @Tabitha DeCaprio , Your syntax is incorrect for the PQL CASE() statement. See the Help page for detailed syntax, but your example correctly specified in Pyramid would be :…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Local storage of "In Memory" DB
Hi @Jose Redondo, When you build a model that includes a data flow (vs a direct query model) you can choose where to store the data that is output from the data flow in the "Target" block.…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong BTW, the file I found was free and includes the lat/long centre of the full postcode. That might be helpful to you. You can find the website here. Hope that helps some more! Ian
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong I've done some testing by downloading the complete list of Canadian post codes by City and Province. I took the first 3 characters of the post code to give the Forward Sorting Areas (FSA)…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong Don't forget to set the map locale to Canada. That way you have a better chance of resolving the post codes correctly Ian
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Quick Sort --> Inverted Hierarchy
@Vijayan Krishnan You are correct in identifying this behaviour. It is operating as designed. As you expand or collapse the hierarchy, Pyramid re-queries the data and it returns the default ordering.…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan Well, no, you can create a Custom Column through Formulate outside of Model. BUT the JOINS must be of type LEFT OUTER. If you try the same query in SQL,…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Pyramid Geospatial for Postal Code
@Ying Dong , The format of post codes in Canada according the Google is: "The postal code is a six-character code defined and maintained by Canada Post Corporation (CPC) for the purpose of sorting…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan Here is one solution. In your model, it requires that your JOINS be of OUTER type from ST Acc to the NA and FA tables: Then create a "Custom Column" through the Formulate module:…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Pyramid 2018 Geospatial Shapes summary
@Ying Dong Please repost your question, with considerably more detail, in the Q&A Forum. You will get a much better and faster response there. From what you have written,…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Tech Blogs & Webinars
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan It is important to remember that the Pyramid Semantic models that represent your underlying relational data are fully dimensional in nature, i.e.…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: How to set environment variable in pyramid
Hi @anonymous client You can add additional Python environments and add the packages you want in your selected Python environment in the admin console. By default,…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Mapbox 3d feature
Hi @RAJESH Gonuguntla , There is no easy way to do this. The only approach would be to build a Custom Visual and and manage all the background tiling and overlays from your data and MapBox yourself.…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: If we have an azure artifacts, how can I directly refer it from pyramid to add packages from the artifacts.
Hi @Raveena Mariappan , You can add packages to your selected Python environment in the admin console. By default, these use the standard Pip or Conda repositories,…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to set environment variable in pyramid
Hi @Raveena Mariappan , Can you explain a little more what you are trying to achieve? I'm not sure what you mean by "set environment variables in Pyramid". Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Mapbox 3d feature
Hi @RAJESH Gonuguntla MapBox 3D maps are not currently supported in Pyramid mapping. The type of map supported are selected from the map type in the Menu Ribbon: Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Choose an specific dimension element
Hi @Friedrich Schmid You need to add the caption() function to retrieve the string the represents the Member's caption (i.e. the string that appears in the column or row header when that member is…
- Senior Director of Product
- Ian_Macdonald
- 7 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Automatic Filter by Calling User
Hi @terrance smith When you say that you have set up the security in the database, can you elaborate? Pyramid Models provide a way to automatically set dynamic row level security through a "security…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Row background color is not exporting same in excel
@Md Masum Reza The other obvious question to ask is why do you need to export to Excel? We see an increasing trend in the market and with our customers in particular to try and keep data inside the…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to I show data point that do not have a value
@Anderson Chou I don't understand your question. Can you explain a little more fully what you require? Ian
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: How to I show data point that do not have a value
Hi @Anderson Chou , I am guessing that your time period hierarchy is derived from your sales data. Thus it will only contain the time periods that are present in your sales transactions.…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Subscription Default/Current Slicer Question
Hi @Jenny Euesden You can achieve this by populating the date slicer with a dynamic list create from the dates in your model and make the last item in the list the default for the slicer.…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Exploration empty in a publication
Hi @Aurelie , Yes, you have to use a grid, but that grid does not have to be on the slide. Simply duplicate the KPI report, restyle it as a grid, make sure you have the KPI values you need in the…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Row background color is not exporting same in excel
Hi @Md Masum , Go to the Product section of the customer forum, then Product Ideas, then Current Product Ideas. You can add a product idea using the button on the right.…
- Senior Director of Product
- Ian_Macdonald
- 8 mths ago
- Questions & Answers
- Reported - view

1 4 5 6 7 8 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: How to define a common scale for primary and secondary Y-axis?

Re: Case Statement in model

Re: Local storage of "In Memory" DB

Re: Pyramid Geospatial for Postal Code

Re: Pyramid Geospatial for Postal Code

Re: Pyramid Geospatial for Postal Code

Re: Quick Sort --> Inverted Hierarchy

Re: Is it possible to create a combined list by selecting members from two different tables and columns?

Re: Pyramid Geospatial for Postal Code

Re: Is it possible to create a combined list by selecting members from two different tables and columns?

Re: Pyramid 2018 Geospatial Shapes summary

Re: Is it possible to create a combined list by selecting members from two different tables and columns?

Re: How to set environment variable in pyramid

Re: Mapbox 3d feature

Re: If we have an azure artifacts, how can I directly refer it from pyramid to add packages from the artifacts.

Re: How to set environment variable in pyramid

Re: Mapbox 3d feature

Re: Choose an specific dimension element

Re: Automatic Filter by Calling User

Re: Row background color is not exporting same in excel

Re: How to I show data point that do not have a value

Re: How to I show data point that do not have a value

Re: Subscription Default/Current Slicer Question

Re: Exploration empty in a publication

Re: Row background color is not exporting same in excel

Home