About 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 · ‎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.

About dan_ossmann

Re: Condition-Based Trigger for Email Reporting

Re: What's New: February 10, 2018

Re: What's New: February 10, 2018

Re: Minneapolis User group December 8 morning meet...

Minneapolis User group December 8 morning meeting ...

Meet Up In Minneapolis?

Re: 351 Schemas

Re: Mpls User Group Logistics - Date, Time, Social...

May 5, 2017 Agenda

RE: Refresh Timestamp/Username

RE: Excel View Refresh information

RE: testing for a time period before the first mod...

testing for a time period before the first model t...

Excel add-in, receive data for multiple sheets

RE: Calculating a % of a subset

Calculating a % of a subset

May 5, 2017 Agenda

Re: What's New: February 10, 2018

Re: What's New: February 10, 2018

Re: Mpls User Group Logistics - Date, Time, Social...

Re: What's New: February 10, 2018

Re: What's New: February 10, 2018

Re: Mpls User Group Logistics - Date, Time, Social...

May 5, 2017 Agenda

Re: What's New: February 10, 2018

Re: What's New: February 10, 2018

Re: Mpls User Group Logistics - Date, Time, Social...

May 5, 2017 Agenda

Current Date and Time

Condition-Based Trigger for Email Reporting