About dan_ossmann

dan_ossmann · ‎03-09-2020

No. My page is still MIA.

dan_ossmann · ‎03-05-2020

It is odd that the first thing I wanted to do was select My Pages. I don't have My Pages on the home screen and I do not have My Pages on the Home menu. Maybe I am missing something? Dan Ossmann

dan_ossmann · ‎05-10-2019

Capella University has similar need. we would like to evaluate a line item and send an email if the value is outside an acceptable range

dan_ossmann · ‎05-02-2019

I do not see how to uninstall the v3.0 app.I can inactivate it in excel options. I can update it under the windows start menu. there does not seem to be an uninstall program provided.

dan_ossmann · ‎05-17-2018

I have always found user groups to be useful and interesting. I work for Capella University so this group is a natural fit. We are constantly building out our connected models, adding complexity, fine tuning, removing complexity, right sizing. Our fist use case in 2014 was a P&L with a very granular headcount/expense module(s). Now we use Anaplan in marketing, pricing, IT capacity, profitability.

dan_ossmann · ‎02-27-2018

right you are Monica. I was kind of responding to derek_chen and wlederer_1. they each suggested that the hyper link attached to the logo should be removed and i disagree.

dan_ossmann · ‎02-27-2018

I do not care for the hamberger menu. It does give me access to a couple of Administration and App Hub which was not easy before. What is also does is require an extra click to get to the model selection. I change models all the time. I almost never go to Admin or App Hub. For me, it is better to have the hyper link available. It is never better to add a click to my most frequent menu choice.

dan_ossmann · ‎12-04-2017

Updated and improved agenda.

dan_ossmann · ‎12-04-2017

dan_ossmann · ‎12-04-2017

So what is this meet up? where is it? Who is sponsoring it?

dan_ossmann · ‎05-12-2017

It would be nice to have the time committment listed

dan_ossmann · ‎05-08-2017

I like July 27. It is just late enough to have the earnings release behind us.

dan_ossmann · ‎04-21-2017

dan_ossmann · ‎07-26-2016

Nice idea but it displays N/A for all the View Information group of details. Any other guesses?

dan_ossmann · ‎08-21-2015

Thanks for the answer Chris. I was afraid the answer was no. I did check out the show history topic you linked to. I have to say that functionality is the least useful I have seen so far. I wonder if others have found a way to get something out of it. Dan

dan_ossmann · ‎06-24-2015

very nice and clear. thank you for the insight. Dan Ossmann

dan_ossmann · ‎06-16-2015

I want to average quarter values for the last several years. i use (offset(lineitem,-x,0) + offset(lineitem,-x+1,0)) / 2. when the offset runs off the beginning end of my time period, i would like to do something different with the formula. How do i test for this condition when i refer to an invalid time period or date?

dan_ossmann · ‎06-05-2015

Hi, does anyone know a way to retrieve data for multiple sheets/ views. Possibly a macro calling the anaplan add-in button retrieve data?

dan_ossmann · ‎05-20-2015

I do try this and get an error related to the dimensions in the source module. i.e. 'format of mapping used for lookup doesn'tmatch any dimension of the source." I get it that the souce module does not have the school dimension. the source data does not inherently have school. I was kind of hoping that I could get at this total using the property. So my data looks like this. I have only the one line item (Active). The only dimension in the module is Product. I thought I would insert a new line item with the schools property subset for SOBT on that line item alone (but it didn't). then i thought i would create a new module with Product and Schools dimensions but the formula still wants the source to have the dimension schools. how do i write a formula that looks at the property of the product and sum based on that property? Line item Property Active School Product 1 42 SOBT Product 2 96 SOE Product 3 45 SOUS Product 4 67 SOBT Product 5 83 SOBT Product 6 14 SOE

dan_ossmann · ‎05-20-2015

I have the total active customers by product. I have products organized into schools. I can calculate the percent each product represents of the total of all products regardless of school. I do this in a module with two line items, Active and Active %. The formula is Active / Active[SELECT:’Programs P2’.All Programs]. I would like to calculate the percent each product represents of the total of products in the school. I do not understand how to calculate the divisor, the sum of the products in only one school. The products are in a list called Programs P2. The Schools are in a list called Schools. Programs P2 has a list-formatted property called School.