Imbar's Profile - Pyramid Analytics Community Forum

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: comment out parts of formulate in business logic
Hi, You can use either type of commenting method: 1+2+3 // comment after slashes or 1+ /* comment between star-slashes */ 2+3
- imbarmarinescubar_pyram
- 1 yr ago
- 2
- Questions & Answers
- Reported - view
Re: Pyramid Usage Model and Analysis
Hi @Michael Daun , The server time is the entire time that the server handled the request minus the Query Time. That might include queueing time, for example,…
- imbarmarinescubar_pyram
- 1 yr ago
- 1
- Tech Blogs & Webinars
- Reported - view
Re: Optimizing a Star Schema Data Model
Hi @Elaine Charboneau , As you mentioned, the best practice it to use a star schema. Some additional key points to consider are: 1. Use single key (column) joins rather than multiple columns 2.…
- imbarmarinescubar_pyram
- 1 yr ago
- 3
- Questions & Answers
- Reported - view
Re: Date Members in formulas
Hi @Federico Riera , The key concept to understand here is that cube elements are not the same as values. Now() and DateSerial() return date-values, and date functions (year/month) can be applied to…
- imbarmarinescubar_pyram
- 2 yrs ago
- 3
- Questions & Answers
- Reported - view
Re: Tooltip not showing in scatter graph
@Dan Sharman Yes, you can use the min or max as a workaround for now, and rename them. However, I would still like to understand what exactly is happening with the dimension.…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Tooltip not showing in scatter graph
Hi @Dan Sharman , Just to be sure I understand the current situation: When adding the Assured column into Details, the tooltip is working as expected? Regardless,…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: Filtering discoveries with OR instead of AND
Hi @Sophie durrant , There isn't a direct option to change the slicers into OR. Something you can try out is to create a custom list of invoices that is a union of the 2 lists:…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: chart list for development months
@Nicholas Campbell I used weeks as an example to test on a sample data set. As long as the column values are digits it should work the same. If the column isn't numeric then you can try to use any…
- imbarmarinescubar_pyram
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: chart list for development months
Hi @Nicholas Campbell , Interesting question. I have an idea using a custom list: range(1, 24) + filter(range(27, end), caption is divisible by 3) in PQL it should look something like this:…
- imbarmarinescubar_pyram
- 2 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Tooltip not showing in scatter graph
@Dan Sharman , When seeing * as a value from the tooltip, it means that there are multiple values of Assured for that given Section Reference. If there was a single value then you would have seen it.…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: differences in standard deviation
Thanks @Dan Sharman , So as I've mentioned, the cartesian standard deviation is actually the value of standard deviation away from the average point (i.e. avg + stdev * factor).…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: differences in standard deviation
Hi @Dan Sharman , The ribbon and the right-click "statistical functions" both generate the same type of calculation. It is a cartesian, or visual, calculation that produces the value based on the…
- imbarmarinescubar_pyram
- 2 yrs ago
- Questions & Answers
- Reported - view
Re: How do you convert unix epoch time to time?
Hi @Ilan Perez , There is a PQL function you can use: https://help.pyramidanalytics.com/Content/Root/developer/reference/fx/PQL/Common/Date-Time/TimeStampToDate.…
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Hide unwanted subtotals
Hi, @Sergio Galimberti This will be available in the next major version release. should be in the next few weeks (I cannot promise a specific time line). Imbar
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Negative number formats
Hi @Sophie durrant , Do you mean that you want the color to be red? If so, you can use the color drop zone, to color positive/negative values. Drop the measure that you are using into the color…
- imbarmarinescubar_pyram
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Hide unwanted subtotals
Hi @Sophie and @Janneke , This feature is being built and should be available for you in the upcoming versions:
- imbarmarinescubar_pyram
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Show Empties - In Memory
Hi @Alec Mason , The show empties options returns all the combinations that exist in the result set even if they are empty (null values). In an MDX data source (like tabular) all the members from…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
I'll attach here an example from the start of what I think you meant using states instead of brokers and sales instead of premium. Let me know if it worked for you or if you meant something else. 1.…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
Hi @Nicholas Campbell I'd tried reading the questing a couple of times but I'm still not sure i understood all the details. Could you maybe add some images or more detailed explanations?…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Folder & sub-folder in Measure group
Hi @Angela Musić , In general, if there are any display folders set, then they will be used to arrange the measures. Any measure that is not under a folder is placed outside (like in your image).…
- imbarmarinescubar_pyram
- 4 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
@Sophie durrant ohh I see. 2 things are missing then: 1. the caption function was added on version 2020 2. the "dot" function option was added on that same version.…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
@Sophie durrant could you share the error? did you make sure the set you are trying to create is under "ClosedDate"? it should be selected on the size panel when designing it: also,…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Range List Using Two Date Hierarchies
Hi @Sophie durrant , If I understand correctly, the second set you are trying to create is under the "ClosedDate" column, right? So first comment is that the ClosingPeriod needs to be set on that…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Find Difference between two dates
Hi @Aryat Srivastava , Could you please provide some more details so we could help you? What data source are you using? (SSAS, pyramid in-memory, Sql Server, Oracle...…
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Rank
Hi @Philip Augur Still haven't got to this function. You could add it to the feature requests and get up-votes on it to move it up the backlog.
- imbarmarinescubar_pyram
- 4 yrs ago
- Questions & Answers
- Reported - view

1 2 3

Welcome to the Pyramid User Community

Pyramid User Community

Imbar

Re: comment out parts of formulate in business logic

Re: Pyramid Usage Model and Analysis

Re: Optimizing a Star Schema Data Model

Re: Date Members in formulas

Re: Tooltip not showing in scatter graph

Re: Tooltip not showing in scatter graph

Re: Filtering discoveries with OR instead of AND

Re: chart list for development months

Re: chart list for development months

Re: Tooltip not showing in scatter graph

Re: differences in standard deviation

Re: differences in standard deviation

Re: How do you convert unix epoch time to time?

Re: Hide unwanted subtotals

Re: Negative number formats

Re: Hide unwanted subtotals

Re: Show Empties - In Memory

Re: Custom sort ordering - order by top N but leave "other" at bottom

Re: Custom sort ordering - order by top N but leave "other" at bottom

Re: Folder & sub-folder in Measure group

Re: Range List Using Two Date Hierarchies

Re: Range List Using Two Date Hierarchies

Re: Range List Using Two Date Hierarchies

Re: Find Difference between two dates

Re: Rank

Home