Moshe Yossef's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Dynamic “initial price” driven by a user-selected date filter
@NPANS Like I wrote - It doesn't work that way. look, I have two measures for sales, sum and first child: I have a discover showing both, filtered on a month and a part: as you can see.…
- Customer Solutions Architect
- Moshe_Yossef
- 6 days ago
- Questions & Answers
- Reported - view
Re: Dynamic “initial price” driven by a user-selected date filter
@NPANS Ok I went in deeper - the point is that FirstChild Aggregation in the model does not work in context - so If you choose Jan 2025 and Part 004 - it will check for Jan 1st 2025,…
- Customer Solutions Architect
- Moshe_Yossef
- 7 days ago
- Questions & Answers
- Reported - view
Re: Dynamic “initial price” driven by a user-selected date filter
@NPANS This approach works and the calculation is explicit. When I tried @ObeeOne 's idea it didn't quite work, we're looking into it.
- Customer Solutions Architect
- Moshe_Yossef
- 8 days ago
- Questions & Answers
- Reported - view
Re: Dynamic “initial price” driven by a user-selected date filter
Hi @David Garavito Notice: I have attached the data set and a PIE file with all relevant items – models, formulates, discoveries, etc. So you can try it yourself.…
Attachments
- Customer Solutions Architect
- Moshe_Yossef
- 8 days ago
- Questions & Answers
- Reported - view
"Model", one word and many meanings

When working with Pyramid Analytics we often mean different things when we refer to “Model” or “Data Model”. In this post I will clarify the main distinctions between the different model terms.…
- Customer Solutions Architect
- Moshe_Yossef
- updated 5 days ago
- 1reply
- 159
- 6
- Model
Re: Issues with $0 values exported as $ in Excel export of a Publication
Hi, The reason is likely that the currency format in Pyramid is "$#,#" which in Excel translates to not show zeros. Go to the format of the measure (best is that you change it in the model,…
- Customer Solutions Architect
- Moshe_Yossef
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Order Dimension Tables
as a workaround - you could change the table caption and just add numbering in the beginning :-)
- Customer Solutions Architect
- Moshe_Yossef
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Exporting Multiple Discovers to a Single Excel Sheet
It's only possible with Tabulate, other export to excel options will print each discover to a different sheet (perhaps you can create a macro command in excel that will copy the content of each sheet…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Bringing in slicers as columns in Drill Down report
Hi @Raveena Mariappan If your slicers in the present are columns in the discover they will show, however you can't dynamically change the columns in the discover based on filters - is that what you…
- Customer Solutions Architect
- Moshe_Yossef
- 2 mths ago
- Questions & Answers
- Reported - view
Re: How do I categorize a column into groups?
This syntax for a custom column is correct, however you need to use the full name of the column - should be something like [table_name].[calumn_name], but the best way is to either use components…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Cascading slicers as multiple tree selection
@Jona Löneke Is the cost center a parent child hierarchy or a regular hierarchy? If it's parent child there really is no way around it. However, if it's a regular hierarchy it can be replaced with…
- Customer Solutions Architect
- Moshe_Yossef
- 3 mths ago
- Questions & Answers
- Reported - view
Removing Outliers Using Pyramid

Notice - all required files to reproduce the example are attached A customer has asked our CS team how to remove outliers from a list in a dynamic way. Before you approach this - how would we define…
- Customer Solutions Architect
- Moshe_Yossef
- updated 4 mths ago
- 1reply
- 184
- 5
- Formulate
Re: YTD Formula in PQL
@Jona Löneke you can also do this with the [KJ Month in Year] parameter, you just need to aggregate a range between January (or the null member- not sure what it represents) and the parameter.…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How can we be able to get the recipient list in the email (Subscription and Publication)
@Aaron Yohannan There are obvious downsides to this - you don't always want to share the full list with everyone, potentially exposing certain addresses you didn't mean to expose or that didn't want…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How to calculate "New vs Existing Buyers" with dynamic slicer context in PQL?
Hi @Oren Mkrtchyan , Our team is looking into it. My first advice to you - build it in steps: create a list: Filter( AllMembers([table].[panelist_id]), ([measures].[sales_amount], [table].…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed Could it be that you only have 19 actual days in Feb 2025? Do you have a date dimension or are the dates from the invoice tables?
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed If you use the second example - you can simply filter them out in the discover
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Average invoiced shown instead of totals
@Ricky Melamed Are you looking for the daily average? so the average total invoiced per day by months? A. You need to reverse the order: or: Here it is:…
- Customer Solutions Architect
- Moshe_Yossef
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Filter
@sanjay Can you add a screenshot with the different elements you have there? its sounds like you have conflicting filters
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Conditional formatting on a switch list
@Katie Easton So essentially, you use a global parameter to switch between lists, where each list contains 3 measures. how did you set the color and indicator? Did you drag the list to the color?…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Conditional formatting on a switch list
Hi @Katie Easton double click on the measure created for the conditional formatting, then go to measures and open it in forlmulate. This should be a formula that uses "HasItem()".…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic Function for Total Year
@Jona Löneke So you are selecting a "month-year" using a parameter, and now you need to switch between "last 13 months" and "full year" for this parameter? you can try the following:…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic Function for Total Year
Hi @Jona Löneke The MDX code you provided is a SET (or a list if it was a Pyramid Model). Where is this code put to use? Is it inside the cube? or in Pyramid Formulate? We need some more context here
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Filter with numeric attribute
@Michael Connelly Notice that you have an assumption that the transaction id is a key column for the fact table here. If it wasn't then Hillel's solution would be correct while the PBI example here…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Drop tables in the In Memory Database
Hi Michael, You mean you have an IMDB database with tables that were created in the past, and are now obsolete and will not be used again ? You can try the following:…
- Customer Solutions Architect
- Moshe_Yossef
- 5 mths ago
- Questions & Answers
- Reported - view

1 2 3 4 5 7

Back to top

Home

View all topics