-
Passing Parameters to Stored Procedures
If we have a Stored Procedure in the database server to which I need to pass a decryption key (string/text) in order to decrypt the numeric sensitive data,…
- Answered
-
SSAS Currency Symbols
Does Pyramid support dynamic Currency Symbols that are configured in the SSAS cube using "Language( )" MDX? I'm not seeing that the symbols are being allowed through to Pyramid. Is this supported?
- Answered
-
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?
- Answered
-
Calculating max/min difference in context
Hi there i want to reduce a range of time series lines into a single area spanning the max and min values in each time point. I've had a go with creating an Fx but i suspect i need a context…
- Answered
-
Population pyramid part 2 - axis extents
Hi all, thanks again to Ian for your help in my other post https://community.pyramidanalytics.com/t/60hxcbn/making-a-population-pyramid-chart-specify-total-for-and-reverse-axis-direction I've used…
- Answered
-
YTD Functions
For the YTD to work properly, do you need to have a date field in your model? Or can it also work on 'text fields' set as your periods?
- Answered
-
Client help search problem?
Hi there i'm not getting any answers when searching the Client Help, even if i search for a phrase i can see in a help page, when using Chrome. Seems fine in Edge though.…
- Answered
-
Related content -> metadate available as source in model?
Hi, I'm new to Pyramid. I've searched the forum but haven't found an answer to the following question: For operational purposes (Something is broken, where is the impact?…
- Answered
-
Making a population pyramid chart - specify total for %, and reverse axis direction
Hi all, i need to be able to create these charts. Percent of total, in agebands split by sex, displayed as a bar chart with one of the sexes using an inverted x-axis.…
- Answered
-
Show Empties - In Memory
Hello, I have built a new in-memory Pyramid model, and I have a table with a list of Pack Benches (numbered 1-10). When I don't include a measure, it shows all elements of the dimension (see…
- Answered
-
Line chart - multiple items, all one colour
Hi I've a bar chart which was multicoloured when new, i dragged the Geography item from Colour zone to Categories zone and the chart bars all became default blue which is just excellent.…
- Answered
-
External Actions / Workflow
HI, Does Pyramid have the ability to support a 'sign off' workflow -- ex: user reviews a dashboard and clicks to indicate that the visuals have been reviewed. We'd like to capture the signoff.…
- Answered
-
Cumulative Rate Changes
Hi all, I am trying to replicate the example seen in the picture. As you can see, with each different year the rate % changes. I want to be able to track the cumulative change from a given year…
- Answered
-
Click or drag to add measure - any difference?
Hi all, when i tick a measure Pyramid will add it to in this case a table - adding it to both the Values card, and the Columns card, the column it creates is also named with the Measure name.…
- Answered
-
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?
- Answered
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Motion ranking
Hello all, very new to Pyramid (day2) and I've got a bar chart with date driving motion and am trying to sort the display order of the bars to always be descending (so they may have to swap places…
- Answered
-
Data model Hierarchy - Tree slicer
Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…
- Answered
-
change start of week in Data Flow (Advanced Time Intelligence)
Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…
- Answered
-
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…
- Answered
-
custom login page
Hello, How do I send the login credentials from a custom HTML login page with the link to the specific dashboard URL? Thanks
- Answered
-
Notification for failure of scheduled model refresh?
Is there any way to send a notification when a schedule model refresh fails?
- Answered
-
Creating a calculation to provide difference between two columns of numbers
We have reports that use named sets to provide four years of data and need to show the difference between the last two. We've done it with a quick calc using data points but we find that these hard…
- Answered
-
Top N - List
Hi We have a list of days which are numeric but not a measure. the values range from 0 to 900. We want to only show the element where they are greater than a specific value set by a continuous…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.