I've requirement to convert the webi report to SQL query. This Webi report has below variable. How do I convert this to SQL statement. I can add this in my SQL SELECT clause. Please help me AMT =sum([V_Ending_Balance]Foreach([Fin_Identifier)*I...

Hello Experts, I've a requirement to convert the webi report in to One SQL and give to to client so they can find the SQL in database and get the results. This WEBI report has 2 Queries and using the MERGE dimension feature. And I've a column ...

I've Two reports both having Multiple data providers and merge dimensions. Created both against same universe. Now the requirement is to create webi report 4 dimension columns and 2 measure/calculated fields from report1 and 1 measure/calculated co...

I've installe BI 4.1 SP4 for QA env. on windows. services are running fine. I'm trying to promote users/gropus/reports from Dev to just installed QA env.But i'm keep getting PARTIAL SUCCSS status for the promotion management jobs. I created job for p...

I've a universe in Information Design Tool 4.1 in Root Folder. I can see it when Try to create New document from BI Launchpad.But could not see when I try to Import from repository.I followed the steps is,Open IDT <> File <> Open Project <> Select Ro...