Ian Macdonald's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Building Custom Filters
Hi Laura, Can you give some examples of what you are trying to achieve? When you say "custom filters", what do you mean exactly? Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Dynamic filter for various slides in the same dashboard
Hi dgf, How are the relevant countries for each slide determined? How can they be calculated dynamically? I.e. what is driving the list of relevant countries? there may well be a way to do this,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Dynamic filter for various slides in the same dashboard
Hi dgf, Easiest thing to do is simply add a new Country slicer to each slide, then set what elements appear in the slicer for each slide. As you add each slicer,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Count the number of customers depending on specified levels (nested if)
Hi Niclas, Generally for these types of queries, where there is a need to filter then count a set, it is more efficient to take a slightly different approach, evaluating the condition,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Using cascading slicers/filters
Hi Fergus, We'll take a look at this. Meanwhile, maybe you could try creating a hierarchy in your dimension in the semantic model and try a Tree slicer using that hierarchy,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Answer
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, Yes, I will reply. Been busy on other things. certainly by next Monday. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, In that case it is a vey simple calculation, but using the new feature in Pyramid2023, "Custom Columns". I'm assuming you are working in Direct Query mode,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: get a list of unique account_IDs from two lists
Hi dgf, Open Formulate, select your model and choose to create a new List. Drag the "Union" block form the "Derive" menu on to the canvas, you will by default get two branches to Union:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Actions > Jump to Content
Hi Shannon, We'd need a lot more information to determine if this is an issue. We currently have no reports or open problems on this topic. If you are getting "not enough information" when you jump,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to Create a measure from a dimension
Hi Steve, Pyramid's Semantic Model is dimensional, so you have to think Sets rather than Tables, Rows and Columns. So, you need to create a set of Periods, sorted by Sales descending,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Count of positive values in sub query
Hi Val, Sorry, some more questions. Is this example table the base, row level data? At what level of aggregation is the testing of Sum of Profit if it is +/- ?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: How to view underlying query of a discover report
Hi Laura, You cannot. The Pyramid "Pyrana" SQL query engine uses advanced and sophisticated techniques to "shard and stitch" its generated SQL to deliver the analytic view the user has defined…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: How to view underlying query of a discover report
Hi Laura, Be aware that setting Benchmark logging on can impact the runtime performance of your Pyramid Server and recommended best practice is to only switch it on to troubleshoot problems,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Suppression of Columns when Column is Filled with dynamic parent
Hi Andre, With the above from NPANS, you can also use the Dynamic Caption feature to set the Column Header of your custom member to the name of the parameter parent: Note:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Count of positive values in sub query
Hi Valeriia, Can you please tell me what version of Pyramid you are using? That determines the approach that needs to be taken to solve this problem. Thanks, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Shapes & pattern from png or svg
Hi Aaro, We don't currently support the use of user defined images as chart column fill or scatter plot points. Yes, a new feature request. Hope that helps. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Capacity limit to number of accepted lists in Discovery's Variable List Wizard
Hi Dave, If you've hit a limit, then I guess there is! I'll check this with the UI guy for Discover. Meanwhile, can you try building it in Formulate?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Mimic member logic within lists
Great! I'll mark this as answered then. Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Mimic member logic within lists
OK. But your variable lists still contain Products, whose values are Members of the Product dimension, so currentmember is still available. I've created 5 lists of Products here,…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Mimic member logic within lists
Hi Dave, You say you have a "variable list", but you cannot access the member functions. Can you share please how the list is created? What are the members of the list? How are they defined?…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: get measure monthly count for last 12 months
dgf, Make sure you are saving your list to the right date hierarchy and not to Measures: Hope that helps, Ian
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: get measure monthly count for last 12 months
Hi dfg, I recreated your expression on my cube as follows: strtomember("[Date].[Month Dates].[Date].["+ format(now()-2764,"M/d/yyyy")+"]").parent.lag(11) : strtomember("[Date].[Month Dates].[Date].…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Custom Columns and OLAP Cubes
Hi Ray, You are correct. Custom Columns are not available when working with OLAP cubes as we have no access to the cube's underlying data source and cannot change or adjust the semantic model in…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Using a SQLServer Table Value Function in Pyramid
In your DQ model, in the Tables view, add a Query to create a new table and call the TVF from there in the same way you did in the Select block in the data flow.…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Using a SQLServer Table Value Function in Pyramid
Hi Mad, Yes, you can. You'll need to add a Query Block connected to your SQLServer source, then create your Select statement using your Table Value Function like this:…
- Senior Director of Product
- Ian_Macdonald
- 1 yr ago
- 1
- Questions & Answers
- Reported - view

1 7 8 9 10 11 22

Welcome to the Pyramid User Community

Pyramid User Community

Ian Macdonald

Re: Building Custom Filters

Re: Dynamic filter for various slides in the same dashboard

Re: Dynamic filter for various slides in the same dashboard

Re: Count the number of customers depending on specified levels (nested if)

Re: Using cascading slicers/filters

Re: Count of positive values in sub query

Re: Count of positive values in sub query

Re: get a list of unique account_IDs from two lists

Re: Actions > Jump to Content

Re: How to Create a measure from a dimension

Re: Count of positive values in sub query

Re: How to view underlying query of a discover report

Re: How to view underlying query of a discover report

Re: Suppression of Columns when Column is Filled with dynamic parent

Re: Count of positive values in sub query

Re: Shapes & pattern from png or svg

Re: Capacity limit to number of accepted lists in Discovery's Variable List Wizard

Re: Mimic member logic within lists

Re: Mimic member logic within lists

Re: Mimic member logic within lists

Re: get measure monthly count for last 12 months

Re: get measure monthly count for last 12 months

Re: Custom Columns and OLAP Cubes

Re: Using a SQLServer Table Value Function in Pyramid

Re: Using a SQLServer Table Value Function in Pyramid

Home