About MarkTurkenburg

MarkTurkenburg

Hi Team, I'm struggling to understand the concept of Default Files when Exporting. I have created a Saved Export Definition when Exporting from a Module & I am creating a Process to house this so that it can be published on a Dashboard for a User to use I have set the Default file to Private/Myself & when the User has executed the Process Action on the Dashboard & they were able to download the report Could someone help me understand what a Private File is when Exporting data? Thanks! Mark

MarkTurkenburg

Awesome - thanks @anikdas ! Mark

MarkTurkenburg

Hi Team, I'm trying to create a List item from a module through a standard Import action but the Import is using the Line Item name rather than the input data for the List Import. I feel like this is such a simple thing to do but I managed to mess it up somehow 😂 The process is: Create saved view with data from input. The 2 Blank dimensions are for an action after this to allow for the input cell to be cleared The Import from the saved view only allows the selection of Line Items, Dimension 1 or Dimension 2 to be mapped Result of Import - It is taking the Line item name 'New Job Title' as the data import rather than the Line Item value Thanks

MarkTurkenburg

Thanks @rob_marshall & @einas.ibrahim For me I was only able to get it to work by copying the 'Invisible Character' from the URL below & pasting into the Text Box on the Dashboard. Not sure why there was a difference between @einas.ibrahim & my result when copying the blank space between 2 quotes but possibly a software issue http://emptycharacter.com/ In any case this worked for me Appreciate your help Mark

MarkTurkenburg

Good idea @jasonblinn - thanks!

MarkTurkenburg

Good idea @NakulAggarwal in increasing the 2nd Column size rather than the 1st - nice simple solution

MarkTurkenburg

Hi @einas.ibrahim I meant "down the bottom" of my screen shot - I had " " & was copying the space between the 2 quotes But it doesn't work for me. I copy the character but when I paste there is no invisible character that is pasted

MarkTurkenburg

Of course - yes Black Magic! It makes sense but I can't get it to work @einas.ibrahim I have copied the space between the 2 quotes down the bottom but when I paste into the sentences above there is no space added Is this the same process you use? Thanks Mark

MarkTurkenburg

Thanks @rob_marshall! I actually just finished the solution as the email notification popped up. I had the same solution as yourself but I created a Boolean in each of the Time Map modules for Time (Weeks) & Time (Months) & set both to TRUE with Summary as NONE Then the same Formulas as yours for the Time Filter (Weeks) module with a direct reference to both line items above joined by an OR with Summary as FORMULA

MarkTurkenburg

Thanks @rob_marshall I have those line items too but was surprised the ITEM formula didn't return the parent items in the list - I just tried it on General List and it errors if you use Formula as the Summary option so this must not be possible My end aim is to create a Line Item in the 'Time Filter (Weeks)' module where it is TRUE for all Weeks and all Parent Item Months but FALSE for Parent items Half-Year & Year My inital thought was to do: IF TimeMap (Months).ITEM <> TimeMap (Half-Year).ITEM OR TimeMap (Months).ITEM <> TimeMap (Year).ITEM But this won't work due to not being able to return the Parent items with the ITEM formula Is there any other way to return 1 level of Parent as TRUE in the Summary but not others? Thanks Mark

MarkTurkenburg

Hi Team, I'm creating a Time Map module for Time Dimension - Months for a Model Calendar with Weeks with Half-Year Totals selectred The 1st Line Item in my Time Map is ITEM(TIME) which Time Period - Month as the Format & Formulas as the Summary My expectation was that for Parent items, e.g. Half-Year or Year, it would return the Half-Year or Year ITEM but it is returning the 1st item in that Parents list. So for H1 FY20 it is returning Jan20. Any ideas on why this is not returning those values? This question has arisen because I was trying to create a filter for Time - Weeks where Weeks & Months were TRUE but Half-Year & Year were FALSE Thanks! Mark

MarkTurkenburg

That would work perfectly @Misbah but unfortunately I have other modules dimensionalised by Time that sit above this module & I need them to line up too so I cannot swap the 2 modules around Good to know it is simpler in the NUX - time I moved across Mark

MarkTurkenburg

Yes @einas.ibrahim! That's exactly what I'm after - how did you do that? Thanks Mark

MarkTurkenburg

Hi @Misbah Yes the label is disabled so there is no text/labels at the top of the module. I have wrapped the text but I need to increase the size of the label to 18 before it lines up with the other module. Not ideal because there is a little but of text still showing Maybe this is easier on the new UX? I haven't moved across yet Thanks! Mark

MarkTurkenburg

