Jason Picker's Profile - Pyramid Analytics Community Forum

Badges

Latest Posts

Re: Colouring different parts of a dynamic text sentence.
@Dan Sharman I have not seen that behavior. Can you drop a screenshot of the "live" text and the dynamic text edit mode? I might be able to spot something to help.
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Aggregating clients for a location while taking into account other locations
@Janneke Richter The quick answer is YES, you can still get what you want. There are a number of ways to solve the problem. I am including one example.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Aggregating clients for a location while taking into account other locations
Assuming your data does clearly distinguish between the two NO values, then you can create the metric in the Formulate module via a simple Data Point object.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Colouring different parts of a dynamic text sentence.
In version 10, we introduced a set of Markup functions for Dynamic Text so you have lots of control over how the text looks. The function you want to use is called FontFormat (LINK).…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Export List of Pyramid User Accounts
You can get this information from the Pyramid repository, assuming you have access to it. Here is an example query that you can use: SELECT u.id AS UserID , r.id AS RoleID , p.id AS ProfileID , u.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to calculate aggregate correctly without using underlying details
Erik, There are two ways you can solve this on the client-side (i.e. via Pyramid Formulate) depending on what is currently available in the Cube you are using.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Stop distribution of when 'Finished with Errors'
There is not a way to stop the publication that I am aware of. We will try to confirm this with our Development team. You may want to submit this as a feature request on our Product Ideas page here:…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Notification of Publication Failure
Alec, You can use the following query to get the information you want: SELECT tt.task_id , tt.execution_id , te.schedule_id , ts.item_id , tt.start_date , tt.summary , tt.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)
@Erik I realized that I was working on a MSOLAP Cube and just saw in your screenshot that you are using SSAS Tabular. I switched to that engine and was able to reproduce the error message you were…
- Jason_Picker
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)
@Erik Date functions like MTD and YTD are dependent on the developer of the cube properly setting the column type property to a Date type. If the Financial Period attribute is actually a hierarchy,…
- Jason_Picker
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: List of supported databases
You can see the list of supported data sources for both Source and Target for the Model on the help site:…
- Jason_Picker
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)
It is also possible to write your own cumulative total in MDX as well if you need it. The easiest way to do running totals against dates is to use the YTD function in conjunction with an AGGREGATE…
- Jason_Picker
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)
The problem you are running into is a mix of PQL and MDX. When using an SSAS datasource, all calculations must use MDX only. For example, in your screenshot of your calculation,…
- Jason_Picker
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Model mapping advanced
By the way, if you are having trouble constructing the right logic for your mapping, you can take advantage of the Designer to help test the logic before you run it live.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Model mapping advanced
When working through the Model Mapping on MS OLAP cubes, it is important to understand how MDX members are represented, either through captions or keys.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Combine attributes for "change caption"?
The ability to combine captions from multiple attributes is best handled in the Data Model design via Calculated Columns or in the data source. However,…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to remove special characters from a string in Data Modeler?
One way to do it would be to use the Replace node and leverage the Regular Expression or REGEX syntax. Here is an example: [^0-9a-zA-Z]+ It will remove all the special characters.…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
How to remove special characters from a string in Data Modeler?

Sometimes when you are importing data from a source, a column may have non-alphanumeric characters (aka special characters). How can I remove these characters? For example,…
- Jason_Picker
- 3 yrs ago
- 1reply
- 20
- Questions & Answers
- Answered
- Answered
Re: Parse excel doc
Check out the information in this link to get a code example: How to import multiple Excel files in Data Modeler? - Q&A - Pyramid Analytics Community Forum
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Python and Excel
The quickest way I have found to do it is to use the glob2 library. Here is an example that will read in all XLS files in a particular directory and load the results into a data frame that can be…
- Jason_Picker
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: How to get the Content Path from the Pyramid Repository in Usage Reporting
The information is stored in the Content_Tbl_Item table as a parent/child dimension. To get the full path, you have to write a recursive query. If your repository is using SQL Server as opposed to…
- Jason_Picker
- 4 yrs ago
- Questions & Answers
- Reported - view
How to get the Content Path from the Pyramid Repository in Usage Reporting

In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- Jason_Picker
- 4 yrs ago
- 1reply
- 69
- 1
- Questions & Answers
- Answered
- Answered
Re: Find Difference between two dates
If you are using a SQL-based model (i.e. IMDB, SQL, Oracle, Redshift), you can accomplish this with the help of a function called StringToDate. Here is an example from a Claims model:…
- Jason_Picker
- 4 yrs ago
- Questions & Answers
- Reported - view
Dynamic Date Parameters

Are you able to make the maximum year in a date parameter dynamic? So that right now it would give options up to 2020 – but next year, it would automatically update to 2021 without requiring us to…
- Jason_Picker
- 4 yrs ago
- 1reply
- 42
- Questions & Answers
- Answered
- Answered
Re: Passing Parameters to Stored Procedures
You can do it in a Model using a hard-coded value or using a variable. In order to call the stored procedure, you need to use a SQL Query node. You can put the decryption key in the call to the…
- Jason_Picker
- 4 yrs ago
- Questions & Answers
- Reported - view

1 2 3 4

Welcome to the Pyramid User Community

Pyramid User Community

Jason Picker

Re: Colouring different parts of a dynamic text sentence.

Re: Aggregating clients for a location while taking into account other locations

Re: Aggregating clients for a location while taking into account other locations

Re: Colouring different parts of a dynamic text sentence.

Re: Export List of Pyramid User Accounts

Re: How to calculate aggregate correctly without using underlying details

Re: Stop distribution of when 'Finished with Errors'

Re: Notification of Publication Failure

Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)

Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)

Re: List of supported databases

Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)

Re: Cumulative context but to exclude specific status measures (unable to reproduce solution)

Re: Model mapping advanced

Re: Model mapping advanced

Re: Combine attributes for "change caption"?

Re: How to remove special characters from a string in Data Modeler?

How to remove special characters from a string in Data Modeler?

Re: Parse excel doc

Re: Python and Excel

Re: How to get the Content Path from the Pyramid Repository in Usage Reporting

How to get the Content Path from the Pyramid Repository in Usage Reporting

Re: Find Difference between two dates

Dynamic Date Parameters

Re: Passing Parameters to Stored Procedures

Home