About mwickman

mwickman · 09-27-2023

Hello, I have a story built with the Optimized Design Experience, connected to a import data model (BPC connection). Transactional data and master data are updated on a daily basis. My story has a date filter and a few other dimension filters in th...

mwickman · 08-22-2023

Hi Can anyone tell me if it is possible to add a calculated measure to a list within a dropdown widget, in Analytics designer? If possible, can you provide the correct syntax. Thank you!

mwickman · 03-23-2023

Greetings, I am in search of a way to prevent story viewers from modifying the 'custom current date' input control that resides in the Story Filter bar. Other dimensions allow the story creator to deselect 'Allow viewers to modify selections' (by s...

mwickman · 02-24-2023

Greetings, A user recently enabled the Optimized View feature on an existing story, and now the story fails to load. The screen is showing " We are optimizing the story so that it will load and open more quickly in the future." but fails to move pa...

mwickman · 01-05-2023

Greetings, I have a requirement to show YoY change and % Change in a table, which works reasonably well when only one version is used (e.g. ACTUALS) using the Difference From calculation. However, I need to be able to create this table with a comb...

mwickman · 08-22-2023

Thank you for the response Nikhil! I should have provided a little more detail. Your method is good for populating all measures, which would include any calculations. However, I have quite a few measures in my model and would like the dropdown list t...

mwickman · 03-24-2023

Thank you for the response! Unfortunately I am unable to find View Time Settings option in my story. My version is '2023.2.10 (Client)'. Is this in the next release?

mwickman · 02-27-2023

Thank you for the responses. Incognito/Private session suggestion was unsuccessful. Story would attempt to load > 1 hour. However, I was able to troubleshoot myself and restore the story to working order by modifying the URL to open the story in edit...

mwickman · 09-23-2022

Yes I have tried this but the result is the same, and not optimal as it would be hard to navigate our extensive cost center hierarchy in a chart. The table still displays the top level parent cost center, rather than only the selected cost center and...

mwickman · 07-20-2022

Thank you! This worked. Ideally I could show the chart without the year to avoid any confusion but can apply other formatting to make clear.

User Statistics

User Activity

SAC - Story filters not visible

Adding a calculated measure to a dropdown selector

Custom Current Date input control - prevent user modification

SAC Story not loading after Optimizing view enabled

YoY Calculation across versions

Re: Adding a calculated measure to a dropdown selector

Re: Custom Current Date input control - prevent user modification

Re: SAC Story not loading after Optimizing view enabled

Re: How do I display only the selected hierarchy node?

Re: SAC line chart comparing multiple years