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,
Appreciate any guidance regarding this.
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.
Thanks Anand...
Also do you know about joining multiple fact tables in an information map?
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
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
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
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
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
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
Hi Anand,
No Problem..Thanks for you time and link shared.
I will update the forum once i have the answer.
Hi Sheeba,
I have the same question. Did you already find an answer?
Regards,
Edgar
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
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
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
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!
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.