CRN - RS wouldn't allow you to write
tabularmodel1.productid = tabularmodel2.productid(+) in filter condition
2 solution to this:
1. Create 2 Model Query subject and Define Relationship in Framework manager itself or
2. Write the filter this way
tabularmodel1.productid =...
Table definition for the table from which records is to be fetched is:
Business_Unit_ID
Data_item1_new
Data_item2_new
Data_item1_Referal
Data_item2_Referal
Data_item1_External
Data_item2_External
Data_item1_Internal
Data_item2_Internal
This all forms a single record in database. Will this work...
I need to created report like
Business_Unit_ID
---------------------------------
Data_Item1 Data_Item2
New 10 20
Referal 20 30
External 5 15
Internal 10 -10
The left most text is static ('New', Referal, and Inernal etc)
If I create...
Thanks dave, I was knowing about that.But there is nothing I could find for powerrpomts, I have opened a case with cognos also.
Anyways thanks for your suggestion.
Regards
Hi,
We are creating a multiselect prompt for which data being populated using Recordset (Not creating any dynamo).
Our table from which data is being selecetd in recordset has 400 records but the prompt shows only 100 records.
We have found that even recordset is having 100 records in it by...
Hi,
We are creating a multiselect prompt for which data being populated using Recordset (Not creating any dynamo).
Our table from which data is being selecetd in recordset has 400 records but the prompt shows only 100 records.
We have found that even recordset is having 100 records in it by...
We are using PowerPrompts for our report which has catalog folder as 'MyReport'. The report has field named as 'Position' which can have null values. And we need to filter our recrods where Report Field 'Position' is null. We have tried out following options without any sucess...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.