Ian Macdonald's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid Analytics

Country

Latest Posts

Re: Parameterised Year To Date
Hi Ben, From your code I see you are using SSAS. Can you tell me what attributes / hierarchies you have available in your Dates dimension? I'm guessing you have a Full Month, i.e.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nicholas, You can use the same dimension in the source and target of Sankey Charts, but of course then whatever members you select will appear on both sides of the chart.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Custom Groupings
Hi Ben, OK, so do you need any further help on this? Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: PQL Date Query
Hi Dan, Here you go. I'm assuming you have a dimension of something like [Full Month Name] which contains members such as [Feb 2022] and one of [Year] which contains members such as [2022].…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: PQL Date Query
Thanks Dan, Can you please tell me the data source type, SQL or MDX? Does the Month / Year item make up Date hierarchy? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Custom Groupings
Hi Ben, I'm not sure that I quite understand what you are trying to do. Can you give me a bit more explanation? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Displaying two grids as 1
Hi Satveer, The only way for them to be in the same table (grid) is for the selected items to be in one query. To get the second column, the % for C, you will need to create that calculation in the…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Changing Filter Type in Analyze Further
Hi Dan, Analyse further only offers drop down filter types. As far as I know there is no plan currently to provide the ability to place measures on secondary axes in Analyse Further.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: PQL Date Query
Hi Dan, Some clarification please. When you select the parameter, as Apr 2022, do you want the formulation to return the total premium changes for the whole of 2020, Jan through Dec, or 2021,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Grid Size and Scrolling
Note that the "Grab Bar" only appears if there are measures present, so you may have to add a measure, adjust the width of the dimension rows, then remove the measure if you are dealing with reports…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Grid Size and Scrolling
Hi Sophie, Position your cursor on the dividing line between your Dimension Rows and your Measures. You should see a "Grab Bar" appear. Click and drag that to the right to increase the area…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, Further to the above, note that there is a subtle difference between "YYYY" and "yyyy" when formatting a date to a year. "yyyy" gives the Calendar Year,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, You could create a list that contains the last but one year, by creating a standard list of all the years, then filtering that to get the last two,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Select Current Year in a Discovery
Hi Sophie, Can you confirm the database type you are accessing? Dates are one of those things that behave differently analytically between SQL (IMDB and other relational DBs) and MDX (SSAS and SAP…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, I used background formatting rather than foreground as I found it easier to override the background then the foreground. I also found that using the Transaction in the Color Drop Zone,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Parameter Format
Hi Dan, Yes. And No. Set the Parameter type to be Continuous and set the lower and upper bounds and the increment. Then on the Default section, set the visualisation to Text Box and then set the…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, What version of Pyramid are you using? The formatting panel as in my screenshot is available in 2020.20 and onwards. You access it by clicking on the format pointer,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Multi Select (All) parameters
Hi Nick, Best way to accomplish this would be to construct a dynamic List of the items in your Hierarchy thus: Then use this list, M List in this case, to populate the slicer or parameter.…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Display "all" in dynamic text when user selects all options in multiselect dropdown
Hi Rob, Not directly. What you could do is to measure the length of the string returned when All is selected, then if that length is found, set the text to "All Selected" otherwise the list of those…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Actually, it is easier to override the background colour drop zone formatting using the grid formatting options:
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Using Variables with strings in Master flow
Hi @Niko Z Did Shai's solution work for you? Thanks, Ian
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, Yes. I think ability to hide rows / columns would be useful in a number of scenarios. But, I do have an alternative solution for you. If you drop the transaction id into the Color drop…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Group By option for grids
Hi Sophie, Unfortunately I can see no way to achieve this. In order to see the individual transactions, then the transaction id must be present in the report,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Selection set under Data Point not possible
Hi Maaike, As the list you are counting is in the Transactions dimension, by default that is where the custom member will be placed. If you want it to be a measure,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view
Re: Selection set under Data Point not possible
Hi Maaike, What is the formula you are trying to create? A data point or Tuple or Record cannot have a list of members as an argument. If it did it would effectively represent a set of data points,…
- VP Product Management
- Ian_Macdonald
- 3 yrs ago
- Questions & Answers
- Reported - view

1 15 16 17 18 19 25

Back to top

Home

View all topics