The shooting of an Edinburgh dog walker is being treated as attempted murder but the motive remains a mystery, police say.