List of Contributions

Priyanka Joshi

Contact Details

My Content

1 to 20 of 33 total
Posted By Priyanka Joshi Nov 18, 2020 7:00 AM
Found In Egroup: Cognos Analytics
\ view thread
hey, can anyone please let me know meaning of following sentence. BETWEEN FIRST_DAY(((CURRENT_DATE) + (-1) YEAR)) AND CURRENT_DATE ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Jul 14, 2020 7:28 AM
Found In Egroup: Cognos Analytics
\ view thread
It worked . ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Jul 14, 2020 4:18 AM
Found In Egroup: Cognos Analytics
\ view thread
case when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] is not null) then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_PICKUP_DT] is not null) then ([Business Layer].[Dim Logistics Delivery ...
Posted By Priyanka Joshi Jul 14, 2020 3:19 AM
Found In Egroup: Cognos Analytics
\ view thread
XQE-V5-0017 V5 syntax error found for data item 'Final Cmplt Date' of query 'Interims Raw Data', invalid token "when" found after "case when ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] is not null) then ([Business Layer].[Dim Logistics Delivery Parameter].[UNSCCS_DLVRY_DT] ...
Posted By Priyanka Joshi Jul 3, 2020 10:19 AM
Found In Egroup: IBM Business Analytics
\ view thread
case when [SQL1].[MTH_OF_YR]>3 and [SQL1].[YR]=2020 then [SQL1].[AVERAGE_SPEED]='' else [SQL1].[AVERAGE_SPEED] this is not working.i got error RSV-VAL-0010 failed to load specification.XQE-PLN-0001.Internal error. can anyone please let me know what is resolution. ------------------------------ Priyanka ...
Posted By Priyanka Joshi Jul 1, 2020 8:37 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, What is mean by hard coding in cognos report. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Jun 17, 2020 8:43 AM
Found In Egroup: Cognos Analytics
\ view thread
Which of the following statements about the security model is TRUE? Select one: A. Security in IBM Cognos Analytics must use a single namespace B. IBM Cognos Analytics can be configured to use a third-party certificate authority (CA) C. LDAP support must be separately installed in order ...
Posted By Priyanka Joshi Jun 1, 2020 2:10 AM
Found In Egroup: Cognos Analytics
\ view thread
Can anyone please let me know answer for below. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi May 21, 2020 3:03 AM
Found In Egroup: Cognos Analytics
\ view thread
Can we use existing report in cognos dashboard. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi May 8, 2020 1:51 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, Thanks.Actually error was coming because report was referring to data module which was in my content .Data module is not migrated from old server.Now we migrated data module from old server and error is resolved. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi May 7, 2020 3:03 AM
Found In Egroup: Cognos Analytics
\ view thread
It is coming from data module. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi May 6, 2020 5:41 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi All, We have just migrated our cognos to new server and when I am running one report I am getting following error. The relation 'VB_DAILY_CALL_CNTR_METRICS' could not be found in the model. Reason: 'XQE-MSR-0023 'VB_DAILY_CALL_CNTR_METRICS' needs to be in the imported schema 'DDSUSER' in the connection ...
Posted By Priyanka Joshi Apr 15, 2020 5:22 AM
Found In Egroup: Cognos Analytics
\ view thread
Hi, I have created one report which contains 2 select and search prompt and 2 line graphs and 2 crosstabs. In that I need to used conditional block to show 1 set of graph and crosstab when one select and search prompt selected and other set of graph and crosstab when second search and select prompt selected ...
Posted By Priyanka Joshi Mar 31, 2020 3:26 AM
Found In Egroup: Cognos Analytics
\ view thread
Thank you ! ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Mar 30, 2020 7:56 AM
Found In Egroup: Cognos Analytics
\ view thread
When I am running one report i am getting following error. Type a User Id and Password. An attempt to connect to the data source failed" when connecting to DB2 database server via IP address ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Mar 24, 2020 3:52 AM
Found In Egroup: Cognos Analytics
\ view thread
XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))' I am getting this error while replacing exsting packages,actually ...
Posted By Priyanka Joshi Mar 23, 2020 7:10 AM
Found In Egroup: IBM Business Analytics
\ view thread
XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([CLNDR_DT], 'YYYY-MM-DD')between _first_of_month(_add_months(current_date,-1)) and _last_of_month(_add_months(current_date,-1))' I am getting this error while replacing exsting packages,actually ...
Posted By Priyanka Joshi Mar 23, 2020 4:12 AM
Found In Egroup: IBM Business Analytics
\ view thread
Hi All, I have modified my curent report package and when I refreshed that my report showing XQE-PLN-0267 this error for to_date function. XQE-PLN-0267 The argument at position 1 of the function 'to_date' is invalid in filter/slicer expression 'to_date([Business View].[DIM_DT].[CLNDR_DT], 'YYYY-MM-DD')between ...
Posted By Priyanka Joshi Mar 5, 2020 1:38 AM
Found In Egroup: Cognos Analytics
\ view thread
Can anyone pliz let me know what is edge summry in crosstab. ------------------------------ Priyanka Joshi ------------------------------
Posted By Priyanka Joshi Feb 7, 2020 12:10 AM
Found In Egroup: IBM Business Analytics
\ view thread
Can anyone please share you tube links for dimentional modelling concepts in cognos analytics framework manager ------------------------------ Priyanka Joshi ------------------------------