How to enable Javascript

Latest Posts

Re: Find Difference between two dates Hi Richard, I know that we can do both measures and dimensions of of a single data model attribute. However, I’m wanting to calculate the age using a date difference between today and their…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 mths ago
- Discussion Forum - Q&A
- Reported - view
Re: Find Difference between two dates This is great information on identifying a date difference. Is there anyway to see the date difference as a dimension? We are calculating the age of automobile drivers and want to see it as a…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 mths ago
- Discussion Forum - Q&A
- Reported - view
Re: Is there a way to move a CMS repository to different database vendor? Thank you Devon! This is very helpful!
- Robert ClarkTop Contributor
- Robert_Clark
- 3 mths ago
- Discussion Forum - Q&A
- Reported - view
0
Is there a way to move a CMS repository to different database vendor?
Hello, We want to move the CMS repository to a different database. We have them in Postgres and want to move them to SQL Server. Is there a way to port from one database to the other? Thanks,…
- Robert ClarkTop Contributor
- Robert_Clark
- updated 4 mths ago
- 4replies
- 21
- Discussion Forum - Q&A
- Answered
- Answered
1
Display "all" in dynamic text when user selects all options in multiselect dropdown
We have a multiselect dropdown slicer that has a lot of values and when a user clicks the All button in the dropdown it is populating the dynamic text with all the options.…
- Robert ClarkTop Contributor
- Robert_Clark
- 11 mths ago
- 1reply
- 14
- 1
- Discussion Forum - Q&A
- Answered
- Answered
Re: How to create a loss triangle in Pyramid Analytics Our model is direct querying Snowflake so maybe that's part of why I needed to do it.
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- Discussion Forum - Q&A
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics Hi Ian, I worked with @Jason Picker and we figured out how to do it. We added an if statement so that it would not calculate a value if measure was null. Here's a screen shot. Thanks, Rob Clark
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- Discussion Forum - Q&A
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics Hi Ian, Thank you for the response. If I just put in the measure, without the formula, this is what I get. Which looks correct. There are no values in those other periods.
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- Discussion Forum - Q&A
- Reported - view
Re: How to create a loss triangle in Pyramid Analytics Hi Ian, This is all great stuff! I do have an issue though. I am getting values for development periods that are in the future. Here's an example. I checked my formula and it exactly matches yours.…
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- Discussion Forum - Q&A
- Reported - view
1
Display weather on map with data points
Hello, We are trying to identify if there is a way to map customers address on a weather map to identify who would be affected by a storm. Do you have some ideas on how this might be accomplished.…
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- 1reply
- 22
- 1
- Discussion Forum - Q&A
- Answered
- Answered
Re: How to create a loss triangle in Pyramid Analytics Thank you Ian! This is exactly what I needed. I couldn't figure out how to get it to sum properly, but now I know the trick.
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- Discussion Forum - Q&A
- Reported - view
6
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- 11replies
- 152
- 6
- Discussion Forum - Q&A
- Answered
- Answered
0
Authenticating with ADS when Pyramid Analytics hosted on AWS
Hello, Does anyone have tips on setting up Active Directory Services (ADS) authentication in Pyramid Analytics running on AWS. ADS is running on local network and Pyramid Analytics is running on AWS.…
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- 1reply
- 11
- Discussion Forum - Q&A
- Answered
- Answered
1
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- 1reply
- 46
- 1
- Discussion Forum - Q&A
- Answered
- Answered
2
Multi-factor Authentication
Is there a way to enable multi-factor authentication (MFA)? If not directly through Pyramid, is there third party tools to provide something like this?…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 4replies
- 35
- 2
- Discussion Forum - Q&A
- Answered
- Answered
Re: Can you change filter conditions in discoveries be OR rather than AND? @avi perez thank you that’s what we ended up doing. I was just wondering if there was an easier way built in.
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- Discussion Forum - Q&A
- Reported - view
0
Can you change filter conditions in discoveries be OR rather than AND?
We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 3replies
- 40
- Discussion Forum - Q&A
- Answered
- Answered
0
Is there a way to change date formats in a model?
We are located in the US and would like to change the date formats to a format that our users are used to, such as mm/dd/yyyy. I don't see a way in the model to set the date format displayed.…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 1reply
- 30
- Discussion Forum - Q&A
- Answered
- Answered
0
In Explore Further is there any easy way to filter out records with $0 measures?
We have users using explore further and add a measure but have no way, that we can see, to easily filter out the records with 0 as the measure value. Is there a way for them to do this?
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 1reply
- 18
- Discussion Forum - Q&A
- Answered
- Answered
1
Best practice for embedding Pyramid presentation into Salesforce
We want to embed graphs and presentations into Salesforce. What is the recommended approach for doing this?
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 1reply
- 26
- 1
- Discussion Forum - Q&A
- Answered
- Answered
Re: Concatenate dimension values We created the model on v2020. It's direct query against a SQL database. We tried something like [customer].[customer_id].CurrentMember+" - "+[customer].[customer_name].…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- Discussion Forum - Q&A
- Reported - view
1
Concatenate dimension values
Hello, Is there a way to concatenate two dimension values, like customer number and customer name, in a formula? As an example we have customer number "123" and customer name "ABC Appliances" and we…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 3replies
- 36
- 1
- Discussion Forum - Q&A
- Answered
- Answered
1
Get notified if Pyramid Services go down
We have had sporadic instances where some of the Pyramid Services crash. It gets reported in the logs. Is there a way to have Pyramid notify our admins when this happens so they can restart the…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 1reply
- 24
- 1
- Discussion Forum - Q&A
- Answered
- Answered
1
Change Discovery Column Label without Changing the Measure Caption throughout the system
Hello, For different discoveries we would like to have different titles on the columns. However, if we go to a measures properties and change the caption it changes it for all reports.…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- 1reply
- 30
- 1
- Discussion Forum - Q&A
- Answered
- Answered
Re: How to setup a Amazon(AWS) Load Balancer to work with Pyramid This solution no longer works after applying patch version 2020.02.084. The port forwarding now gives the following error: Access to XMLHttpRequest at 'http://<Pyramid_Server>.…
- Robert ClarkTop Contributor
- Robert_Clark
- 2 yrs ago
- Install/Upgrade/Cloud/License
- Reported - view

Back to top

Top Contributor

Robert Clark

Robert_Clark

52
87
0

Joined: 16 May 2019

Follow