MDS Entity Which Will Be Managed In Excel
Jan 7, 2015
I have an MDS entity which will be managed in excel. I do not want the user to enter the Code and Name so I have configured code to auto generate and name to default to another attribute value. I have then hidden code and name in excel.
When I use excel and enter the attribute and publish, the name column is blank in the MDS table.Am I missing something here with the defaulting?The Action is defined as 'Name Defaults to Country'. Where Country is the attribute I am populating.
View 0 Replies
ADVERTISEMENT
May 8, 2007
I am trying to create an opportunity report that includes notes from the notes entity. Unfortunatly, when I pull the fields from the notes entity into my reports, it seems there is no way to tie the notes to specific opportunities or accounts that they are associated with and I get all notes under the first item listed on my report. Is there a way to link data sets like Access lets you link tables?
View 3 Replies
View Related
Dec 30, 2007
Hello, Why do I receive this error "Cannot add an entity that already exists." I'm trying to add three data at one call using LINQ, after getting the error above then refreshing the page, only one data is inserted.... Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim db As personalDataContext = New personalDataContext Dim p As New personal For i = 0 To 3 - 1 p.name = "Mick" p.number = "01213" p.picture = "image/image.jpg" db.personals.InsertOnSubmit(p) db.SubmitChanges() Next End Sub... cheers,imperialx
View 6 Replies
View Related
Jul 9, 2004
Database newbie question: My sample database (T-SQL syntax): CREATE DATABASE sample GO USE sample CREATE TABLE customers (CustomerId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,name varchar(50),address varchar(50)) CREATE TABLE invoices (InvoiceId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,date datetime,CustomerId int REFERENCES customers(CustomerId)) INSERT customers (name,address) VALUES ('First Company Ltd.','New York') INSERT customers (name,address) VALUES ('Second Company Ltd.','Washington') INSERT invoices (date,CustomerId) VALUES ('Jan 1, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',2) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. New York 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington UPDATE customers SET address='Boston' WHERE name='First Company Ltd.' GO INSERT invoices (date,CustomerId) VALUES ('Jan 3, 2004',1) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. Boston 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 Second Company Ltd. Boston Is it possible in any of the RDBMS's to make this last query return the following result set? 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 First Company Ltd. Boston
View 4 Replies
View Related
Nov 19, 2007
Entity Relationship diagram
can anyone help me with my diagram pleasee..i have been banging my head on it for weeks.
i have 6 entities Student, Course, Module, Attendance, and Result
Polato Student Record System
"The Polato university administration has decided to computerise their student record system. The system must be able to automatically print a new ID card for students on their admission and after completion of each academic year. The card should have the student’s name, number of years and the message welcome to 1st, 2nd or final year.
In a bid to curb the rate of incompletion, the system should also be able to record attendance of students to any class. The system should be able to automatically send out a warning to any student that misses any two lectures for the first time. (Of course the student should come up with a very good reason for missing the lectures or else he/she will be removed from the module). Missing three or more lectures leads to automatic withdrawal from the module involved. A student will receive notice from the system, right after missing the second lecture.
The system also must be able to calculate each student’s results for that semester only showing details of all modules taken. You should use the simple formula; the total of all the modules taken, divided by the number of modules"
charles
View 5 Replies
View Related
Jul 3, 2007
I need to design a schema that will provide me a hierarchical view in reporting. I mean by this is, lets say:
Hospital
|_________> Hospital Entity
| | |
| | V
| | Clinic A
| | - Jane Doe MD
| | - Janette Brown MD
| | ACME Clinic
| | - Jennifer Smith MD
| | Clinic of Jennifer Smith MD
| | - Jennifer Smith MD
| | - Billy Johnson MD
| |
| V
| - Earl Brown MD (Hospital Entity Resident Practitioner)
| - Janette Brown MD
V
- John Smith MD
- Bob Jones MD
The design should also allow me to query a practitioner and the query will show all the entities he or she is a member of.
If this is not the correct place to post this posting, please let me know the correct place and I will make the necessary changes.
Thanks,
Stephen
View 7 Replies
View Related
Jul 7, 2007
I have VS 2005 and SQL Server 2005 Express installed and I created 4 tables and setup the primary and foreign keys and can view the individual foreign key relationships by right clicking on the foreign key.
Is there a way to view a table relationship diagram (fields with primary and foreign keys), such as Access provides. Does VS 2005 or SQL Server 2005 have that capability?
Thanks
View 1 Replies
View Related
Jan 23, 2008
Hi,
I have a table called Posts which contains an attribute Hospital ID. This is a foreign Key to the Hospitals table, which contains two fields : Name & Region.
In my report model, I would like the Hospital ID to be replaced with just the Hospital name. I have set the Hospitals entity to IsLookup=True and the IdentifyingAttribute to Hospital ID. However, in the report builder Hospital ID is still being displayed with no sign of the hospital name.
Can anyone point out where I'm going wrong? I have tried setting the Name field in Hospitals to Role or Merge as I read that using 'name' might cause some problems but that made no difference
View 1 Replies
View Related
Nov 27, 2007
Hello to everyone!
I would like to ask you sthg as far as the e-r model is concerned!
I haven't started of course to use SQL yet,cause i have to make the e-r model first.
I have a a question to make :
For example i have to keep data for a Personal Computer (PC)
So i have the entity : COMPUTER
COMPUTER has many characteristics/fields like the primary key which is going to be PC_ID and it's unique for every computer,NAME_OF_PC the name and also TYPE_OF_MOTHERBOARD, TYPE_OF_RAM, TYPE_OF_HARD_DISK etc.
I have to keep for the TYPE_OF_MOTHERBOARD the manufacturer, the motherboard's code etc.
Shall i make an entity for the motherboard or for the HARD_DISK or for the RAM?
Cause i want next to change these fields of every COMPUTER if it's n eeded!
e.g. i have the PC_ID = 12 and i want to change the hard disk cause it's not working!(shall i keep an entity of the hard disk or not?)
Can sm advise me what i shall do?
Thanks, in advance! :)
View 3 Replies
View Related
Mar 12, 2008
Hi,
I have the following table
(1) Item Table
ItemID Name
1 Sample Item
(2) Brand Table
BrandID Name
1 Sample Brand - 1
2 Sample Brand - 2
(3) ItemBrand Table
ItemID BrandID
1 1
1 2
Desired Output
ItemID ItemName Brand1 Brand2
--------------------------------------------------------
1 Sample Item Sample Brand - 1 Sample Brand - 2
How to get the desired output?
View 2 Replies
View Related
Feb 1, 2008
Hi ,
I created 3 tables in SQL server magmt studio as
student - sno (pk), sname
subjects - subno(pk), subname
marks - sno(fk), subno(fk), marks
While creating the report model:
1.Created the data source - no problem
2. created the data source view - no problem added all 3 tables here.
3. created the report model - only subject and student show up here. Where is the marks table?
Please help
Regards,
Reshma
View 3 Replies
View Related
Mar 13, 2007
Hi,
I'm trying to find out whether it is possible to integrate an external entity into MS SQL Server in following way:
the entity defines certain set of tables
when user performs a query on one of these tables, the query is sent to the entity for processing and results are returned back to SQL server (and to client)
I thought integration services could be used for this task, but I'm quite unfamiliar with MS SQL server, so I don't know whether it would be a feasible solution...
View 4 Replies
View Related
Aug 4, 1998
Hello SQLers,
I`m looking for logical database entity relation diagram builder tools. Anyone have any suggestion or links?
TIA.
View 3 Replies
View Related
Feb 19, 2015
Working in a project using Entity Framework (Code First)...
Until now the project has been connected to a (generated) SQL Server Compact 4.0 database,
but now we want to connect to a SQL Server (at least 2008R2 since we will use FILESTREAM...)
Our problem right now is the possibility to enter Infinity values into REAL columns in the DB...
It works in the SQL Server Compact but we have not been able to get it to work in 2008R2 or 2014
The insertion of Infinity values is constructed by the Entity Framework (from using float.PositiveInfinity in C#) automatically so I mainly wonder if it at all is possible in a "real" database. Maybe there are some configurations possible to get it to work?
View 5 Replies
View Related
Oct 4, 2015
Is it possible to set an entity is update but can't add/delete? I want to control adding/deleting members in SSIS from another source system, but only allow users to change certain attributes.
View 3 Replies
View Related
Oct 11, 2006
Hi,
I am using CRM 3.0 and have a requirement to list all the the tables, attributes names and display names and datatypes. Is there any easy way to export this information from the CRM tool or prepare a SQL query that will list the information?
View 1 Replies
View Related
Jul 6, 2015
My problem seems simple but I can't how to do it with MDS... or even if it's possible !
I've got 2 entities "Agent" and "Function".
"Agent" has a code, a name, and an attribute called "function_code" which refers to "Function"'s code
"Function" as a code and a name. Name is the description of the function.
I'd like to see in a single row :
"Code", "Name", "Funcion_code" and "Name" (the last one from the entity "Function").
In SQL it will something like
Select a.code, a.name, a.function_code, f.name
from agent a, function f
where a.function_code = f.code
I've tried with explicit hierarchy, derived hierarchy, consolidated members...
I was able to have an entity with all those attributes but I can choose the attribute I want. My goal is that, according to "Function_code" in Agent, I get the "Name" of the function...
View 3 Replies
View Related
Apr 11, 2007
Can anyone explain to me why I would choose one over the other? Please provide some simple examples of when I would choose each. Thanks!
View 4 Replies
View Related
Mar 21, 2006
Hello people :-)I'm doing some development work with Visual Studio 2005 and SQLServer 2000. My SQL DB is running on a Windows 2000 Server box in the office, and I'm doing the development on my XPPro workstation. Now I've been trying to connect to the Win2000 box though VS and although I can see the server and the DB when I hit ok I get this error"The SQL server specified by these connection propertise does not support managed objects"What the heck does that mean?any help would be great :-)
View 1 Replies
View Related
Mar 23, 2014
I have a datagridview bound to a table that is part of an Entity Framework model. A user can edit data in the datagridview and save the changes back to SQL. But, there is a stored procedure that can also change the data, in SQL, not in the datagridview. When I try to "refresh" the datagridview the linq query always returned the older cached data. Here's the code that I have tried using to force EF to pull retrieve new data:
// now refresh the maintenance datagridview data source
using (var context = new spdwEntities())
{
var maintData =
from o in spdwContext.MR_EquipmentCheck
where o.ProdDate == editDate
orderby o.Caster, o.Strand
select o;
mnt_DGV.DataSource = maintData;
}
When I debug, I can see that the SQL table has the updated data in it, but when this snippet of code runs, maintData has the old data in it.
View 0 Replies
View Related
Oct 16, 2015
I was able to view the MDS entity through web interface. But now when i click on web interface I am not able to view it from internet explorer and Mozilla firefox. However when I try it from a different laptop with my login I am able to see the MDS entities. I tried reinstalling the Microsoft silver light but am still facing the same issue.I also have all the required access for viewing the entities..Is there any settings that I have to do for the explorer so that I will be able to view the entitites .
View 0 Replies
View Related
Jul 20, 2005
in simple words it's about versioning at record level.ExampleTableEmployee - EmployeeId, EmployeeName,EmployeeAddress, DepartmentId,TableDesignationMap - EmployeeId, DesignationId, EffectiveDate,validityTableDepartment - DepartmentId, DepartmentTableDesignation - DesignationId, designationVia Modify-Employee-Details screen following are editableEmoyeeNameEmployeeAddressDepartmentDesignationthis screen should allow user to navigate through changes history.Example :Version -1EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation AccountantVersion -2EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation Chief Accountant - changedVersion -3EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment Sales - changedDesignation Marketing Manager - changedQuestion :What is the best proposed database design for maintaining historyrecords bound with version and retrieval techniqueBest RegardsSasanka
View 1 Replies
View Related
Dec 16, 2014
Is there any way to set a default date for a member in MDS. My requirement is that business user can enter either current date or future date but not past date.
View 3 Replies
View Related
Nov 20, 2006
I have a SQL Server project in Visual Studio 2005 which deploys an assembly to SQL Server 2005 containing various stored procedures user defined functions. Is there any way to tell Visual Studio to drop/create the stored procedures in a schema other than dbo?
ie: User.ChangePassword instead of dbo.ChangePassword.
View 2 Replies
View Related
Feb 23, 2006
In VS 2003 I used SQLDMO (Com Object) to list all available SQL Servers. Is in SQL Server 2005 a managed .net Component that can do that task?Thanks,Rainer.
View 2 Replies
View Related
Mar 9, 2001
Can anyone explain why when I look at table using enterprise manager, highlight a table, all tasks, maanage indexes why only 1 index appears and when I look at the same table in sysindexes is says that there are 8 indexes.
This is the sql code I executed:
select object_name(id), indid from sysindexes
where object_name(id) = 'tbh_matter_summ'
Is it possible that there is a problem with the database?
TIA,
Philip
View 1 Replies
View Related
Mar 22, 2007
Can anyone point me to a good resource to create managed stored procedures in SQL 2005 Express using VB.NET and VS2003?
View 1 Replies
View Related
Dec 30, 2007
Hi,
I spent the last days programming a managed datamining plugin-algorithmn for SSAS 2005 and have troubles with the Prediction-Method.
Die Prediction-Methode of the "Shell-Algorithm" leads to an error-message on execution of the prediction-query (Internal Error: Unexprected Error ... dmxpredict.cpp Row 205 ...).
Can anyone provide me with a very simple implementation of this Method which just says that for every output-attribute the first (discrete) state should be predicted with a probability of, let's say, 90 % ?
Best Whishes
Manfred
View 5 Replies
View Related
Mar 12, 2007
SQL Server 2005 gives you a possibility to create managed triggers. In a managed trigger I can create a new thread and process trigger event in various ways. My question is that are there any reasons why I should NOT start new threads in database triggers? The following code shows how I could create new threads. Do you see that this could cause any errors or problems in SQL Server functionality? My goal is to minimize the trigger effects in a database overall performance.
'This handles database updates of AdventureWorks Person.Contact table.
<Microsoft.SqlServer.Server.SqlTrigger(Name:="UpdateContact_Trigger", Target:="Person.Contact", Event:="FOR UPDATE")> _
Public Shared Sub UpdateContact_Trigger()
'Notify:
SqlContext.Pipe.Send("Trigger FIRED")
Dim triggContext As SqlTriggerContext = SqlContext.TriggerContext()
'Ensure that it was update:
If triggContext.TriggerAction = TriggerAction.Update Then
'Open a connection:
Using conn As New SqlConnection("context connection=true")
conn.Open()
'Fetch some information about the update:
Using sqlComm As New SqlCommand
sqlComm.Connection = conn
sqlComm.CommandText = "SELECT ContactID, FirstName, LastName from INSERTED"
Using rdr As SqlDataReader = sqlComm.ExecuteReader
If rdr.Read Then
'Process the data in a separate thread. The thread could send a message to MSMQ about the change
'or process if differently. The purpose of using separate thread is avoid performance hit
'in the application / database operation.
Dim oData As New TriggerData("update", rdr.GetInt32(0).ToString, "contact")
Dim trd As New Threading.Thread(New Threading.ThreadStart(AddressOf oData.ProcessEvent))
trd.IsBackground = True
trd.Start()
End If
End Using
End Using
End Using
End If
End Sub
View 2 Replies
View Related
Jul 30, 2014
How to export data from MDS 2012 entity to SQL 2012 user database table ?
View 6 Replies
View Related
Jul 24, 2015
I used "MDSModelDeploy deployclone" do deploy a package with EntityA, EntityB and EntityC to a production environment. I then deleted EntityB from my dev environment and used "MDSModelDeploy deployupdate" do update the model in prodution. After the deployUpdate, EntityB still exists in production. Is there something special I need to do (option of MDSModelDeploy?) in order for the deploy to delete an entity during a migration?
View 1 Replies
View Related
May 22, 2008
While building Report Model Solution in Business Intelligent Studio i am getting following errror-
More than one item in the Entity 'table' has the name 'columns'. Item names must be unique among immediate siblings.
Please advice how to resolve this one.
Thanks
Ashwin.
View 1 Replies
View Related
Aug 24, 2007
Hi there,
Values in my database need to updated periodically. The code, upon starting the application, queries the database and stores the values in the Application collection. This is to avoid making a database call everytime the values are needed (increases performance). The drawback is that changes to the database values are not updated in the code.
How can I create a database trigger that will update the C# Application colllection whenever a table value is updated?
View 2 Replies
View Related
