Home > Default > User needs to see only one E&A database for manual data entry

User needs to see only one E&A database for manual data entry

November 30Hits:0
Advertisement
Hi Experts
Please can you suggest a solution for the following requirement.
Requirement is that when a user log in to the Entry & Approval to entry the manual KPIs he should see only the one database which he is allowed to instead of drop-down and select the database which he has to enter the data as multiple models are created to Entry& Approval and Scorecards.
Tried to create model connection for the model and assigned to the user and when i login with that users also all the databases are visible and have to select a database from the list of databases available for entry&approval.
Thanking you,
Regards
Vinay.

Answers

More information, after running a profile trace the following 2 statements, the column with the default on a UDF returns a row while the other default does not.  This might be the cause of this bug.  Is the same logic to generate the object on
the subscriber used to generate the conflict table?  
exec sp_executesql N'
select so.name, schema_name(so.schema_id)
from sys.sql_dependencies d
inner join sys.objects so
on d.referenced_major_id = so.object_id
where so.type in (''FN'', ''FS'', ''FT'', ''TF'', ''IF'')
and d.class in (0,1)
and d.referenced_major_id <> object_id(@base_table, ''U'')
and d.object_id = object_id(@constraint, ''D'')',N'@base_table nvarchar(517),@constraint nvarchar(517)',@base_table=N'[dbo].[repTable]',@constraint=N'[dbo].[DF__repTable__id__117F9D94]'
exec sp_executesql N'
select so.name, schema_name(so.schema_id)
from sys.sql_dependencies d
inner join sys.objects so
on d.referenced_major_id = so.object_id
where so.type in (''FN'', ''FS'', ''FT'', ''TF'', ''IF'')
and d.class in (0,1)
and d.referenced_major_id <> object_id(@base_table, ''U'')
and d.object_id = object_id(@constraint, ''D'')',N'@base_table nvarchar(517),@constraint nvarchar(517)',@base_table=N'[dbo].[repTable]',@constraint=N'[dbo].[DF__repTable__somein__1367E606]'
Pauly C

Read other 3 answers

Tags:

Related Articles

  • A problem with Threads and loops.October 11

    Hi, I have some code that needs to be constantly running, like while(true)       //code here }However, the code just checks to see if the user has input anything (and then if the user has, it goes to do some other stuff) so I don't need it constantly

  • Problem with threads, program always crashOctober 11

    new to threads, may be doing something COMPLETELY wrong. When I run the program I get a couple of NullPointerExceptions in Thread-0 and Thread-1. I'm confused because it screws up when I call size() for arrayList, and in the API size doesn't throw an

  • Problem with threads communicationOctober 11

    Hi All I have a multithreaded application in which I have 3 threads running including main thread. One of the thread (Thread1) spawned by main thread is performing the business logic required. The other one (Thread 2) is just to send the periodic sig

  • Problem with threads hangingOctober 11

    We have a problem where our application stops responding after a few days of usage. Things will for fine for a day or two, and then pretty quickly threads will start getting hung up, usually in places where they are allocating memory We are running W

  • Problem with threads in my swing applicationOctober 11

    Hi, I have some problem in running my swing app. Thre problem is related to threads. What i am developing, is a gui framework where i can add different pluggable components to the framework. The framework is working fine, but when i press the close a

  • Problem with threads in JFrameOctober 11

    Hy everyone...i have a small problem when i try to insert clock in my JFrame , because all i get is an empty text field. What i do is that i create inner class that extends Thread and implements Runnable , but i dont know ... i saw some examples on t

  • New DVR Issues (First Run, Channel Switching, etc.)October 11

    I've spent the last 30 minutes trying to find answers through the search with no luck, so sorry if I missed something. I recently switched to FIOS from RCN cable in New York.  I've gone through trying to setup my DVR and am running into issues and wa

  • It hangs when I login DBOctober 11

    It has no response when I try to login database. I cancel the login since I don't have any choices SQL> connect apps/apps ^CERROR: ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation But it is ok i

  • Pension issue Mid Month LeavingOctober 11

    Dear All, As per rule sustem should deduct mid month joining/leaving/absences or transfer scenarios, the Pension/PF Basis will be correspondingly prorated. But our system is not doing this. In RT table i have found 3FC Pension Basis for Er c 01/2010 

  • Fields in DSO & CubeOctober 11

    Hi experts, I have the field 0fiscyear in my dso and also in the cube. But when creating transformation the field 0fiscyear is present in the dso but not in the cube. So that i am unable to create transformation for 0fiscyear.Anyone please explain me

Copyright (C) 2017 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.144 s.