Thank you! But since my servers are down if i change the password to some other password will the servers come up? Or it just checks whether the account in active status or not.

And the version of Obiee is 12.2.1.0

If the user clicks next it is enough the variables get set and one more thing if we keep some prompt as mandatory in the second page it makes apply button to grey out in the first page by which we can have only one apply button at the second page.

Thank you, Worked like a charm.

Thanks Jerry for the response, However how can we split single dashboard prompt between two pages?? Seems something new for me.

I wanted to review my complete rpd just to make sure i have done everything properly before raising SR with oracle. When i was investigating my BMM layer i have found out that the measure column i have set the aggregation to be sum and then i have created my calculation column like measure*multiplication_factor which was…

Finally found the solution, It was not the table issue, It was more of a repository modelling issue which i have corrected.

My Fact has columns as follows Prod_skey,Date_skey, location_skey, tweleve_month_pd, n_exposure_at_default_at_rcy, Why would i have a dimension for just a multiplication factor i i cant understand, That factor is at the Prod, date, location granularity.

Database Type is Oracle 12c and both the columns are from same table, Seems you didn't understand my fact table structure, I have measures and some factors in my fact table and those factors are needed for calculation.

Both the columns are from same logical table and physical table why obiee is forming two queries

Exactly my question why two sources when my logical table is only one and my physical table is also only one

Logical SQL SELECT 0 s_0, "Loan Loss Forecasting and Provisioning"."F0006 Fct LLFP Account Summary"."Lifetime Pd"*"Loan Loss Forecasting and Provisioning"."F0006 Fct LLFP Account Summary"."Exposure At Default Rcy" s_1 FROM "Loan Loss Forecasting and Provisioning"

only 1 LTS and below is the physical query that got generated select /*+ PARALLEL(T45303 16) */ distinct T45303.N_LIFETIME_PD as c1 from FCT_LLFP_ACCOUNT_SUMMARY T45303 /* Fct LLFP Account Summary */ select /*+ PARALLEL(T45303 16) */ sum(T45303.N_EXPOSURE_AT_DEFAULT_RCY) as c1 from FCT_LLFP_ACCOUNT_SUMMARY T45303 /* Fct…

And i tried not to include any dimension(not in both select and filter) and just did factor*measure that also resulted in two queries, Strange.

What i have observed is my fact has couple of measures such as Sales, Profit etc and couple of factors like multiplying factors at times i need to multiply my measure with the factor, when i go for multiplication obiee is forming two queries first query will have distinct dimensional values which would include my factors…

I have couple of dimensions and only 1 fact, All dimensions are connected to this fact through inner join.