Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Pyramid 2023 Limited Testing Program release 2 available now!

I’m pleased to inform our customers that the Pyramid 2023 “Archimedes” Limited Testing Program Release 2 (LTP2) is now available for download. This release has many fixes for customer reported…
- VP Product Management
- Ian_Macdonald
- updated 2 yrs ago
- 159
- Product Announcements
Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?
Hi anonymous client, Sorry, I misunderstood your requirements. Yes, you can cascade slicers (filters) in any way you choose. Trick here is use parameter driven dynamic sets, i.e.…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Install or Add new Python packages
And a direct link to the PDF that details this: https://community.pyramidanalytics.com/media/download/80jac9/Pyramid_TipsandTricks_January2023.pdf
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Can I bring up a second filter/slicer when certain selections are made in an initial one?
Hi Rory, Yes, it's possible, but requires a little bit of configuration. Effectively, we are wanting to perform conditional content display. I.e., as you say,…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 3
- Questions & Answers
- Reported - view
Re: CSV File Export - Scientific Format
Hi Yakov, I've found an S3 resource and written a CSV file to it and when reading it out again, my numbers are normal, not scientific notation. Can you share the model data flow that you are using?…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: CSV File Export - Scientific Format
Hi Yakov, I can't reproduce your problem. In my tests the numbers always come out as I see them in preview when output to CSV. I've tried Float, Double and Decimal (38.…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Data Model - ML - Linear Regression
Hi Jyotsna, There isn't a prebuilt block for Linear Regression. Instead, use the "Market Place" block and search the tags for Regression, then download the LR Python script. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Database Training Model Error
Hi David, It looks like there is something wrong with your installation / configuration. I suggest you open a ticket with our support team who are better placed to help you trouble shoot your issues…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Bell curve graph
Hi Heide, Do you have some examples you can share of what you are trying to achieve? Your request for help is a bit vague at the moment, so anything you can share to illustrate what you are wanting…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Sourcing Reporting Services Output in a Data Model
Hi Jason, You can configure a SSRS report as an Atom Data Feed. https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/generate-data-feeds-from-a-report-report-builder-and-ssrs?…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Restricting Access based on User rather than Role
Hi Rory, Content in Pyramid is secured by Role membership. It is not possible to define access to Content Folders by individual user. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Dynamic Caption for prior month
Hi Nicholas, You are very close! Your code as it stands will return the Member value for Feb 2023, not it's display caption. You need to add ".caption" at the end, like this:…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Auto rotate between mini tabs
Hi Michael, Unfortunately this functionality is not currently available. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Creating a dynamic parameter for a date range
Thanks for the clarification, very helpful. OK, this is an interesting problem, as you would like a single filter on year to apply to two sets of Ranges, but those Ranges are on different hierarchies,…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Creating a dynamic parameter for a date range
Hi IT Support, Your logic is that from the given year, you want all dates before that for the start date and all dates after that for the end date, yet your example screenshot shows the last date for…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Dynamic list that returns latest four months based on current date
Hi Ben, OLAP cubes (SQLServer Analysis Services) unfortunately do not have the concept of a DATE type. The Names of the elements in your [GAAP Accounting Period] are simply strings, like [202303],…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Discovery Data Catalog Export
@Dave Carbery we may have a different approach / solution. Watch yhis dpace.
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Discovery Data Catalog Export
Hi Dave, Discover objects are not available as JSON exports. Hope that helps. Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: HR Cube - Absenteism hours - Formulate
The Limited Test Program is now running. You can access the resources (software, guides, introductory webinar and slides) here: https://www.dropbox.com/work/Pyramid%202023%20Limited%20Testing
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Group Measures Under Headings for Export
Hi Natalie, This is a creative, out of the box hack, but that's what you asked for! Find a dimension in your model that has few members, in this case I'm using the Channel dimension.…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Data Mesh and Pyramid Analytics
Hi Mastaneh, According to Wikipedia, "Data mesh is a sociotechnical approach to build a decentralized data architecture by leveraging a domain-oriented,…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Data Mesh and Pyramid Analytics
Hi Mastaneh, I'm not sure what you are referring to by "Pyramid packages", nor "implement a data mesh". Can you please provide a fuller explanation of what you mean? Ian
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Use single measurement as a fixed / set Measurement AND as a Dynamic Measurement at row level or in Calculation
Hi Dolf, Obviously I don't have your OLAP cube to demonstrate, but I do have an OLAP cube that contains a measure of distinct count of customers which I can analyse by dimensions such as country or…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Possible to have an Embed Dashboard dynamically resize based on container dimensions?
Hi Jeremy, The tiled dashboard will fit to width of the container, but a regular fixed layout dashboard will keep its aspect ratio inside it. Please submit your requirements through the "Product…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: How to un-show header in a table
Hi Yvonne, One way you could accomplish this is to create a calculation that returns a value if the cell is not empty (i.e. the cells that get a background colour),…
- VP Product Management
- Ian_Macdonald
- 2 yrs ago
- Questions & Answers
- Reported - view

1 16 17 18 19 20 28

Back to top

Home

View all topics