topic Re: Reg Information Map studio in SAS Programming

Reg Information Map studio

Sheeba — Tue, 02 Apr 2013 19:04:09 GMT

Hi,

I have a query regarding the Information Map studio. Is it possible to combine views and oracle tables as data source for sas information map studio?

Also how do you join multiple facts in an information map. I have read that SAS 9.3 Intelligent Query generator helps in this.How do we use this to include multiple facts? Is there any other options?

Thanks in advance,

Re: Reg Information Map studio

Sheeba — Wed, 03 Apr 2013 17:19:56 GMT

Appreciate any guidance regarding this.

Re: Reg Information Map studio

Anand — Thu, 04 Apr 2013 09:04:30 GMT

Hi Sheeba,

Please follow the steps:

1) Create a Oracle librarry from Management console.

2) Add tables and views into that library.

3) At Information map studio use the libarary created in step 1) and use the tables & views and do what ever join u want to do.

Re: Reg Information Map studio

Sheeba — Thu, 04 Apr 2013 17:17:15 GMT

Thanks Anand...

Also do you know about joining multiple fact tables in an information map?

Re: Reg Information Map studio

Anand — Fri, 05 Apr 2013 04:51:33 GMT

Sheeba,

Follow these steps to create joins.

1) Open the Information map studion and select the Libarry from Resource tab.

2) Click on + sign for the library and select tables & view and drag these object to next Design Tab.

2) Once required tables dragged into Design Tab click on Relationship Tab. You will see all dragged tables there as well.

4) Right click on first table and click Add Relationship. A new window will open which is very user friendly where you can create more than one joins based on your requiremnets.

Thanks

Re: Reg Information Map studio

Sheeba — Fri, 05 Apr 2013 15:07:59 GMT

Hi Anand,

Thank you but My question is not regarding the join of multiple dimensions. I am asking about joining the multiple facts in a schema

Re: Reg Information Map studio

Sheeba — Fri, 05 Apr 2013 17:01:51 GMT

To be precise, I would like to know how to solve the complexities of many to many join which arises as a result of multifact joins. Also about intelligent query generator

Re: Reg Information Map studio

Anand — Mon, 08 Apr 2013 04:20:38 GMT

Sheeba,

I don't know how to join facts & dimension tables using Information map studio. Bur as per my understanding facts & dimesnions are nothing but our warehouse concepts and naming conventions to better understand. Here question is how SAS will understand that whether we are using fact or dimension tables, My understanding it will use both as a table. So its on you how you are going to use facts & dimension tables.

For query generator, it is available in the last step of Information map studio.

Thanks

Re: Reg Information Map studio

Sheeba — Mon, 08 Apr 2013 04:27:14 GMT

Hi Anand,

Thank you for the reply...

But it is about the type of joins( one to many and many to many) that is how the difference comes...... and regarding the query generator , my question is about modifying the information map to accommodate snowflake schema( join= advanced). In the last step mentioned in information studio, the relationship is inserted and query is generated. Again my question is about SAS 9.3 Intelligent Query generator which is advanced feature...hope you got the question

Re: Reg Information Map studio

Anand — Mon, 08 Apr 2013 04:33:33 GMT

Sheeba,

Sorry to say, but i haven't worked on SAS 9.3 Intelligent Query generator. You can check with following link which might be helpful

http://support.sas.com/resources/papers/proceedings12/033-2012.pdf

Thanks

Re: Reg Information Map studio

Sheeba — Mon, 08 Apr 2013 04:39:04 GMT

Hi Anand,

No Problem..Thanks for you time and link shared.

I will update the forum once i have the answer.

Re: Reg Information Map studio

Edgar — Mon, 22 Apr 2013 08:16:09 GMT

Hi Sheeba,

I have the same question. Did you already find an answer?

Regards,
Edgar

Re: Reg Information Map studio

Sheeba — Mon, 22 Apr 2013 16:12:07 GMT

Hi Edgar,

I didn't get a chance to implement it till now. but got the following information.

In SAS 9.3, the Intelligent Query generator can be activated in PROC INFOMAPS with a new option on the NEW

INFOMAP and UPDATE INFOMAP statements:

JOIN_MODEL=BASIC | ADVANCED

After setting JOIN_MODEL=ADVANCED for a new map in PROC INFOMAPS, a user can then continue constructing

the map with PROC INFOMAPS. The Intelligent Query generator is now invoked when querying from that map in

SAS 9.3.

update infomap "Name of InfoMap"

mappath="/Users/myUserID/My Folder"

description="Use new Query generator"

join_model=advanced;

save;

After updating an existing map with JOIN_MODEL=ADVANCED, a user can simply save the map and the Intelligent

Query generator is now invoked when querying from that map in SAS 9.3.

Hope this will help you out.

Regards,

Sheeba

Re: Reg Information Map studio

Edgar — Mon, 22 Apr 2013 17:48:07 GMT

Hi Sheeba,

I've tried the same solution. However, it returned with an error like something (I don't know by heart, I am not in the office now) "Multipe data sets with same identifier".

I will let our IT forward it to TechSupport. Let's see what they come up with.

Let you know when I made it work.

Regards,
Edgar

Re: Reg Information Map studio

Edgar — Fri, 24 May 2013 06:54:42 GMT

Hi Sheeba,

I've tried the solution and indeed it works.

After the update has been performed it is not possible to open the Information Map in Information Map Studio anymore, I've just updated a copy.

Although, now I do have an issue with role playing dimensions.

Regards,

Edgar

Re: Reg Information Map studio

Madelyn_SAS — Thu, 27 Jun 2013 23:02:30 GMT

Note that SAS Information Map Studio cannot be used to edit information maps that were

built or modified using any of the following PROC INFOMAPS statements and

options.

The EXPORT LOCALIZABLE_PROPERTIES and IMPORT LOCALIZED_PROPERTIES
statements, which support localizing information map properties for multiple
locales.
The RESULTS_FILTERS filter assignment value used with the SET
ASSIGNED_FILTERS statement. RESULTS_FILTERS is used to specify one or more
filters that are applied after query results are generated.
The JOIN_MODEL= option on the NEW INFOMAP and UPDATE INFOMAP statements.
This option enables you to control whether a basic or advanced model is used for
the join strategy during query generation.

See 47394 - PROC INFOMAPS in SAS® 9.3 includes statements and options that are not supported in SAS® Information Map Studio

Re: Reg Information Map studio

Sheeba — Fri, 28 Jun 2013 17:39:27 GMT

Hi,

Thanks for the detailed reply.

Yes, I was trying to use JOIN_MODEL= option to build an information map from snowflake schema. So I used update infomap statements.

I got the same error which is mentioned in the attached document.

Thanks for the clarifications.

Regards,

Sheeba Swaminathan