04-02-2013 03:04 PM
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,
04-04-2013 05:04 AM
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.
04-05-2013 12:51 AM
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.
04-05-2013 01:01 PM
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
04-08-2013 12:20 AM
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.
04-08-2013 12:27 AM
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
04-08-2013 12:33 AM
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
04-22-2013 12:12 PM
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
update infomap "Name of InfoMap"
description="Use new Query generator"
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.
04-22-2013 01:48 PM
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.
05-24-2013 02:54 AM
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.