About jbrass

jbrass · ‎01-17-2020

My extract has multiple lines per SFDC Opp ID, so I'd need to get a unique ID for that Opp ID/Product ID combination, and I'm working the SFDC guy in house to see if we can get that. Was working on this as a backup method in case we can't get that. Anyway, this works! Thanks for your prompt help!

jbrass · ‎01-17-2020

Update - figured out the rank function. Thanks so much! Rob - still open to discuss the approach.

jbrass · ‎01-17-2020

Thank you both. Still struggling with the RANK function a bit. The first input in the function is the source data, which has a requirement of being a number, date, or time period. What should I point this first parameter to? Rob - in regards to your question: I am trying to ingest a data source that does not include a unique ID. This is going to come as a manual file load (for now), and therefore there is no ETL layer that I can leverage to source a unique ID. I'm OK with manually populating a basic unique ID in the source file (by just including a "row()" formula in excel), but need a mechanism by which we can clear and reload portions of the data as needed. So, I need an ID that I'll be able to replicate next time I load the data, and have Anaplan know which items to replace vs. add to the list. I was going to use the example above to accomplish that. My example was obviously very much simplified, and the real example would actually be a concatenation of SFDC opportunity and product. Hope this makes sense, and open to feedback. Thanks, Josh

jbrass · ‎01-17-2020

Hi All, I was hoping to get some with a problem that I'm trying to solve. I have a module with a line item that is list formatted. In this module, the 'applies to' is a list that has 7 values. The line item in the module has the following items shown for each of the 7 rows: item 1: Product A item 2: Product B item 3: Product B item 4: Product C item 5: Product C item 6: Product C item 7: Product D I'm trying to identify items that are shown more than once and create an additional snippet of text at the end to effectively make each item completely unique. The output I'd like to see is: item 1: Product A_1 item 2: Product B_1 item 3: Product B_2 item 4: Product C_1 item 5: Product C_2 item 6: Product C_3 item 7: Product D_1 NOTE: I do not want to set this up with a series of isfirstoccurrence logic that would require for me to setup a bunch of line items to accommodate any number of duplicate results. This logic needs to work with any number of duplicate results. Can anyone solve this for me?! Thank you!

jbrass · ‎10-31-2019

Hello, I constantly run into the same issue and I'm hoping that someone can help suggest a solution. When I create an action that imports from a csv file into a list or module, I always find it difficult to re-open up that import action and revise (or just view) the mapping that was previously created. Instead, I have to do this funky workaround where I re-import a file that has the same name as the file that was previously loaded only for the purpose of viewing the mappings. This seems silly to me; hoping someone has a better solution. Thanks! Josh

jbrass · ‎10-01-2019

Hello all! In the modules screen within settings, you can view whether a given module is shown on a dashboard AND which other modules reference that module. This gives a great indication whether or not that module is active OR whether it is a candidate for getting deleted. What is NOT shown, however, is if a given module is referred to within a filter of another module. I'd like to see that added as a column within the modules screen. Furthermore, would be great to be able to tell if that module is used as either the target or source of an action. If none of the above were the case, could Anaplan almost suggest that this is an unused module and therefore should be heavily considered for deletion? Of course, if you have users that open modules directly and view data from them, then you could have the risk of that view just going away, however I always make all users go through dashboards instead so this wouldn't be a risk for me. Thoughts? Thanks!! Josh

jbrass · ‎06-27-2019

Thanks Rob, that is helpful, and I somehow never noticed that feature before. This doesn't exactly solve what I need though. I have an L1 list and an L2 list. If L1 was customer and L2 was product, then I'm looking to export the data related to the 1st L1 item to excel, and then have the same happen in the 2nd tab but for the 2nd L1 item. Basically, if I have a dashboard which syncs on the L1, but shows both the L1 and L2 levels, then I'm looking for an excel tab that mimics what happens every time I select a new L1 item. Does that make sense? Thanks, Josh

jbrass · ‎06-27-2019

I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each of the departments. This isn't the exact example I'm looking for (in fact, the example I'm looking for has about 100 items in the list), but this should give you a sense of what I'm looking for. Thanks, Josh

jbrass · ‎06-10-2019

Hi David, The example below was just an example; not the exact use-case I'm looking for. I'm looking for a smooth way to create a list of the concatenation of 2 line items in a module that has 2 different lists in the applies-to. For example, if you had a module with an Acct List and a Cost Center List, and then you have an "Amount" column. If you were trying to create a saved view that just isolated the code of the Acct List with the code of the Cost Center list for items with Amount <> 0, and then publish those concatenated items to its own list. That's effectively what I'm trying to do. Thanks! Josh

jbrass · ‎06-06-2019

Thanks Leonardo and Rob for your responses. I'm not sure that the answer given achieves the result that I'm looking for. Please see screenshots below as an example. The first screenshot shows an example of what I'm trying to do. If you have 2 lists in the applies to (for example cost center and GL account), I'm trying to do a FirstOccurrence on the concatenation of the codes of those list items (see the "P&L/CC Combo Text" line item). Note that below, I've included "time" in the module, so the result should show a check box under the first item shown, and not the 3 items thereafter (since the concatenated item was already shown). I've tried using just 1 of the lists in the end of the isfirstoccurrence formula, but that doesn't seem to work (see columns 2 and 3). Hope this makes sense. Please let me know if you need more info. Thanks! Josh Brass Thanks, Josh

jbrass · ‎06-04-2019

Hello, Does anyone know if it's possible to do a firstoccurrence formula on a module with 2 lists in the 'applies to'? Thanks! Josh Brass

jbrass · ‎04-02-2019

Fair enough, thanks!

jbrass · ‎04-02-2019

Hi All, I could swear that I've seen some dashboards created that include a fancy green check mark or a red "X". How do I get those to show in a module or dashboard? Also would be good to see which special characters work in Anaplan (such as the triangle delta sign). Thanks! Josh Josh Brass Brass Planning Solutions, Inc.

jbrass · ‎01-03-2019

Hello, I'm trying to import a date into a text-formatted property from a source file. This works on my machine, however when another user uploads the same file, it seems to be creating a text field which includes 2 digits for the year vs. 4. So, when I run the import, the text-formatted field reads "12/31/2018", but when someone else runs the same file, it reads "12/31/18". Does anyone know why this is happening? I've had the user send me the source file that they are using, and it still shows with the 4 digit date on my machine, but 2 digits when he uploads that file. Since I'm using this property as part of a "combination of properties" to create a unique ID, this is a very important item. Thoughts? Thanks, Josh

About jbrass

Re: Tagging Duplicate Items

Re: Tagging Duplicate Items

Re: Tagging Duplicate Items

Tagging Duplicate Items

See mappings for file imports

Filter References

Re: Exporting data to different tabs in excel

Exporting data to different tabs in excel

Re: First Occurrence on module with multiple lists...

Re: First Occurrence on module with multiple lists...

First Occurrence on module with multiple lists in ...

Re: Green check mark and red X

Green check mark and red X

Issue importing dates as text

Filter References

See mappings for file imports

Re: Tagging Duplicate Items

First Occurrence on module with multiple lists in ...

First Occurrence on module with multiple lists in ...

Re: Tagging Duplicate Items

See mappings for file imports

Filter References

First Occurrence on module with multiple lists in ...

Re: Tagging Duplicate Items

See mappings for file imports

Filter References

Ability to schedule nightly model or workspace arc...

Ability to open a module directly from drill down ...

Function that returns a user's role

Extend the number of future years

Able to use the row id number as unique identifier...