Creating an Info Map with OLAP as source

[jplarios]

Can anyone point me to some doc about creating an IM from an OLAP source using IM with SAS 9.1.3 ?
Thanks,
jp

[Cynthia_sas]

Hi:
We cover this in our BI training classes. Otherwise, here are some papers that talk about using OLAP cubes and Information Maps:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/infomap31_tips_9310.pdf (page 17 and 47-48)
http://www2.sas.com/proceedings/sugi29/104-29.pdf (page 8 and 9)

http://www.zencos.com/pdf/212-2007.pdf
http://analytics.ncsu.edu/sesug/2008/CS-055.pdf

cynthia

[jplarios]

Cynthia,
Thanks. Although to create them ( relational vs mdx) are very similar, they behave/ouput very differently. At least in SAS 9.1.3. Message was edited by: jplarios

[MrE]

Dear all,

I would like to create Dimension from Measure value. For example,
I have "balance_amount" as a measure in cube. When I generates report in WRS, I would like to create "balance_amount_tier" as dimension by using MDX code in Information Map.

Example of balance_amount_tier
1. 0 - 10,000
2. 10,001 - 50,000
3. > 50,000


Is there the way to do this? Any suggestion ?

Thanks

[UCFAngel]

You could try to create a new character data item named balance_amount_tier using an expression that uses CASE statements. The following document shows how to do this in the "Create Conditional SQL Code" section:
http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/infomap31_tips_9310.pdf

The following sample may also help:
http://support.sas.com/kb/38/331.html

[MrE]

Thanks UCFAngel .


I tried what you suggest. It works for only relational table , not for OLAP Cube.
I would like to create 'balance_amount_tier' dimension from 'balance_amount' which is a measure in OLAP Cube.

However, I tried MDX code using 'IIF' but cannot set type as OLAP category.

Can I do this? Please suggest.

[UCFAngel]

I'm sorry but I don't have MDX experience. The following paper may help.

http://support.sas.com/resources/papers/proceedings09/042-2009.pdf

[jplarios]

MrE,
Why not have this in the input source of the cube as an attribute like a Tier atttribute then use this in the cube.

ALso, try fast track to mdx to get an understanding around mdx.
good luck.