-
Truncating decimal numbers in dimensions
I have a custom model that has currency exchange rates; the rates are decimal numbers with 4 places, in the sql query I have them truncated to only show 4 places In some of my discoveries,…
- Answered
-
Advanced slicer settings
We have just upgraded to a new version of Pyramid and I can see that there are now advanced settings in slicers I am selecting "remember user's last selection" but it won't stay selected!…
- Answered
-
Calculations using dynamic text
I am trying to find a way to create a dynamic text based on other dynamic text in the presentation slide So I have a DT [Outstanding amount] and another [Disputed amount] I want to add a third to…
- Answered
-
Negative number formats
I have been asked to produce a report with a very particular number format, and I can't see a way to do it They want negative values to be shown in parentheses and in red- I have managed to get the…
- Answered
-
Scaling options in Present panels
The current options for scaling in presentation panels do not allow for scaling on width, so if I have a grid that's wider than the panel, the only option I have to get the columns to fit is "scale…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- Answered
-
Range List Using Two Date Hierarchies
Hello, I don't think this is possible but thought it's worth a shot asking the question! I have a discovery with filters for TransDate and ClosedDate. The aim is to see open transactions at the end…
- Answered
-
Last updated date & time
I remember in BI Office, it was possible to add a text field showing the date and time the source model was last updated. I cannot seem to find this in Pyramid (2018.05.…
- Answered
-
Adding more than one hierarchy level to a discovery
Is it possible to include more than one level from a hierarchy in a discovery? I need to show both City and State but as they are in the same multi-level hierarchy I can't add both.…
- Answered
-
List last FULL month
Hi, I am not sure if I am doing something wrong, but I can't work out how to create a set containing dates from the last full month (so today, I want all dates in February).…
- Answered
-
Parameters don't seem to be working
I added a parameter to one of my dimensions which I also have in rows in my grid. I am not sure if I did something wrong, but when I change the selection in the parameter's drop-down,…
- Answered
Latest Posts
