Traditional web-based reporting with SAS BI tools

Creating an Info Map with OLAP as source

Reply
Regular Contributor
Posts: 163

Creating an Info Map with OLAP as source

Can anyone point me to some doc about creating an IM from an OLAP source using IM with SAS 9.1.3 ?
Thanks,
jp
SAS Super FREQ
Posts: 8,720

Re: Creating an Info Map with OLAP as source

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
Regular Contributor
Posts: 163

Re: Creating an Info Map with OLAP as source

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
SAS Employee MrE
SAS Employee
Posts: 11

Re: Creating an Info Map with OLAP as source

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
Contributor
Posts: 53

Re: Creating an Info Map with OLAP as source

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
SAS Employee MrE
SAS Employee
Posts: 11

Re: Creating an Info Map with OLAP as source

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.
Contributor
Posts: 53

Re: Creating an Info Map with OLAP as source

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
Regular Contributor
Posts: 163

Re: Creating an Info Map with OLAP as source

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.
Ask a Question
Discussion stats
  • 7 replies
  • 394 views
  • 0 likes
  • 4 in conversation