Thanks @anikdas I know to how to drop down a line but I wanted to line up certain items vertically and hence required different lines to have more than 1 space but looks like it is not posisble

MarkTurkenburg

Hi Team, I have 2 modules that I want to line up side by side on a Dashboard. The 2 modules have Employees list as a row item and I don't want to display it twice as it is overkill and will clog up the Dashboard., therefore on the 2nd module I have reduced the size of the Employee column to 6 so it is not visible I have all Page Dimensions as Page Selectors but the 2nd module with the reduced Employee column is now creating a large space at the top of the module and hence they don't line up side by side (see below) Is there anyway to get around this? Thanks

MarkTurkenburg

Thanks @Sorna Raja Prabhu & @einas.ibrahim but I meant adding in extra spaces when entering text like below into a text box Whenever I enter more than 1 space between words it snaps back to just 1 space when you click outside the text box

MarkTurkenburg

Hi @einas.ibrahim What's the 'Invisible Character'? I'm intrigued 🤔

MarkTurkenburg

Hi Team, I have a text box on a Dashboard and I want to line up the sentences in a vertical manner and to do so requires me to add spaces in certain rows so they line up vertically. Anaplan is auto removing these spaces when I click out of the text box Is there anyway to override this function? Thanks Mark

MarkTurkenburg

Thanks @anikdas Yes I was effectively trying to SUM off 2 different hierarchy levels. It works fine now that I have created mapping for #Employee to Clone Region and hence both SUM's are looking at the #Employee hierarchy Mark

MarkTurkenburg

Hi Team, I have an issue whereby I can't SUM from 1 Hierarchical list to 2 different Lists....let me explain with an example I have Source Module which is dimensionalised by #Employee (the parent item of #Employee is Region L1) I have a Target module which is dimensionalised by Clone Region & Budget Owner I have mapping for both #Employee to Budget Owner and Region L1 to Clone Region My thought is that it would be a simple SUM for both Budget Owner & Clone Region dimensions but it errors when you enter both as a SUM but you can do either independently. I'm assuming this has something to do with the fact that #Employee roles up to Region L1? Source Module Mapping for Clone Region Mapping for Budget Owner Target Module - SUM by Clone Region Target Module - SUM by Budget Owner Target module error when both SUM functions are included

MarkTurkenburg

Thanks @jasonblinn That is a little bit disappointing as it is difficult to explain to non Anaplan people that the Dashboard needs to open up at the lowest level (if Selective Access is enabled & they don't have access to the top level) - definitely lowers the User Experience Mark

MarkTurkenburg

Hi Team, I have a Selective Access List which has an internal hierarchy within the list (Parent items that are not from another List) published as Page Selector to a Dashboard. This example is a List of Budget Owners with a top level for 1 section of Budget Owners So for a User with Access to the Tobi Group the Dashboard will open up on Wayne, not on Tobi Group parent item Any ideas?

MarkTurkenburg

Haha - yes it's a bit shaming putting my SELECT:Time work up on the forums....oh the shame 😂 Thanks

MarkTurkenburg

You're a legend @Misbah Thanks!

MarkTurkenburg

Hi Team, Is there any method to place Parent items within a Line Item Subset at the bottom of the group rather than at the top? In the below example 'Total Run-Rate Expense' is the parent of the 3 items above it but when used as a Dimension it is located above those 3 items (see bewlo)

MarkTurkenburg

Thanks @jasonblinn Yes I know I have broken all kinds of best practices by using FY21 rather than a dynamic value but this is for the FY21 Plan & I know next year the model will look completely different and these modules won't be used...still not best practice! Mark

MarkTurkenburg

Hi @Yash1 I have solved the problem by what I call 'Transforming' the data. By that I mean that I created a Line Item Subset from the Line Items in the original module, created a replica of the original module with the line items removed and the Line Item Subset added. I then use Collect() & when you Filter you can use 'Current Page' on the Line Item Subset dimension

MarkTurkenburg

Hi @Yash1 Below is module with the Line item as Pages. I wish for the Filter to be depedent on whether the Current Line Item for the Row has a value greater than zero for FY21 You can only select a Line Item to use for the filter, not the Current Page like all other dimensions

MarkTurkenburg

Hi Team, I have a module with Employee List on the the Rows, Time as Columns and Line Items as Pages. I would like to Filter the Employee items on whether the Time Value selected is greater than zero for the Current Page Line Item It seems you can use Current Page for all other dimension filters except for Line Items where you need to select a Line Item to use as your filter Is there a workaround for this? Thanks Mark