topic Re: Creating an Info Map with OLAP as source in SAS Web Report Studio

Creating an Info Map with OLAP as source

jplarios — Mon, 01 Mar 2010 19:30:12 GMT

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

Re: Creating an Info Map with OLAP as source

Cynthia_sas — Mon, 01 Mar 2010 22:02:17 GMT

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

Re: Creating an Info Map with OLAP as source

jplarios — Tue, 02 Mar 2010 16:11:37 GMT

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

Re: Creating an Info Map with OLAP as source

MrE — Thu, 11 Mar 2010 04:37:50 GMT

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

Re: Creating an Info Map with OLAP as source

UCFAngel — Fri, 12 Mar 2010 21:40:52 GMT

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

Re: Creating an Info Map with OLAP as source

MrE — Mon, 15 Mar 2010 09:50:11 GMT

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.

Re: Creating an Info Map with OLAP as source

UCFAngel — Mon, 15 Mar 2010 16:19:17 GMT

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

Re: Creating an Info Map with OLAP as source

jplarios — Tue, 16 Mar 2010 13:05:17 GMT

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.