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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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
  • 1262 views
  • 0 likes
  • 4 in conversation