topic Re: Information Map - Data item as measure does not appear in EG in SAS Enterprise Guide

Information Map - Data item as measure does not appear in EG

SanjayM — Mon, 27 Aug 2007 17:36:19 GMT

Hi there

I have created a data item in my Information Map which does not show when I use that Information Map in EG.

The data item Total is an expression as SUM(CostPrice, Quantity) and becomes a measure.

This is a very common requirement where we want to create data items which are expressions but unfortunately does not show in EG.

Second question is about when to make the columns in Information Map as Category or Measure.

The Great Hopper

Re: Information Map - Data item as measure does not appear in EG

Cynthia_sas — Mon, 27 Aug 2007 19:15:17 GMT

Possibly you are running into this problem:
http://support.sas.com/techsup/unotes/SN/018/018939.html
SAS® Enterprise Guide® and the SAS® Add-In for Microsoft Office will not display calculated measures defined in an information map

To find this Tech Support Note, I went to:
http://support.sas.com/techsup and entered
Information Map data item not show Enterprise Guide
into the yellow/gold search field area on the right hand side of the window. This Tech Support Note was the first hit in the list of returned notes.

You should check with Tech Support if this does not fix the issue for your Information Map.

cynthia

Re: Information Map - Data item as measure does not appear in EG

SanjayM — Mon, 27 Aug 2007 20:55:07 GMT

Million thanks that was a great help. I was very sure that there should be a way out.

Re: Information Map - Data item as measure does not appear in EG

deleted_user — Tue, 28 Aug 2007 15:30:26 GMT

Hi cynthia

I tried doing what is given in the Tech Support.
Now i am able to see a measure column in EG.
But if i use any functions like SUM,AVG.
I am not able to see in EG

Example:-
Suppose i create a new data item item1 as
SUM(col1,col2)*col3
then i am not able to see item1 in EG

and if i create another a new data item item2 as
(col1+col2)*col3
then i am able to see item2 in EG
I want to use this SUM function since i dont know if col1 data has null values then if i sumup without SUM func then i will get null value.
Can you help me wht should i do..

Sunil

Re: Information Map - Data item as measure does not appear in EG

Cynthia_sas — Tue, 28 Aug 2007 19:52:39 GMT

Hi:
Your best bet for this issue might be to contact Tech Support. I understand what you're trying to do, but am not sure whether this is happening because of how Information Maps have their interface to EG or whether it's something inherent in the design of how Information Maps work.

cynthia