BookmarkSubscribeRSS Feed
jplarios
Quartz | Level 8
Can anyone point me to some doc about creating an IM from an OLAP source using IM with SAS 9.1.3 ?
Thanks,
jp
7 REPLIES 7
Cynthia_sas
SAS Super FREQ
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
Quartz | Level 8
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
SAS Employee MrE
SAS Employee
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
Obsidian | Level 7
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
SAS Employee MrE
SAS Employee
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
Obsidian | Level 7
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
Quartz | Level 8
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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1797 views
  • 0 likes
  • 4 in conversation