Question

Why is my Materialized View does not show up in IFS


Userlevel 3
Badge +5

I created a Materialized View (in IFS Apps9) and refreshed dictionary cache after assigning IFSINFO and IFSSYS. 

But I cannot see it in the following IFS window.

What could be the reason and how do I resolve it?

i have attached the .cre file i used to create the MV.

 

Thank you!


This topic has been closed for comments

14 replies

Userlevel 4
Badge +8

HI @manjareed ,

Please run below query and see if your MV is fetched. The conditions defined in XLR_MVIEWS might prevent your MV from fetching onto this window. 

SELECT *
FROM xlr_mviews

Best Regards,

Nisansala

Userlevel 3
Badge +5

I do not see my MV in the above query.

what am I missing here?

Can you please let me know what  steps to follow when creating MV in Apps 9?

The reason for creating this MV is , to use it in a Quick Information Source.

what I did was, I created a custom view using this MV and used the custom view to create the QIS.

 

 

Thanks!

Userlevel 7
Badge +18

Hi @manjareed,

 

Is this Materialized View created in the application owner schema?

Userlevel 3
Badge +5

Yes, I created the MV in application owner schema.

 

Thanks!

Userlevel 3
Badge +5

I noticed, the reason for my MV not to be available in XLR_MVIEWS is because my MV is not available in XLR_MV_REF_TAB. 

Is there a special way of creating a MV to be available in XLR_MV_REF_TAB?

Userlevel 7
Badge +18

Hi @manjareed 

Data Mart sources window shows only the MVs which are added to XLR_MV_REF_TAB. XLR_MV_REF_TAB contains only the MVs used in Information Sources.

Seems your MV is not used in information sources.

Therefore, it is not available in  XLR_MV_REF_TAB.

Go to Data Mart Refresh Categories window

Find your Materialized View from one of the listed entries. Then Refresh.

Now go to Data mart Sources, search your Materialized View

Try this. It may helps.

Best Regards

-Kelum

Userlevel 3
Badge +5

Hi Kelum,

I checked in  Data Mart Refresh Categories window, but do not see my MV listed in any of the categories.

so, I created an Information Source which has only Data Mart view . Attached are the source files I used to create the FACT.  MV is NICH_TEST_MV.

But still I do not see the MV in the XLR_MVIEWS.

What am I missing here?

 

Thank you!

 

 

Userlevel 7
Badge +18

Hi @manjareed ,

Please try below.

Go to “Entity Info – Incremental Load” window. Your problematic view can be identified by view name is displayed in the “Incremental Table Name” column.

Simply RMB on the record and select “Reset Refresh Status” option.

 

Userlevel 3
Badge +5

Hi Kelum,

I do not see my MV in   “Entity Info – Incremental Load” window (  “Incremental Table Name” column.).

I do not have a MVT related to my MV. Should we create a MVT?  

What steps should I follow to created a MVT?

Thank you!

Userlevel 3
Badge +5

Where can I find well explained steps with an Example on how to create a MV in the correct way so that it will list in the Data Mart Sources in IFS, So that it can be refreshed by assigning it to a refresh category?

 

Thank you!

 

 

Userlevel 7
Badge +18

@manjareed 
Please see the below information. It will hep you

Configure Materialized View Specific Data Mart Load

https://wit.ifsworld.com/f1docs/apps10/default.htm?openpage=https://wit.ifsworld.com/f1docs/apps10/Foundation1/050_development/050_development_tools/020_translation_manager/
 

Manage Data Mart Sources

https://wit.ifsworld.com/f1docs/apps10/foundation1/045_administration_aurena/255_br_and_a/010_information_sources/050_materialized_views/030_manage_mviews/

Best Regards
 

Userlevel 7
Badge +18

Also this will help.

  1. Special Data Mart Source Related Subjects (ifsworld.com)
  2. Data Mart Refresh Recommendations (ifsworld.com)
Userlevel 3
Badge +5

@Himasha Kapugeekiyanage

I am trying to create this MV using the IFS Developer studio in  App Owner schema but do not know the correct steps.

Would you be able to share any documentation on how to create MVs using Developer studio with an simple example?

Thanks in advance!

Userlevel 7
Badge +18

Hi @manjareed 
below Materialized view link helps you
Dimension Data Mart Development (ifsworld.com)