Len Stockdale's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

East of England Cooperative Society Ltd

Country

Latest Posts

Re: Top 10 By Measure
Hi I think I have solved the issue. I had not selected the filter and sort for all the dimensions. As soon as I did that I started getting the results I expected. Thanks Len
- Len_Stockdale
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Top 10 By Measure
Thanks, I tired again using your suggestions and have the same problem as before. Looking at what is sent to our Netezza server (via Direct query), the SQL looks wrong (see below).…
- Len_Stockdale
- 1 yr ago
- Questions & Answers
- Reported - view
Top 10 By Measure

Hi I am trying to resolve the following use case: I have a table in my DW that contains the a list of tables, their size in GB, dates and schema. I need to create a Discover that will show me the top…
- Len_Stockdale
- 1 yr ago
- 3replies
- 89
- Questions & Answers
- Answered
- Answered
Re: Free Text Parameter interacting with Present content
@imbar Hi Thanks, this has solved by issue. Most appreciated. Thanks Len
- Len_Stockdale
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Free Text Parameter interacting with Present content
@imbar Hi The code generated is SELECT COUNT("xVNETEZZAQUERYHISTORWpk2dwFfPJ"."SESSION_ID") "xCNTmzrVNETEZZAQUERYiwSJJ89uMr", "xVNETEZZAQUERYHISTORWpk2dwFfPJ".…
- Len_Stockdale
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Free Text Parameter interacting with Present content
@David Gordon Hi Thanks for the response. The process nearly worked but the SQL generated and passed back to Netezza DW platform is not quite right. We are raising a support call to investigate the…
- Len_Stockdale
- 1 yr ago
- Questions & Answers
- Reported - view
Free Text Parameter interacting with Present content

Hello I have the following use case issue that I cannot resolve. I need to place a free text numeric input field onto a present and get that to interact with a Discover to act as a filter.…
- Len_Stockdale
- 1 yr ago
- 6replies
- 94
- Questions & Answers
- Answered
- Answered
Re: Fixed Static Parameter
@Ian Macdonald Thanks. Now setting this up and testing
- Len_Stockdale
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Re: Fixed Static Parameter
@Raja Sambasivam Thanks for the response. Sadly Python is not an option as this is a direct query and I cannot add nodes into the model. Len
- Len_Stockdale
- 1 yr ago
- Questions & Answers
- Reported - view
Re: Fixed Static Parameter
Hi Sorry, hopefully this will help. I am trying to use to Pyramid to replace our current dashboard that exposes the SQL stats of our Data warehouse. I want to do a distinct count of data warehouse…
- Len_Stockdale
- 1 yr ago
- 1
- Questions & Answers
- Reported - view
Fixed Static Parameter

Hi I'm new to Pyramid. How do I create in a report or KPI that has a fixed static parameter please. I want a report or KPI that counts a distinct value when a range is between 1 and 1000.…
- Len_Stockdale
- 1 yr ago
- 8replies
- 98
- 4
- Questions & Answers
- Answered
- Answered

Back to top

Home

View all topics