We are a global management consulting firm and are looking for data scientists in our team in New York/Washington DC and Gurgaon/Chennai (India). There are full-time and internship (New York) opportunities. There are multiple positions i…
Category: SAS
Looking to hire data scientists
We’re looking for data scientists in our team in New York/Washington DC and Gurgaon/Chennai (India). There are full-time and internship (New York) opportunities. There are multiple positions including developing complex models in he…
Looking to hire data scientists
We are a global management consulting firm and are looking for data scientists in our team in New York/Washington DC and Gurgaon/Chennai (India). There are full-time and internship (New York) opportunities. There are multiple positions i…
Enabling OLAP drill-through to detail for web reports
I mentioned back in 2008 that Web Reports with OLAP source can drill-through to detail (or display the raw data records for the corresponding cross tabular cell) only after the source information map has drill-through to detail enabled. Well, there are…
Catching Up & Looking Ahead
It’s been a long, long while since I’ve updated this blog. I’m the first to admit that I’ve been wracked with guilt about not posting in quite some time. It does seem that sometime life – and work too! – get in the way.We’ve had an exciting and strange…
Catching Up & Looking Ahead
It’s been a long, long while since I’ve updated this blog. I’m the first to admit that I’ve been wracked with guilt about not posting in quite some time. It does seem that sometime life – and work too! – get in the way.We’ve had an exciting and strange…
Catching Up & Looking Ahead
It’s been a long, long while since I’ve updated this blog. I’m the first to admit that I’ve been wracked with guilt about not posting in quite some time. It does seem that sometime life – and work too! – get in the way.We’ve had an exciting and strange…
Info Map: Why does the data item show as scientific notation?
When a data item is created in Information Map Studio, the defaults are assigned for classifications and aggregations. If the data item is a percentage, this defaults may not make sense. For instance, the following figure shows the Gross Margin in scientific notation instead of a percentage. When the data item was imported, the default aggregation method was SUM, which does not work in this case. The gross margin is your profit from this sale and it should remain constant or in other words. So how do you fix it? You need to change the default measurement for the data item. For a value like Gross Margin, there is not reason to aggregate this data item – when is a sum of all Gross Margins for a customer or product used? For this item, the gross margin is associated with the Product data item. Any product no matter to which customer in any region, the gross margin remains constant. You have to select a default aggregation method, so I chose Average. I thought it would make the most sense to the end user. I could have also used Minimum. In the following figure, minimum would have set the value to […]